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) == "Нужно");
}
