dos3018 2018-06-18 14:10
浏览 707
已采纳

Php Box / Spout格式单元格到货币和设置宽度

After looking over the documentation for Box/Spout I do not see a way to format cells for currency.

NOTE: PhpExcel and PhpSpreadsheet are not an option.

Is there a way to format a cell?

While styling, is there a way to set the width of the cells?

This is my code so far.
It works, but is lacking currency formatting and width:

$writer = WriterFactory::create(Type::XLSX); // for XLSX files
$writer->openToFile($tmpfile); // write data to a file or to a PHP stream
$writer_sheet = $writer->getCurrentSheet();

$writer_sheet->setName($invoiceSheetName);
$headerStyle = (new StyleBuilder())
  ->setFontBold()
  ->setFontUnderline()
  ->build();

// add header with style
$writer->addRowWithStyle($header, $headerStyle);

$writer->addRows($resultsArray); // add multiple rows at a time
$writer->close();
$excelOutput = file_get_contents($tmpfile);

Documentation: Spout Documentation

Help is greatly appreciated.

  • 写回答

1条回答 默认 最新

  • dongzouhe9734 2018-06-18 18:42
    关注

    Decided to implement my own implementation with unzipping the xlsx file and modifying the correct xml file.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
编辑
预览

报告相同问题?

手机看
程序员都在用的中文IT技术交流社区

程序员都在用的中文IT技术交流社区

专业的中文 IT 技术社区,与千万技术人共成长

专业的中文 IT 技术社区,与千万技术人共成长

关注【CSDN】视频号,行业资讯、技术分享精彩不断,直播好礼送不停!

关注【CSDN】视频号,行业资讯、技术分享精彩不断,直播好礼送不停!

客服 返回
顶部