ExportDataTable

[Brad]

Hello,

I am using this tool to import an excel sheet from a client. I then need to export it to a datatable. However, I am not sure how to only export columns and rows that have data in them, and I can't seem to find a good example. Any help in defining the range would be greatly appreciated.

The excel sheet I'm importing can come from several difference sources and therefore will have an unknown format.

Thanks,
Brad

[Brad]

Nevermind, I have found the answer.
I use the worksheet.UsedRange variable, and it works great.

[Brad]

Ok, I am having another issue with the ExportDataTable Method. Is it possible to set two options? I need it to get the first row as the column header, and to read in the computed formula value rather than the actual formula. However, it appears I can't do this. Any help would be appreciated.

[Melba Winshia]

Hi Brad,

Currently it is not possible to set two options. I have logged a feature request regarding this issue. Sorry for the inconvenience.

Kindly let me know if you have any other questions.

Thanks,
Melba

[Anonymous]

try something like this
sheet.ExportDataTable( ..., ExcelExportDataTableOptions.ColumnNames |
ExcelExportDataTableOptions.ComputedFormulaValues )(

[Melba Winshia]

Hi,

Thanks for your valuable suggestion.

Kindly let me know if you have any other questions.

Thanks,
Melba

[Brad]

I actually ended up doing that, and it works great. Thanks!

>try something like this
sheet.ExportDataTable( ..., ExcelExportDataTableOptions.ColumnNames |
ExcelExportDataTableOptions.ComputedFormulaValues )(

[Melba Winshia]

Hi Brad,

Thanks for the update.

Kindly let me know if you have any other questions.

Thanks,
Melba