problem of copying individual worksheets in separate workbook

Discussion in 'Perl Misc' started by Ratan, Jun 26, 2007.

  1. Ratan

    Ratan Guest

    Hi All,

    I have to write a script which does following task...

    - Open a workbook.
    - Read a worksheet and save it in a new workbook.
    - Repeat step 2 for all worksheets of the original workbook.


    Please help on solution of this.

    Thanks in advance.
    Ratan, Jun 26, 2007
    #1
    1. Advertising

  2. On Tue, 26 Jun 2007 04:26:30 -0700, Ratan <> wrote:

    >Hi All,


    Hi!

    >I have to write a script which does following task...


    I have to write a script which will earn me a pony. Now, where's my
    pony?!?

    >- Open a workbook.


    *What* is a workbook? Too generic a term for me to think of anything
    specific.

    >- Read a worksheet and save it in a new workbook.


    *What* is a workbook? Too generic a term for me to think of anything
    specific.

    >- Repeat step 2 for all worksheets of the original workbook.


    Ditto.

    >Thanks in advance.


    You welcome!


    Michele
    --
    {$_=pack'B8'x25,unpack'A8'x32,$a^=sub{pop^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,
    Michele Dondi, Jun 26, 2007
    #2
    1. Advertising

  3. Ratan

    Ratan Guest

    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.
    Ratan, Jun 26, 2007
    #3
  4. On Tue, 26 Jun 2007 06:16:48 -0700, Ratan <> 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{pop^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,
    Michele Dondi, Jun 26, 2007
    #4
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. appu
    Replies:
    1
    Views:
    562
    Mark Rae
    Jan 5, 2007
  2. Replies:
    4
    Views:
    418
  3. wesley chun
    Replies:
    1
    Views:
    423
    Tom Plunket
    Oct 18, 2006
  4. Fabian Braennstroem

    Re: Adding Worksheets to an Excel Workbook

    Fabian Braennstroem, Oct 11, 2006, in forum: Python
    Replies:
    0
    Views:
    399
    Fabian Braennstroem
    Oct 11, 2006
Loading...

Share This Page