DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)
-   Perl (http://www.daniweb.com/forums/forum112.html)
-   -   Excel formula copy (http://www.daniweb.com/forums/thread52730.html)

msvinaykumar Aug 17th, 2006 4:04 pm
Excel formula copy
 
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::ParseExcel;
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 )

pugnations Nov 11th, 2009 11:30 pm
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?

mitchems Nov 18th, 2009 9:46 pm
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.


All times are GMT -4. The time now is 6:40 am.

Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2009 DaniWeb® LLC