Loading a Spreadsheet with no columns

[uwsgibbons]

I have a spreadsheet which has the data starting on row one. When I open the file it has the column names with the first row. Is there a way to tell it that the spreadsheet has its data starting on row 1 and it should have all the columns as column 1, column 2 ....

[Gary.zhang]

Hello,

Thanks for you inquiry.
Sorry that we don't quite understand your meaning. And there is a way to get the first row the data starts and the column for your reference.

Code: Select all

Workbook book = new Workbook();
book.LoadFromFile("test.xlsx");
Worksheet sheet = book.Worksheets[0];
int i = sheet.FirstRow;
int j = sheet.FirstColumn;
int k = sheet.Columns.Length;


Please feel free to contact us if you have any problems.
Sincerely,
Gary
E-iceblue support team

[uwsgibbons]

The issue I was having was that the column names of the spreadsheet wind up being the first row of the spreadsheet. When I exported to a data table the function errored out as it called the column names as the first row in the spreadsheet which caused duplicate column names which data tables don't like.

To get around this I just inserted a blank row so when I export it to a data table I will have standard column names.

[Gary.zhang]

Hello,

Thanks for your response.
Please proide us your document and codes for testing on our side, it would be helpful to reproduce the issue and work out the solution for you ASAP.
Thanks in advance,
Gary
E-iceblue support team