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

Hi, I am trying to use the Spreadsheet::WriteExcel module to create an excel file. I have a data which I want to write into a single text box, it contains "abc\n dsfg \n rsg" When I write it in the excel sheet, it shows without the newline characters; only when I double click on the particular element, does it place the newline characters. Is there a work around? Thank you, Anant EDIT: Please delete this post, I figured it out. Made use of folowing which made it work:- my $format = $workbook->add_format(); $format->set_text_wrap() ;
  • Comment on Spreadsheet::WriteExcel Newline character

Replies are listed 'Best First'.
Re: Spreadsheet::WriteExcel Newline character
by BaldManTom (Friar) on Oct 06, 2008 at 02:05 UTC
    I'm actually quite glad that this didn't get "deleted," as your update is incredibly valuable. I work with Spreadsheet::WriteExcel quite often, and I'm sure I would have run across this problem myself before long. Thanks, user2000, I'll be bookmarking this node...
      I can second that. Glad that it did not get deleted as I just bumped into the same problem.
        Great that it didn't get deleted and you provided an update even when you got the solution. God Bless.