Is there anyway in PHPExcel to hide values in an export?

export phpexcel xlsx
user3120521 picture user3120521 · Jan 9, 2014 · Viewed 12.2k times · Source

I would like to be able to get the ID of my record in my sql statement: 

$result = $db->query("select id,FQDN, ip_address, .....");

However, I don't want it to show up in the export using headings: 

$headings = array('Name (FQDN)','Management IP Address', ......");

Is it possible to hide the ID value?
Thanks

Answer

Mark Baker picture Mark Baker · Jan 9, 2014

Columns or rows can be set to "HIDDEN"

$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setVisible(false);

will hide column C

or

$objPHPExcel->getActiveSheet()->getRowDimension(5)->setVisible(false);

will hide row 5

Related questions

phpexcel to download

hello i am new to phpexcel, and i was wondering if there is some way send the excel i have created to the clients download without saving it on my server or to delete it right after he downloads it …

Read More
Do a "git export" (like "svn export")?

I've been wondering whether there is a good "git export" solution that creates a copy of a tree without the .git repository directory. There are at least three methods I know of: git clone followed by removing the .git repository …

Read More
How to export JavaScript array info to csv (on client side)?

I know there are lot of questions of this nature but I need to do this using JavaScript. I am using Dojo 1.8 and have all the attribute info in array, which looks like this: [["name1", "city_name1", ...]["name2", "city_name2", ...]] …

Read More