Re: Long integers in Spreadsheet::WriteExcel

If it's a database id, write it as a string, not a number. So use write_string instead of write_number.

Comment on Re: Long integers in Spreadsheet::WriteExcel

Replies are listed 'Best First'.
Re^2: Long integers in Spreadsheet::WriteExcel by mrguy123 (Hermit) on Aug 09, 2011 at 09:09 UTC
Problem is I get 1.00000000000265e+15 as output which is still not good for me.	[reply]
Re^3: Long integers in Spreadsheet::WriteExcel by Corion (Patriarch) on Aug 09, 2011 at 09:10 UTC
When needing to write looong identifiers that look like numbers into Excel spreadsheets, I usually prepend a space to them, so that Excel "knows" that they are strings.	[reply]
Re^4: Long integers in Spreadsheet::WriteExcel by mrguy123 (Hermit) on Aug 09, 2011 at 09:17 UTC
OK, this seems like a good and simple solution. Thanks for your help!	[reply]