You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I want to hide specific column in xlsx.
I tried this way 'hidden'=>[1,1,1,1,0,0,0,0] in the writeSheetHeader and writeSheetRow.
But it is hiding the entire row in the xlsx.
`<?php
set_include_path( get_include_path().PATH_SEPARATOR."..");
include_once("xlsxwriter.class.php");
Hi There,
I want to hide specific column in xlsx.
I tried this way
'hidden'=>[1,1,1,1,0,0,0,0]
in the writeSheetHeader and writeSheetRow.But it is hiding the entire row in the xlsx.
`<?php
set_include_path( get_include_path().PATH_SEPARATOR."..");
include_once("xlsxwriter.class.php");
$header = array(
'c1-text'=>'string',//text
'c2-text'=>'@',//text
'c3-integer'=>'integer',
'c4-integer'=>'0',
'c5-price'=>'price',
'c6-price'=>'#,##0.00',//custom
'c7-date'=>'date',
'c8-date'=>'YYYY-MM-DD',
);
$rows = array(
array('x101',102,103,104,105,106,'2018-01-07','2018-01-08'),
array('x201',202,203,204,205,206,'2018-02-07','2018-02-08'),
array('Total',302,303,304,305,306,'2018-03-07','2018-03-08')
);
$writer = new XLSXWriter();
$writer->writeSheetHeader('Sheet1', $header, $style = array('widths'=>[40,50,20,10,40,50,20,10],'hidden'=>[1,1,1,1,0,0,0,0]));
$style = array('widths'=>40, 'hidden'=>[1,1,1,1,0,0,0,0]);
foreach($rows as $row){
$writer->writeSheetRow('Sheet1', $row, $style);
}
$writer->writeToFile(rand(1000,9999).'xlsx-simples.xlsx');
`
Can anyone help me to find a solution?
The text was updated successfully, but these errors were encountered: