dos3018 2018-06-18 22:10
浏览 700
已采纳

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-19 02:42
    关注

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

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

报告相同问题?

悬赏问题

  • ¥100 set_link_state
  • ¥15 虚幻5 UE美术毛发渲染
  • ¥15 CVRP 图论 物流运输优化
  • ¥15 Tableau online 嵌入ppt失败
  • ¥100 支付宝网页转账系统不识别账号
  • ¥15 基于单片机的靶位控制系统
  • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
  • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
  • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
  • ¥15 手机接入宽带网线,如何释放宽带全部速度