Click here to get back home

How to delete excel worksheet in perl?

 HomeNewsGroups | Search | About
 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
How to delete excel worksheet in perl? dd007 05-24-2006
Get Chitika Premium
Posted by dd007 on May 24, 2006, 10:53 am
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
adding an excel worksheet to a generetad excel file via perl April 17, 2007, 8:38 am
Excel worksheet position November 16, 2005, 7:08 am
Win32::OLE - saving content of just one worksheet in Excel January 5, 2007, 5:33 pm
How to make COPY of Worksheet(1) to some other Worksheet ??? January 12, 2008, 4:09 pm
reference of $worksheet obj. January 8, 2005, 11:26 pm
OLE & Excel - Opening causes Excel.exe to hang around April 21, 2005, 1:20 pm
problems writing existing worksheet June 3, 2005, 4:13 am
Spreadsheet::WriteExcel & worksheet->write September 25, 2006, 11:54 am
Can't locate boject methoid Cells via package Sspreadsheet::WriteExcel::Worksheet September 17, 2006, 6:35 pm
Can I do an HTTP DELETE in Perl? February 1, 2006, 1:08 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap