private DataTable GetDataTable(Worksheet item, string range) { ExcelDataSource Eds = new ExcelDataSource(); Eds.Name = item.Name; Eds.FileName = @FileName; ExcelWorksheetSettings worksheetsetting = new ExcelWorksheetSettings(Eds.Name, range); Eds.SourceOptions = new ExcelSourceOptions(worksheetsetting); Eds.SourceOptions.SkipEmptyRows = false; Eds.SourceOptions.UseFirstRowAsHeader = true; Eds.Fill(); DataTable dt = ExcelDataSourceExtension.ToDataTable(Eds); dt.TableName = item.Name; return(dt); }