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.
Up arrow icon