Visokio website     Downloads     Video tutorials     KnowledgeBase  
Outputs: Export to Excel includes Content View HTML tables? - Visokio Forums
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
  • 4 Comments
  •     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.
    Attachments
    The original table.docx 557K
  •     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
This discussion has been closed.
← All Discussions

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership