|
Fetty Forest
|
June 12, 2013 at 4:56 am
Dear Support,
Regarding export data into Excel file, we are trying to setting size of Excel columns. Is there any plugin to solve this problem?
Thanks & Regards,
|
|
Dean
|
June 12, 2013 at 5:21 am
Hi,
Unfortunately we cannot set the column width via the sheet itself.
You could try this, it seems a very quick way to autofit the column widths
Tip To quickly autofit all columns on the worksheet, click the Select All button, and then double-click any boundary between two column headings.
Source – http://office.microsoft.com/en-001/excel-help/change-the-column-width-and-row-height-HP010342239.aspx#_Toc280699902
|
|
Fetty Forest
|
June 12, 2013 at 8:42 pm
Hi Dean,
Thank you for the explanation. Meaning every-time we want to export the file to excel, we have to re-size manually? We did this before with another program using this string:
$ex = $objPHPExcel->setActiveSheetIndex(0);
$ex->setCellValue(‘A1’, $sheetTitle);
getActiveSheet()->getColumnDimension(‘I’)->setWidth(15)
Is there anyway we can do this with event espresso? if can, can you guide us?
Looking forward to your reply.
Cheers!
|
|
Dean
|
June 13, 2013 at 1:05 am
Hi,
Yes it would mean a manual resize, but with that tip, it is a 2 or 3 click operation.
The code you have listed seems to be related to http://phpexcel.codeplex.com/ something we dont use in the plugin, we just use the native PHP file handling code.
|
