to write 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
to write 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?