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. Image for the cookie policy date
WEBINAR  Visualize Customer Survey Reports Using Our React 3D Circular Charts Control —Thursday, May 02, 10:00 A.M. ET REGISTER NOW
close icon
  1. Home
  2. Forum
  3. ASP.NET Web Forms (Classic)
  4. Mixed Types

Mixed Types

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?




2 Replies
JB Jim Barry 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


AD Administrator Syncfusion Team March 27, 2008 07:48 AM UTC

Hi Jim,

Thanks for the update.

Regards,
Bhuvana


Loader.
Live Chat Icon For mobile
Up arrow icon