Read specific cells

[Ashymonth]

Hello
I'am new with spire.xls. I have a excel file that contains 10k or more record. He has columns from 1- 18 and i need read only 5-12 and add it to my database. Can someone hepl me and tell how can i do that?

[rachel.lei]

Hello,

Thanks for your inquiry.
The following code demonstrates how to export the data of specified cells to a datatable. If there is any question, please get it back to us.

Code: Select all

    Workbook wb = new Workbook();
    wb.LoadFromFile("test.xlsx");
    Worksheet sheet =  wb.Worksheets[0];
    int startIdx = 5;
    int endIdx = 12;
    //Get the row count
    int rowCount = sheet.LastRow;
    //Get the column count
    int columnCount = endIdx - startIdx + 1;
    //Export the data of specified cells to datatable
    DataTable data = sheet.ExportDataTable(1, startIdx, rowCount, columnCount, false);

Sincerely,
Rachel
E-iceblue support team

[rachel.lei]

Hello,

Greetings from E-iceblue!
Did you test my code? Could you please give us some feedback at your convenience?
Thanks in advance.

Sincerely,
Rachel
E-iceblue support team