Using ActiveXOjbect and javascript to save a sheet with excel

Question

Im using Javascript and ActiveXObject’s, look at this link here. I’m using ActiveXObject's to open an Excel file do some logic and save the file. What I need to accomplish is to open an Excel workbook that has multiple sheets, and save one of the sheets as a new Excel workbook(newfile.xlsx). This code below does exactly what I need it too except it saves as a CSV instead of a XLSX. I've tried using other numbers with the SaveAs() function, such as 1,4,8, I tried true. Some of those worked but none of them gave me the results I'm expecting. Is this type of task even possible to accomplish with ActiveXObject's and javascript? Any help is greatly appreciated!

/** IE 11 Only! **/
// ActiveXObject Example
var Excel = new ActiveXObject("Excel.Application");
Excel.DisplayAlerts = false;
var Book = Excel.Workbooks.Open(output_path+"file.xlsx");
Book.Worksheets("Sheet3”).SaveAs(output_path+"newfile.xlsx",6);
Excel_LI.DisplayAlerts = true;
Excel_LI.Quit();

xarxziux · Accepted Answer · 2016-07-04 23:52:37Z

1

Your answer is probably here somewhere, but there's a lot of different flavours of Excel listed. You may need some trial and error to figure out the one you need.

answered Jul 4, 2016 at 23:52

xarxziux

3714 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

NodeDeveloper102 Over a year ago

Yup I found this site too, unfortunately the answer isn't obvious. However I managed to figure out, It's a 2. Thanks for your help @xarxziux

Collectives™ on Stack Overflow

Using ActiveXOjbect and javascript to save a sheet with excel

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related