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
BR
Brad
April 23, 2007 06:33 PM UTC
Nevermind, I have found the answer.
I use the worksheet.UsedRange variable, and it works great.
BR
Brad
April 23, 2007 09:03 PM UTC
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.
MW
Melba Winshia
Syncfusion Team
April 24, 2007 09:26 AM UTC
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
AN
Anonymous
April 24, 2007 11:48 AM UTC
try something like this
sheet.ExportDataTable( ..., ExcelExportDataTableOptions.ColumnNames |
ExcelExportDataTableOptions.ComputedFormulaValues )(
MW
Melba Winshia
Syncfusion Team
April 24, 2007 12:23 PM UTC
Hi,
Thanks for your valuable suggestion.
Kindly let me know if you have any other questions.
Thanks,
Melba
BR
Brad
May 3, 2007 01:43 PM UTC
I actually ended up doing that, and it works great. Thanks!
>try something like this
sheet.ExportDataTable( ..., ExcelExportDataTableOptions.ColumnNames |
ExcelExportDataTableOptions.ComputedFormulaValues )(
MW
Melba Winshia
Syncfusion Team
May 4, 2007 07:02 AM UTC
Hi Brad,
Thanks for the update.
Kindly let me know if you have any other questions.
Thanks,
Melba