Skip to Content

Part  1 of Blog Series – New Features @ Visual Composer 7.01

 

One of the most demanded features for a new version of NW Visual Composer is an easy “Export to Excel” system function; here you have an example of the newest functionality:

Fist at all we have a very simple model like this:

On the table UI element, we edit the toolbar and add a button with name “Export to Excel”:

 

 

Then, we have to select the type of system action “Export Data to Excel”:

 

 

But of course, we have to indicate the coverage of this action, by selecting:

 

 

 

And this is all that we have to do in the modeling to export the data contained in a table to Excel.

But, let’s have a look about what is happening in the runtime; first we compile and deploy our model :

 

Then, we click over the button “Export to Excel” and select if we want to open or save the resulting file:

 

now we can play with the results in Excel:

To report this post you need to login first.

9 Comments

You must be Logged on to comment or reply to a post.

  1. Guillaume GARCIA
    Hi,

    In the screenshot, we can see that there is some formatting (borders, bold on column titles).
    Is it performed by the export tool itself?
    Does it mean that the export format is in fact HTML but that the file is suffixed with .xls?

    Thanks in advance for your answer.

    Guillaume

    (0) 
    1. Bernd Eckenfels
      Excel files contain formattin and style information. I think you have been thinking about CSV which does not allow any formatting (and needs more steps to open it in Excel).
      (0) 
    2. Bernd Eckenfels
      Excel files contain formatting and style information. I think you have been thinking about CSV which does not allow any formatting (and needs more steps to open it in Excel).
      (0) 
  2. Rahul Urs
    Yes ! this is the new feature in comparison to what we had previously where “copy to clipboard” was used and we had to open a new excel sheet and paste or cntrl+v on the excel Vs what we have is the excel popping out without starting a new excel document…however the author hasnt mentioned one little thing which I want to tell you folks. most browsers may be missing certain settings which will prevent the excel to be exported and the solution is:
    To prevent Information bar from blocking file and software downloads like excel sheets.
    1.  Open Internet Explorer.
    2.  Click the Tools button, and then click Internet Options.
    3.  Click the Security tab, and then click Custom level.
    4.  Do one or both of the following:
        *   to turn off the Information bar for file downloads, scroll to
    the Downloads section of the list, and then, under Automatic prompting
    for file downloads, click Enable.
        *   To turn off the Information bar for ActiveX controls, scroll to
    the ActiveX controls and plug-ins section of the list, and then, under
    automatic prompting for ActiveX controls, click Enable.
    5.  Click OK, click Yes to confirm that you want to make the change,
    and then click OK again.
    (0) 
  3. Luis Felipe Lanz Post author
    Hi Modelers!

    Thanks for your comments, here you have my answers:

    @ Rahul: Thanks a lot for your comments and details

    @ Guillaume: Yes it’s made by the system action directly, it will take the format given to the VC Table and will transfer it to Excel (not HTML suffixed at all) 🙂

    @ Bernd: Thanks for the comments!

    I’m looking forward to read your comments in the entire series too.

    Kind Regards,
    Luis

    (0) 
  4. Anonymous
    Hi Luis,
    great blog. Thanks for this comprehensive insight in EHP1. Just one question: Can I export any data contained in the table (for example comments with more than 60 characters) or is only the exported that comes directly from the query?

    Thanks in advance and Kind Regards,
      Benni

    (0) 
  5. Paul Stoltz
    Is there an oss note or patch that we can apply to our 7.01 system that will provide us this new capability? We are planning an upgrade but not for another 9-12 months.
    (0) 
  6. Kelly Qu
    Thanks for this blog. It’s very helpful.

    However, I found when tried to export a table with around 3000 rows, it became significantly slow.

    Is there a way to tune this feature to make it download faster? Or, add a downloading status bar so that users would know it’s still downloading?

    Kelly

    (0) 

Leave a Reply