Excel :: Writer :: XLSX在公式中添加了意外的@ [英] Excel::Writer::XLSX adds an unexpected @ in formula

问题描述

我正在使用Excel::Writer::XLSX

use Excel::Writer::XLSX;
my $workbook  = Excel::Writer::XLSX->new( "test.xlsx" );
my $worksheet = $workbook->add_worksheet();
$worksheet->write( 'A1', "4");
$worksheet->write( 'A2', "=ERF.PRECISE(A1/SQRT(2))");

但是当我打开Excel工作表时，我可以在单元格中看到

But when I open my Excel sheet, I can see in the cell

A2:
=@ERF.PRECISE(A1/SQRT(2))

@来自哪里?

推荐答案

而不是-

$worksheet->write( 'A2', "=ERF.PRECISE(A1/SQRT(2))");

使用以下方法:

$worksheet->write( 'A2', "=_xlfn.ERF.PRECISE(A1/SQRT(2))");

查看 Excel 2010及更高版本的公式的文档.

完整脚本:

#!/usr/bin/perl

use strict;
use warnings;

use Excel::Writer::XLSX;

my $workbook  = Excel::Writer::XLSX->new( "test.xlsx" );
my $worksheet = $workbook->add_worksheet();

$worksheet->write( 'A1', "4");
$worksheet->write( 'A2', "=_xlfn.ERF.PRECISE(A1/SQRT(2))");

$workbook->close();

输出:

这篇关于Excel :: Writer :: XLSX在公式中添加了意外的@的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！