error while writing with write_row using Spreadsheet::WriteExcel

Question

I am using Spreadsheet::WriteExcel to write data into excel.
for each row I have used write_row().
When I try to write row having data (=) it throws an error saying:Couldn't parse formula: = ,since excel consider it as formula.
I need to write data using array as one row only so is there any way out to do the same?

Below is the code snippets:

use Spreadsheet::WriteExcel;
my $workbook  = Spreadsheet::WriteExcel->new("../tmp/op.xls");
my $worksheet = $workbook->add_worksheet();
my @data = ('1','1','=',"testdata");
$worksheet->write_row("A1", \@data);         
$workbook->close();

Output:

Couldn't parse formula: = at

serenesat · Accepted Answer · 2015-04-07 07:55:16Z

1

Look at the DIAGNOSTICS section of Spreadsheet::WriteExcel module document, it states that:

Couldn't parse formula ...

There are a large number of warnings which relate to badly formed formulas and functions. See the "FORMULAS AND FUNCTIONS IN EXCEL" section for suggestions on how to avoid these errors. You should also check the formula in Excel to ensure that it is valid.

answered Apr 7, 2015 at 7:55

serenesat

4,72210 gold badges41 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ganesh Over a year ago

thanks for the reply, but i want something tht works with write_row() function and avoid formula errors.

perlboy · Accepted Answer · 2015-04-22 21:57:16Z

1

If you just want an equal sign in that cell and you can live with a little leading white space this will poke a '=' into that row without a formula error:

my @data = ('1','1', ' = ', "testdata");

Works in LibreOffice Calc too.

I'm curious how you intend using that = operator in the SS? Can you build a dynamic Excel formula by dereferencing a cell with an operator in it? Me not an Excel expert :-)

answered Apr 22, 2015 at 21:57

perlboy

1088 bronze badges

Collectives™ on Stack Overflow

error while writing with write_row using Spreadsheet::WriteExcel

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related