Problem with Spreadsheet::ParseExcel


P is for Practical
	PerlMonks

Problem with Spreadsheet::ParseExcel

by ravi45722 (Pilgrim)

on Nov 30, 2015 at 06:34 UTC ( [id://1148858]=perlquestion: print w/replies, xml )

Need Help??

ravi45722 has asked for the wisdom of the Perl Monks concerning the following question:

I am parsing an excel sheet by using Spreadsheet::ParseExcel and parsing a template. In that template I am some formulae of =C2+D2+E2+F2+G2+H2+I2+J2+K2+P2 in s2 & =SUM(C2:R2) in T2 and =S2/T2 in U2.

After parsing and saving the formulae is not evaluating. Its showing 0 in S2 & T2. its showing #DIV/0! for U2. Even I have values in the cells y cant it add.

Is there anything to do to fix this???

Comment on Problem with Spreadsheet::ParseExcel Select or Download Code

Replies are listed 'Best First'.
Re: Problem with Spreadsheet::ParseExcel by poj (Abbot) on Nov 30, 2015 at 15:33 UTC
See known problems in Spreadsheet::ParseExcel::SaveParser `"formulas aren't rewritten, only the result of a formula is written."` poj	[reply] [d/l]
Re^2: Problem with Spreadsheet::ParseExcel by ravi45722 (Pilgrim) on Dec 01, 2015 at 06:27 UTC
Then to write a formulae what we can do???	[reply]
Re: Problem with Spreadsheet::ParseExcel by Anonymous Monk on Nov 30, 2015 at 07:41 UTC
Hi, I think this part is FAQ in the docs where in formulas are not expanded... I leave it up to you to find the cite Cheers	[reply]

Back to Seekers of Perl Wisdom

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: perlquestion [id://1148858]
Approved by Corion
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others making s'mores by the fire in the courtyard of the Monastery: (4)

As of 2024-04-19 13:13 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Today I Learned

Voting Booth^?

No recent polls found