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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Mixed Types

Thread ID:





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

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 05:47 PM UTC

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 07:48 AM UTC

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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon 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.Close Icon