using ExcelDataReader;
using System;
using System.Data;
using System.IO;
public class ExcelReader
{
public static DataTable GetExcelDatatable(string fileUrl)
{
using (var stream = File.Open(fileUrl, FileMode.Open, FileAccess.Read))
{
IExcelDataReader reader;
if (fileUrl.EndsWith(".xls"))
{
reader = ExcelReaderFactory.CreateBinaryReader(stream);
}
else if (fileUrl.EndsWith(".xlsx"))
{
reader = ExcelReaderFactory.CreateOpenXmlReader(stream);
}
else
{
throw new Exception("Invalid Excel file format");
}