Export to Excel - Preserve Data Type as string - eg. leading zeros in numbers.
Options
Hi,
I've found the export to Excel feature really handy, thanks.
Sometimes I deal with strings, that are numbers with leading zeros. For example "000067".
When exported, Excel translates this to the number 67.
Azure Data Studio does this nicely, and exports to Excel the full string.
Can I set Linqpad up to operate in this way ?
Thanks
Paul
Comments
-
The latest LINQPad 8 build has a brand-new Excel engine that generates native .xlsx files.
https://www.linqpad.net/linqpad8.aspx#betaLet me know how you get on.
-
Thanks Joe,
Works a treat