private static void testExcelRangeClient() { using (MSExcelSourceReader rdr = new MSExcelSourceReader(@"C:\Users\sevik\source\repos\TableReaderLib\DemoConsoleAppDotNet\TextSample.xlsx", "TextSample", 3, true)) { TableColumn[] columns = new TableColumn[] { new TableColumn() { Name = "1", IndexInSource = 0 }, new TableColumn() { Name = "2", IndexInSource = 1 }, new TableColumn() { Name = "3", IndexInSource = 2 }, }; var tr = new TableReader(rdr, columns); tr.IsFirstRowHeaders = true; tr.TakeRows = 10; var readQuery = tr.Select(r => new { r0 = r.GetCellValue <int?>(0), r1 = r.GetCellValue <double>(1), r2 = r.GetCellValue <string>(2) }); var readedDat = readQuery.ToList <object>(); //foreach (var r in tr) //{ // var rowValues = new { r0 = r.GetCellValue<int?>(0), r1 = r.GetCellValue<double>(1), r2 = r.GetCellValue<string>(2) }; // readedData.Add(rowValues); //} } }
void ReadThisTableSimple(string filePath) { var excelReader = new MSExcelSourceReader(filePath); var isNeedColumn = new TableColumn() { Name = "Нужна ли строка", IndexInSource = 0 }; var dataColumn = new TableColumn() { Name = "данные", IndexInSource = 1 }; var columns = new TableColumn[] { isNeedColumn, dataColumn }; var tableReader = new TableReader(excelReader, columns); data = tableReader.Where(row => row.GetCellValue <string>(0) == "Нужно"); }