Excel formula copy

Expand Post »

Hi,
I'm using following packages to read and write the excel, But the problem I'm not able to copy the formula from one sheet to other sheet
packages are
use Spreadsheet:

arseExcel;
use Spreadsheet::WriteExcel;

Is there any other packages so that I can copy excel fromula to another excel ( I know I can do copy command but I want to do in perl code )

Similar Threads

Excel vba 6.0 copy date cells date format in Visual Basic 4 / 5 / 6
find duplicates from a spreadsheet file in Computer Science
Trying to create an Excel formula with data from another spreadsheet in Windows Software
Excel formula in Geeks' Lounge

msvinaykumar

Reputation Points: 10

Solved Threads: 6

Light Poster

Offline

48 posts
since May 2006

Permalink

Nov 11th, 2009

Re: Excel formula copy

We use the number stamp for invoices. The info is put on an excel spreadsheet. The past few days the number stamp number on the spreadsheet has been duplicating. Sometimes it lists the same number several times or it skips one or two and copies the same number 2, 3 times. Does anyone know why this is happening?

pugnations

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Nov 2009

Permalink

Nov 18th, 2009

Re: Excel formula copy

I would suggest using OLE instead. It is much more flexible and you can do just about anything. What I do is record a macro in Excel (or another MS app) and "convert it to perl (replacing the dots "." with arrows -> in perl). With OLE you can do just about anything because it is merely a wrapper of the dll.

mitchems

Reputation Points: 26

Solved Threads: 38

Posting Whiz in Training

Offline

293 posts
since Feb 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Perl Forum Timeline: Find and Rename directory

Next Thread in Perl Forum Timeline: Perl's DESTROY and Signal Handling

DaniWeb Message

Cancel Changes

User Name
Password