PHP_XLSXWriter
PHP_XLSXWriter copied to clipboard
mk-j
Lightweight XLSX Excel Spreadsheet Writer in PHP
I have written an app with an Excel output. When I use it with DDEV (PHP 8.2, MariaDB 10.6, otherwise default settings) everything works as desired. However, if I start...
Hi, I need a sheet with two rows followed by a table. This table has a header with filter. This is what it should look like:  You can see...
Hello! This is the output of **/examples/ex02-formats.php** And how it looks when opened in **MS Office 2021**. The problem is only with the date format. How can this be fixed?...
I would like to use number format '# ???/???' to display fractions, but Excel opens with an error. Clicking 'repair' opens the sheet with correct values. How can I solve...
Modified float to string casting conversion in several methods to always use '.' as decimal separator for PHP < 8.0.0 From PHP manual: "As of PHP 8.0.0, the decimal point...
Hi, I find this xlsx package great!! and Thank You. I had noticed that as part of the **writeSheetRow** function the **$row_options** has become partially dynamic. I needed to also...
Some versions of Excel "hides" all used columns because it's missing a `` tag for each column. If you have 20 columns, you must have 20 `` tags with `min`...
I am trying to make a simple example to work, but I have no success. PHP 5.3 It returns: Fatal error: Class 'ZipArchive' not found in /home/renato/dev/php/xlsx-teste/xlsxwriter.class.php on line 101...
在 `writeSheetHeader` 前，执行了`writeSheetRow`，`writeSheetHeader`中的`widths`就会不生效 > Before `writeSheetHeader`, if `writeSheetRow` is executed, `widths` in `writeSheetHeader` will not take effect. ```php $writer = new XLSXWriter(); $widths = [12, 16, 35, 18, 9, 9,...
`$writer = new XLSXWriter(); $colOptions = [ 'font'=>'Arial', 'font-size'=>15, 'font-style'=>'bold', 'halign'=>'center', 'valign'=>'center', ]; $colOptions_1 = [ 'font'=>'Arial', 'font-size'=>13, 'font-style'=>'bold', 'halign'=>'center', 'valign'=>'center', 'border'=>'left,right,top,bottom', 'border-style'=>'thin', 'fill'=>'#d9e1f2', 'string_format'=>'@' ]; $writer->writeSheetHeader('Sheet1', ['xxx'=>'string'],$colOptions); $writer->markMergedCell('Sheet1', 0,0,0,9);...
