http://www.perlmonks.org?node_id=582852


in reply to Re: Create a excel sheet with formula ???
in thread Create a excel sheet with formula ???


Thnax .By using ur suggestion i shot out my problem.But if i pass the data by argument then it will only write the last data ,Bcz each call it will create the new file.So i need a formula to append the data .Plz give suggestion

Replies are listed 'Best First'.
Re^3: Appened The Value in excel sheet
by swampyankee (Parson) on Nov 08, 2006 at 18:04 UTC

    I've recently begun using Spreadsheet::WriteExcel. If you're getting a new worksheet each time a sub is called, you may have

    $ws = $workbook -> add_worksheet();

    [download]

    In the sub; this will create a new worksheet on each call, numbering them sequentially (1, 2, .... n). You could pass $ws to the sub, and manage worksheet creation in the calling routine (my preference) or surround the add_worksheet call with some logic so it's not invoked after the first invocation.

    emc

    At that time [1909] the chief engineer was almost always the chief test pilot as well. That had the fortunate result of eliminating poor engineering early in aviation.

    —Igor Sikorsky, reported in AOPA Pilot magazine February 2003.
[reply]
[d/l]
      need a formula for this
[reply]

In Section Seekers of Perl Wisdom