Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the pue-sales domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the better-click-to-tweet domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the pue-amazon domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the pue-stats domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the wordpress-seo domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114
Resize the excel columns | Event Espresso - Staging Server

Support

Home › Forums › Event Espresso Premium › Resize the excel columns

Resize the excel columns

Posted: June 12, 2013 at 4:56 am

Viewing 3 reply threads


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

  • Support Staff

    •

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

  • Support Staff

    •

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.
Viewing 3 reply threads

The support post ‘Resize the excel columns’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

The original Forum description...

Status: closed

Updated by Dean 11 years, 9 months ago ago

Topic Tags

Notifications

This topic is: not resolved
Event Espresso - Staging Server