Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Thousand and decimal separators with Spreadsheet::WriteExcel

by ganeshk (Monk)
on Aug 21, 2008 at 15:13 UTC ( [id://705811]=perlquestion: print w/replies, xml ) Need Help??

ganeshk has asked for the wisdom of the Perl Monks concerning the following question:

I beg your pardon for asking this. But after googling to some extent I couldn't find much and I am also in bit of hurry.

I want to know how to change thousand separator and decimal separator in Excel. I found that in MS Excel 2003 you can do this by changing the settings in Tools->Options->Internationalization tab.

But I just want to confirm that if this is some setting that is be done only on the excel tool and not on the worksheet itself or we can do this international setting on the spreadsheet also. And if it is possible in Excel how can we do it through from Spreadsheet::WriteExcel?

Thanks very much in advance for the help!!

Thanks,
Ganesh
  • Comment on Thousand and decimal separators with Spreadsheet::WriteExcel

Replies are listed 'Best First'.
Re: Thousand and decimal separators with Spreadsheet::WriteExcel
by jmcnamara (Monsignor) on Aug 21, 2008 at 15:39 UTC

    I just want to confirm that if this is some setting that is be done only on the excel tool and not on the worksheet itself

    That is correct. It can only be changed at the system or Excel level.

    It cannot be changed by an Excel file and hence cannot be changed by Spreadsheet::WriteExcel.

    --
    John.

      Thanks very much for the reply.

      Thanks,
      Ganesh
Re: Thousand and decimal separators with Spreadsheet::WriteExcel
by olus (Curate) on Aug 21, 2008 at 15:23 UTC

    Check cell formating on the documentation to see if it helps your intents. Perhaps set_num_format is what you are looking for.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://705811]
Approved by olus
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others chanting in the Monastery: (2)
As of 2024-04-26 00:57 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found