sheet.usedRange.End.column

[Mia Lee]

When I run:

Dim colend As Integer = sheet.UsedRange.End.Column

for this excel sheet, I am getting back 13 columns when there is actually only 6.

Any ideas?

[Melba Winshia]

Hi Mia,

I am afraid. I was unable to reproduce the issue. I used the following test sample to test your issue.

Sample :

Usedrange.zip

Would it be possible to provide me your sample xls file in which you are able to reproduce the issue? It will help me in investigating further on this issue.

Thanks,
Melba

[Administrator]

Dim dtExport As DataTable = sheet.ExportDataTable(9, 1, RowsofData, colend, ExcelExportDataTableOptions.ColumnNames)


I want the column names and am getting this error of more columns (Column1, column2, etc).

If I don''t export in Columnnames, it is fine. The error only occurs when I use ExcelExportDataTableOptions.ColumnNames.

Can you try and see if you can replicate this?

>Hi Mia,

I am afraid. I was unable to reproduce the issue. I used the following test sample to test your issue.

Sample :

Usedrange.zip

Would it be possible to provide me your sample xls file in which you are able to reproduce the issue? It will help me in investigating further on this issue.

Thanks,
Melba

[Melba Winshia]

Hi Mia,

I am afraid. I was unable to reproduce the issue. I used the following test sample to test your issue.

Sample :

DataTable.zip

Please take a look at the sample above let me know if you are able to see the problem in this sample, If not modify the sample to show the problem.

Thanks,
Melba