Re^3: Adding Excel sheet

in reply to Re^2: Adding Excel sheet
in thread Adding Excel sheet

Looking at your original post, I'm a little confused as to why you need to edit a cell. If you use Spreadsheet::ParseExcel::SaveParser you load in your existing spreadsheet then create your new worksheet:

$oBook->AddWorksheet('February');
[download]

To this new blank worksheet first add the cells from the prior month's worksheet that are the same in the new month's worksheet for example:

my $oOld_Sheet = $oBook->{Worksheet}[0];
for (my $row = 0; $row <= 4; $row++) {
    my $oCell = $oOld_Sheet->{Cells}[$row][0];
    if (defined $oCell->{Val}) {
        $oBook->AddCell(1, $row, 0, $oCell->{Val}, $oCell);
     }
 }
[download]

Adding the sales for the new month to the new sheet using the AddCell method as well. Finally save the workbook under a new name using the SaveAs method.

If you really need to edit a cell then Win32::OLE as InfiniteSilence and davidrw mentioned is probably what you will have to use, also if the worksheet you are adding contains formulas.

Comment on Re^3: Adding Excel sheet Select or Download Code

Replies are listed 'Best First'.
Re^4: Adding Excel sheet by Fuism (Beadle) on Oct 19, 2005 at 15:13 UTC
Yes the worksheets contain formulas. For the new worksheet, I need everything to be the same as the previous(format, etc). I just need to replace most of the numbers copied over from the previous worksheet with the numbers from the current month. I will try Win32::OLE.. Thanks again...	[reply]

In Section Seekers of Perl Wisdom