Support for mixed types

mkhuwaja / linqtoexcel

Automatically exported from code.google.com/p/linqtoexcel

0 stars 0 forks source link

Support for mixed types #3

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago

Excel files of mixed types need an extra extended parameter called "IMEX".
 This feature is configured by a set of registry values.

Attached is a patch to support IMEX and sample registry values that scans
all lines and coerces these column types to Text

Original issue reported on code.google.com by steven.f...@gmail.com on 24 Apr 2009 at 5:09

Attachments:

GoogleCodeExporter commented 8 years ago

Can you attach an excel file with mixed types so I can confirm the patch and 
registry settings work.

Original comment by paulyo...@gmail.com on 2 Sep 2009 at 8:02

Changed state: Started

GoogleCodeExporter commented 8 years ago

I fixed this in the upcoming release

Original comment by paulyo...@gmail.com on 2 Nov 2009 at 9:12

GoogleCodeExporter commented 8 years ago

KB article on this setting: http://support.microsoft.com/kb/194124

Original comment by paulyo...@gmail.com on 2 Nov 2009 at 9:12

GoogleCodeExporter commented 8 years ago

This is fixed in the latest version (1.0.50)

Original comment by paulyo...@gmail.com on 3 Nov 2009 at 6:59

Changed state: Fixed

GoogleCodeExporter commented 8 years ago

Thanks a lot. But the same bug does not fix in the excel 2007/2010/2013 xlsx 
format.

Original comment by riemann...@gmail.com on 27 Jul 2012 at 7:53

GoogleCodeExporter commented 8 years ago

@riemannfly I don't know how to fix it in 2007/2010/2013 xlsx. Do you know the 
fix?

Original comment by paulyo...@gmail.com on 27 Jul 2012 at 8:49