473,503 Members | 11,237 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Preserve Formulas

23 New Member
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
Dec 11 '07 #1
2 1214
numberwhun
3,509 Recognized Expert Moderator Specialist
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
Dec 11 '07 #2
manimarank
23 New Member
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
Dec 12 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
2789
by: Scott Castillo | last post by:
Looking for a decent source that has some examples of column formulas as well as a list of column formula functions that can be used and how to use them. Hard time finding something online. Any...
1
1539
by: Sergio | last post by:
Hi, someone knows a place to find the relations formulas for N-Trees? Like in a binary tree if you want the father for some node with index i you just do FATHER = i/N (rounding down) for...
4
2217
by: Sehri | last post by:
Hi all, I have just started developing a math companion tool with VS2005 and I just ran into a problem when trying to add the description of a formula. Doed anyone know how can I add math...
3
2781
by: Carlos Magalhaes | last post by:
Hey All, I am doing some excel automation using the excel COM. I can do most of the functions and its working well until I come across a formula. I can run a formula and insert the formula...
3
1242
by: neil | last post by:
Has anyone had experience programming with functions or formulas that occasionally change? We're working on a pricing app and it would be straight-forward enough to build it with a known formula...
6
2989
by: Martien van Wanrooij | last post by:
Hi all, I have been looking in some forums etc. but cannot find what I would like. I need some financial formulas for a site related to some mortgage issues. Unfortunately the specifications...
1
1744
by: Brian P. Hammer | last post by:
All - I have a project that has a bunch of formulas. I would like to store each of the formulas in a SQL and then load them and have my app execute it. The problem I see is that a Dataset would...
11
1652
by: rob | last post by:
I have the following scenario. A user requests some math calculations from a server. The data and a library of basic formulas reside on the server. Now the user should be able to create more...
4
1774
by: John Brock | last post by:
I have a .NET application that, among other things, creates Excel workbooks, and I have run into a very strange problem involving formulas on one worksheet that reference values on another...
0
7070
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7267
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7316
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6976
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5566
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
4993
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4666
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3148
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
372
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.