Outputs: Export to Excel includes Content View HTML tables?

enrico68 · January 22, 2013 10:47AM

Hi,

I'd like to ask if it's possible to export a table produced by a Content View script (html like) to an Excel file (including or not including the Content View table formatting).

Thanks

michael · January 22, 2013 12:30PM

Hi Enrico,

Can you try Copy/Paste to Excel or if there are some issues with formatting to OpenOffice Calc?

enrico68 · January 22, 2013 12:44PM

Hi Michael,

I tried cut/paste but it doesn't work. It simply copied all the cells one below the others as reported in the attached file.

It's really important for our users to have the possibility to export data to Excel keeping the script-generated table format.

Is there a way to include the Content View in export to Excel?

Thanks again.

michael · January 22, 2013 12:58PM

Could you try:

1) Make sure that you select the whole table (e.g. you can add some text before and after the table and select it too);

If this doesn't help then

2) Install OpenOffice (http://www.openoffice.org/) and Copy/Paste to OpenOffice Calc, save it as Excel format and then you can use it in Excel.

enrico68 · January 23, 2013 4:10AM

Michael,

I added a character after the table (a space!) and it works!!!
Amazing!!

Thanks

Welcome!

Categories

Ideas Parade

Tagged