PERL Miscellaneous - Re: problem of copying individual worksheets in separate workbook

Author

Re: problem of copying individual worksheets in separate workbook

Ratan

2007-06-26, 10:03 pm

Sorry for the incomplete info...

Actually i am talking here about a Microsoft excel workbook.

- Open a workbook. [This is Microsoft Excel workbook]
- Read a worksheet and save it in a new workbook. [ By worksheet i
mean to say each of the worksheets in Excel]
- Repeat step 2 for all worksheets of the original workbook [ Save
each of the worksheets in new Excel file i.e. workbook]

Hope that this clarifies the question.

Michele Dondi

2007-06-26, 10:03 pm

On Tue, 26 Jun 2007 06:16:48 -0700, Ratan <ra10kumar@gmail.com> wrote:

>Actually i am talking here about a Microsoft excel workbook.
[snip]
>Hope that this clarifies the question.

It clarifies it in way that makes me sure I can't help you but
possibly pointing you to modules like Spreadsheet::ParseExcel,
Spreadsheet::WriteExcel or perhaps on a more general basis Win32::OLE.
None of which I really know anything about.

Michele
--
{$_=pack'B8'x25,unpack'A8'x32,$a^=sub{po
p^pop}->(map substr
(($a||=join'',map--$|x$_,(unpack'w',unpack'u','G^<R<Y]*YB='
..'KYU;*EVH[.FHF2W+#"\Z*5TI/ER<Z`S(G.DZZ9OX0Z')=~/./g)x2,$_,
256),7,249);s/[^\w,]/ /g;$ \=/^J/?$/:"\r";print,redo}#JAPH,

Sponsored Links