Perl

Perl RSS

Excel formula copy

•

Join Date: May 2006

Posts: 38

Reputation: msvinaykumar is an unknown quantity at this point

Solved Threads: 2

msvinaykumar msvinaykumar is offline

Offline

Light Poster

Excel formula copy

Aug 17th, 2006

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 )

•

Join Date: Nov 2009

Posts: 1

Reputation: pugnations is an unknown quantity at this point

Solved Threads: 0

pugnations pugnations is offline

Offline

Newbie Poster

13 Days Ago

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?

•

Join Date: Feb 2009

Posts: 57

Reputation: mitchems is an unknown quantity at this point

Solved Threads: 2

mitchems

Offline

Junior Poster in Training

6 Days Ago

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.

And don't tell me there isn't one bit of difference between null and space, because that's exactly how much difference there is.

Larry Wall