C# (CSharp) ReadExcelKit.ReadDataTable Examples

Example #1

File: BenchmarkExcelRead.cs Project: BigBigZBBing/BigCookieKit

        public void OpenXmlRead()
        {
            ReadExcelKit excelKit = new ReadExcelKit(@"C:\Users\zbb58\Desktop\test.xlsx");

            excelKit.AddConfig(config =>
            {
                config.SheetIndex    = 1;
                config.ColumnNameRow = 1;
                config.StartRow      = 2;
            });
            DataTable dt = excelKit.ReadDataTable();
        }