Export to Excel - Preserve Data Type as string - eg. leading zeros in numbers.
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#beta
Let me know how you get on.
Thanks Joe,
Works a treat