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

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.

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

报告相同问题?