Answered
Accessing Excel data from Indesign CS6 with js
Hi,
I need to read Excel data from Indesign CS6 with js. And what I found so far is not working:
readData(x,y);
// https://social.msdn.microsoft.com/Forums/windowsdesktop/en-US/783724f0-526d-4c1d-a565-ebcdbca83cb8/how-to-read-excel-file-using-javascript?forum=sidebargadfetdevelopment
function readData(x,y){
var excel=new ActiveXObject("Excel.Application");
excel.Workbooks.Open(myFilePath);
//var excel.workbooks.open(myFolderPath);
var data = excel_sheet.cells(x,y).value; //x,y consider the coordinate of row and column or the data
alert (data)
return data;
}
Thank you for your help
Yulia
