pankaj - Friday, August 1, 2014 3:26 AM:
Could anyone help me in exporting HTML data to excel without ActiveX.
I tried the following code
var html = window.document.documentElement.outerHTML;
opener.top.aras.saveString2File(html, "export2Excel");
Above code export the html data to excel but Grid lines and images are not displaying in Excel.
Any suggestions on this?
Pankaj B
zahar - Sunday, August 3, 2014 5:08 AM:
Attached example of file that created with:
opener.top.aras.saveString2File(html, "export2Excel");
DavidSpackman - Sunday, August 3, 2014 8:34 PM:
Hi Pankaj,
What are you trying to achieve with your export?
Where / How are you running your code?
Dave
pankaj - Sunday, August 3, 2014 10:30 AM:
Zahar,
What you are trying to say.
Pankaj B
pankaj - Monday, August 4, 2014 12:29 AM:
Hi David,
Thanks for your reply.
In Report ==> Stylesheet tab, I had written my code.
In Reports I created a HTML button ==> OnClick ==> Function to Export html data to Excel.
Now i am able to get Gridlines in Excel but i am unable to export image to Excel.
Reason behind image not exporting is if i include base tag manually it will get export but i need to include Dynamically.
In this way image tag is there <img src="../images/Logos/image.gif" height="60"></img>.
Waiting for your quick response.
Pankaj B
DavidSpackman - Monday, August 4, 2014 4:06 AM:
Hi Pankaj,
There are functions to get the url if that's all you require?
Example
var directory = top.aras.getWorkingDir();
var url = top.aras.getServerBaseURL();
var base = top.aras.getBaseURL();
var r0 = top.aras.getLoginName();
var r1 = top.aras.getUserType();
var r2 = top.aras.isAdminUser();
var r3 = top.aras.getUserID();
var r4 = top.aras.getDatabase();
var r5 = top.aras.getIdentityList();
pankaj - Monday, August 4, 2014 5:17 AM:
Hi David,
Thanks for your reply.
The code which you posted is working as expected.
but while opening an excel i am getting an following "alert" as shown in below picture.
Without Excel setting,IE setting or Registry setting i want to achieve. Through XSLT or XML setting is it possible?
Could you please suggest me on this.
Pankaj B
DavidSpackman - Monday, August 4, 2014 8:20 AM:
Hi Pankaj,
Are you are using export2Excel function?
If so, then the output data is not standard xls. Anything exported from Aras to Excel will have the same error
Dave
DavidSpackman - Monday, August 4, 2014 7:02 PM:
You find the code that performs the export here
InnovatorClientjavascriptaras_object.js
pankaj - Monday, August 4, 2014 11:59 PM:
Hi David,
Even i got the code from aras_object.js
But my concern about Prompt before opening Excel. I am trying to work with xml or xslt.
I cracked that prompt by adding registry but i don't want to do with that.
Pankaj B
DavidSpackman - Tuesday, August 5, 2014 1:10 AM:
The Aras export data is saved as xml, but the file name is xls. (Rename to a .xml and open in excel, you can open with no error, but not many people open xml files with Excel...)
As far as I know it's not possible to overcome without relaxing the Extension Hardening registry settings, as you have confirmed works on a per client basis.
