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.

Mixed Types

Thread ID:





70828 Jan 3,2008 11:12 AM Mar 27,2008 03:48 AM ASP.NET Web Forms (Classic) 2
Tags: XlsIO
Jim Barry
Asked On January 3, 2008 11:12 AM

When using the IWorksheet.ImportDataTable call, varchar columns that contain numeric-only values are having leading zeros truncated.

Is there a way to get XLSIO to support the registry key of HKey_Local_Machine/Software/Microsoft/Jet/4.0/Engines/Excel/ImportMixedTypes?

Jim Barry
Replied On January 3, 2008 12:47 PM

OK, Solved my own problem...

I had to set the bPreserveTypes flag to true in my call to ImportDataTable

Administrator [Syncfusion]
Replied On March 27, 2008 03:48 AM

Hi Jim,

Thanks for the update.



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.