How to write a line starting with '=' in a cell using a table: WriteExcel

Question

I am using the Perl Spreadsheet :: WriteExcel package to write an Excel file. I want to write a line that starts with the equal sign "= ABC ()" in a cell.

 $ws->write('A1', '=ABC()');

But I got an error message

 Unknown function ABC() in formula

Can anyone advise?

Answer 1

Use the method write_stringdirectly instead of using write:

$ws->write_string('A1', '=ABC()');

The table method :: WriteExcel write is a convenience method that guesses what data you are trying to save. If it is wrong, you should use one of the type methods.

Answer 2

@Cjm . , , , , .