Visual LANSA Forum

Hi,

This is for Visual LANSA Version 14 SP2. We are serving WAMs and VLF-WEB off of a Windows server.

I would like to use std_toexcel for a project, that seems to be perfect for, from what I'm reading from the LANSA V14 documentation on Standard Weblets, Chapter 8 - Weblets for XHTML Technology Service.

I'm trying to use the Standard Weblet std_toexcel, on a WAM, to export a list from a Grid I will build from a filter search. I believe this is making a table (tubular data) that the documentation mentions for use of this Weblet.
I'm following all the documentation I can find, placing std_toexcel on the design tab, setting the listname to my GRID List, that I want to make exportable.

I'm not sure what to expect when clicking the 'Export To Excel' button. I expected, possibly a new Excel Spreadsheet to open with my data.

Also, I made sure Activex Controls and Plugins are enabled, in Internet Explorer. Using IE11, and I know there's a possible security issue with that when ActiveX Controls and Plugins are disabled, but I can click the button fine (not disabled). It's just that nothing happens in response.

Any help is much appreciated.

If there is an error trying to use ActiveX it should pop an alert box indicating an error. Maybe there is an error beforehand. Look at your Javascript console.

BTW, you should consider moving away from using ActiveX (and IE).

Cheers
Abel

AbelS wrote: Fri Nov 08, 2019 1:47 pm BTW, you should consider moving away from using ActiveX (and IE).
Cheers
Abel

This worries me too. What replaces integrating with Word & Excel for VL Win?

Not VL Win. Just talking about ActiveX inside the browser.

PS: Tested std_toexcel on V14SP2. It works (in IE11 with the proper security settings lowered to enable ActiveX). So, likely something else is breaking earlier and the Javascript to export to Excel is not being run.

Cheers
Abel