Results 1 to 2 of 2

Thread: excel file

  1. #1
    Join Date
    May 2004
    Posts
    21

    Question Unanswered: excel file

    I have a perl script that executes the stored proc in 10 different databases, puts results in excel file and emails it. the problem is that if value of the field starts with 0 it gets truncated in spreadsheet. I.e. 0098789 will be displayed as 98789.
    Is the any way around it?

  2. #2
    Join Date
    Jan 2004
    Location
    Germany
    Posts
    167
    I would recommend to use the Spreadsheet::WriteExcel-module. In this module a method, named set_num_format(), is implemented that meet your needs...

    See: http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.02/lib/Spreadsheet/WriteExcel.pm#set_num_format()
    board.perl-community.de - The German Perl-Community

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •