Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > perl > answers

Preserve Formulas

Newbie
  
Join Date: Jul 2007
Location: chennai
Posts: 22
#1: Dec 11 '07
Hi,

Good day to all !!!

Is there any module to preserve the formulas while editing the Excel files using perl?
Pls Help me.

Regards,
Mani
numberwhun's Avatar
Site Moderator
  
Join Date: May 2007
Location: New Hampshire
Posts: 2,569
#2: Dec 11 '07

re: Preserve Formulas

Quote:

Originally Posted by manimarank

Hi,

Good day to all !!!

Is there any module to preserve the formulas while editing the Excel files using perl?
Pls Help me.

Regards,
Mani

I have not worked with Excel spreadsheets with Perl, but have you searched CPAN to see what you find?

Regards,

Jeff
Newbie
  
Join Date: Jul 2007
Location: chennai
Posts: 22
#3: Dec 12 '07

re: Preserve Formulas

Quote:

Originally Posted by numberwhun

I have not worked with Excel spreadsheets with Perl, but have you searched CPAN to see what you find?

Regards,

Jeff

Hi Jeff,

Spreadsheet::ParseExcel and Spreadsheet::WriteExcel::SaveParser module are used to Parse as well as edit the Excel Sheet.
But the problem is formulas exist in the Excel sheet got deleted while modifing the Excel file.

Regards,
MM
Reply

« previous question | next question »

Similar Perl bytes

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,374 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved