• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 934
  • Last Modified:

Using ActiveXObject to open excel within a Mac I/E session

I am presently using ActiveXobject("excel.application") to download data into a excel worksheet from a html page in a Window environment.  I need to make the same thing work in a Mac environment.  

the code is actually:

<SCRIPT LANGUAGE="JavaScript">
<!--  Hide from non-JavaScript enabled browsers ');
'function AutomateExcel()
{
var oXL = new ActiveXObject("Excel.Application");
oXL.Visible = true;
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
var oSheet = oWB.ActiveSheet;
blah, blah....

thanks!
0
cmarshall
Asked:
cmarshall
  • 4
1 Solution
 
ZvonkoSystems architectCommented:
You need no ActiveX to load the worksheet.
Send the worksheet to browser and browser will display the worksheet in Excel.


0
 
ZvonkoSystems architectCommented:
Or if you create the worksheet on the fly, then send it as html <table> and prepend the data with correct Excel MIME type.
0
 
ZvonkoSystems architectCommented:
Here an example from PAQ: http:Q_10226111.html

0
 
cmarshallAuthor Commented:
Can you describe the behavior of this on a Mac?  In my case, it will create a file, but not open the excel spreadsheet automatically.

TIA
0
 
ZvonkoSystems architectCommented:
I do not have access to a Mac.

Also next time think about the advantage of giving grade A ;-)
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now