Click here to get back home

reference of $worksheet obj.
 Home | NewsGroups | Search | About
Login Password
Register Now!
 comp.lang.perl.misc    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
reference of $worksheet obj. sam 01-08-2005
Posted by sam on January 8, 2005, 11:26 pm
Please log in for more thread options
>>
>> [snip]
>>
>> > if I print "$1\n",
>> > the file prints just fine. But, if I do something like print "$1 after
>> > \n", the whole output is messed up. If I print "before $1\n", nothing
>> > prints at all. If I print "before $1 after\n", only after prints.
>>
>> not really sure, but could be a rogue "\r" in $1,


> There
> is a rogue carriage return (0xd) in the string

> Is there something I can do to deal with this
> situation?


Repair the corrupted file:

perl -p -i -e 'tr/\r//d' bad_file


--
Tad McClellan SGML consulting
tadmc@augustmail.com Perl programming
Fort Worth, Texas

Posted by Todd W on January 8, 2005, 3:44 pm
Please log in for more thread options
>>
>> [snip]
>>
>> > if I print "$1\n",
>> > the file prints just fine. But, if I do something like print "$1 after
>> > \n", the whole output is messed up. If I print "before $1\n", nothing
>> > prints at all. If I print "before $1 after\n", only after prints.
>>
>> not really sure, but could be a rogue "\r" in $1,


> There
> is a rogue carriage return (0xd) in the string

> Is there something I can do to deal with this
> situation?


Repair the corrupted file:

perl -p -i -e 'tr/\r//d' bad_file


--
Tad McClellan SGML consulting
tadmc@augustmail.com Perl programming
Fort Worth, Texas

Similar ThreadsPosted
How to make COPY of Worksheet(1) to some other Worksheet ??? January 12, 2008, 4:09 pm
Excel worksheet position November 16, 2005, 7:08 am
problems writing existing worksheet June 3, 2005, 4:13 am
How to delete excel worksheet in perl? May 24, 2006, 10:53 am
Spreadsheet::WriteExcel & worksheet->write September 25, 2006, 11:54 am
Win32::OLE - saving content of just one worksheet in Excel January 5, 2007, 5:33 pm
Can't locate boject methoid Cells via package Sspreadsheet::WriteExcel::Worksheet September 17, 2006, 6:35 pm
adding an excel worksheet to a generetad excel file via perl April 17, 2007, 8:38 am
I'm confused by reference to reference in my code February 6, 2006, 6:03 pm
Passing a reference as a reference August 16, 2007, 1:04 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap