From: "Dan Muey" <[EMAIL PROTECTED]> > I think unix uses \n and winders uses \n\r so you may need to use \n\r > or \r instead of \n
It should be \r\n (also read CRLF). And Macs (the old ones) used \r. > From: Paul Kraus [mailto:[EMAIL PROTECTED]] > > I wrote a script that generates an excel file. I tested it on > a windows xp pro machine and everything was ok. When I put > the script on the UNIX server and run it I get blocks on my > excel sheet where new lines occurred. How can I have the UNIX > Perl write out Microsoft new line characters so that the > excel sheet looks normal? You need to use \r\n instead of \n in the strings you put into the sheet. Or run them through something like $string =~ s/(?:\x0D\x0A?|\x0A)/\x0D\x0A/sg; # this turns the end of lines in any of the three formats to \r\n Though IMHO the module should take care of this itself. Jenda ===== [EMAIL PROTECTED] === http://Jenda.Krynicky.cz ===== When it comes to wine, women and song, wizards are allowed to get drunk and croon as much as they like. -- Terry Pratchett in Sourcery -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
