We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

ExportDataTable

Thread ID:

Created:

Updated:

Platform:

Replies:

59822 Apr 23,2007 01:17 PM May 4,2007 03:02 AM ASP.NET Web Forms (Classic) 7
loading
Tags: XlsIO
Brad
Asked On April 23, 2007 01:17 PM

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
Replied On April 23, 2007 02:33 PM

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

Brad
Replied On April 23, 2007 05:03 PM

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 [Syncfusion]
Replied On April 24, 2007 05:26 AM

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
Replied On April 24, 2007 07:48 AM

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

Melba Winshia [Syncfusion]
Replied On April 24, 2007 08:23 AM

Hi,

Thanks for your valuable suggestion.

Kindly let me know if you have any other questions.

Thanks,
Melba

Brad
Replied On May 3, 2007 09:43 AM


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

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

Melba Winshia [Syncfusion]
Replied On May 4, 2007 03:02 AM

Hi Brad,

Thanks for the update.

Kindly let me know if you have any other questions.

Thanks,
Melba

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;