Export2Excel multiple charts using JavaScript

Mon, 26 Sep 2011 14:24:57 GMT

Hi All,

I am trying to write a JavaScript Macro to export multiple charts data to an excel, but its giving error at CopyTableToClipboard, not sure whether I am doing correct or not, please help me in this

This is the code I am using & also attached error & sample qvw app.

function print_excel()
{

var objXL = new ActiveXObject("Excel.Application");
var objWB = objXL.Workbooks.Add();
var objWS = objWB.ActiveSheet;

//var obj = document.getElementById("TB01")
var obj = ActiveDocument.GetSheetObject("TB01");
var XLSheet = objWB.Worksheets(1);
obj.CopyTableToClipboard = true;
XLSheet.Paste;

//objWS.Range("A1", "L1").Font.Bold = true;

objWS.Range("A1", "Z1").EntireColumn.AutoFit();

//objWS.Range("C1", "C1").ColumnWidth = 50;

objXL.Visible = true;

}

Thanks in Advance

Export2Excel multiple charts using JavaScript

Tue, 27 Sep 2011 19:14:26 GMT

Any help?

Re: Export2Excel multiple charts using JavaScript

sadickbasha — Fri, 05 Apr 2013 09:11:17 GMT

Use that line as per below

obj.CopyTableToClipboard(1)

Thanks

Sadick

topic Re: Export2Excel multiple charts using JavaScript in QlikView

Export2Excel multiple charts using JavaScript

Export2Excel multiple charts using JavaScript

Re: Export2Excel multiple charts using JavaScript