excel format problem

[mark4444az]

Hi Monks, I have an issue where I am writing a hex value to an Excel spreadsheet and it looks like when there's an "e" in the number the Excel is changing it to Scientific Notation. So this number:83834e82 gets changed in Excel to:8.3834E+82. As I understand it Excel should default to General format, even still I added some code:

 my $right  = $workbook->add_format(align => 'right');
   my $num_format = $workbook->add_format();
   $num_format->set_num_format('general');

And when I do the actual write:

$worksheet1->write($row_num, $col_num, $hex_data, $right, $num_format)
+;
<

Has anyone else encountered this?

[choroba]

How should Excel know the value is a hex number? Use hex:

$worksheet1->write($row_num, $col_num, hex $hex_data, $right, $num_for
+mat);

[AppleFritter]

Can't say I've ever worked with Excel, so this is just a random stab in the dark, but - have you tried formatting your number as 0x83834e82 or 83834e82h? Maybe that'll help.

[Laurent_R]

I don't think this will work, but, on the other hand, Excel has a HEXDEC conversion function which might work. But I really think that converting the hex number into decimal notation in Perl prior to loading it to Excel, as suggested by choroba will be much easier.

[davies]

Excel's hex converter certainly used to be limited to numbers less then 512. I also believe that the OP is using Spreadsheet::WriteExcel or something from that stable rather than Win32::OLE, otherwise I would rush my BigInt xla out & suggest he used that, but I understand that it's a problem importing modules into Excel files using S:WE or its derivatives.

Regards,

John Davies

[bulrush]

Spreadsheet::WriteExcel write() function makes a guess as to what kind of data you are writing. For the hex data, do not use write(), and instead write it as a string with: write_string($row, $column, $string, $format).