> -----Original Message----- > From: Chas. Owens [mailto:[EMAIL PROTECTED] > Sent: 21 November 2008 13:13 > To: Manasi Bopardikar > Cc: beginners@perl.org > Subject: Re: need help with SpreadSheet::Parse perl module > > On Fri, Nov 21, 2008 at 07:33, Manasi Bopardikar > <[EMAIL PROTECTED]> wrote: > snip > > in the above code I get the max row count of my sheet by reading it > using > > the Spreadsheet::ParseExcel::Workbook module of cpan. > > > > then I want to open the same tablle2sheet.xls for writing.but currently > I am > > not able to find any module which allows me to do that. > snip > > I don't believe there is a module that allows arbitrary editing of an > Excel spreadsheet (but I have not done an exhaustive search of CPAN > for one in a while). Spreadsheet::ParseExcel allows you to read an > existing file and Spreadsheet::WriteExcel allows you yo write a new > file. The only way I know of to create the illusion of an arbitrary > edit is to use both together to copy the data from the old file to a > new file making changes as needed, unlink'ing the old file, and > rename'ing the new file to the old file's name. > > Well, that isn't 100% true; if you are on a Windows machine that has > Excel installed you can use Win32::OLE to make Excel make your changes > for you. > > -- > Chas. Owens > wonkden.net > The most important skill a programmer can have is the ability to read. > > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > http://learn.perl.org/ > You can use Spreadsheet::WriteExcel to generate an Excel workbook. It has methods to add sheets and cell data and also lots of methods for formatting etc.
The CPAN documentation is very clear and you will be able to use examples straight off the docs for a prototype. HTH Stu Information in this email including any attachments may be privileged, confidential and is intended exclusively for the addressee. The views expressed may not be official policy, but the personal views of the originator. If you have received it in error, please notify the sender by return e-mail and delete it from your system. You should not reproduce, distribute, store, retransmit, use or disclose its contents to anyone. Please note we reserve the right to monitor all e-mail communication through our internal and external networks. SKY and the SKY marks are trade marks of British Sky Broadcasting Group plc and are used under licence. British Sky Broadcasting Limited (Registration No. 2906991), Sky Interactive Limited (Registration No. 3554332), Sky-In-Home Service Limited (Registration No. 2067075) and Sky Subscribers Services Limited (Registration No. 2340150) are direct or indirect subsidiaries of British Sky Broadcasting Group plc (Registration No. 2247735). All of the companies mentioned in this paragraph are incorporated in England and Wales and share the same registered office at Grant Way, Isleworth, Middlesex TW7 5QD. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/