Forum Discussion

dhanapal1's avatar
dhanapal1
Contributor
15 years ago

How to write data into excel sheet?

Hi        Right now I am doing scripting with c# am unable to write data into excel sheet.  I have tried with ole object and activex object. I have refered msdn too but I couldn't get  answer. ...
Azeddin_Margani's avatar
Azeddin_Margani
Contributor
12 years ago
Hi,



I'm trying to write to excel sheet using the following code but error keeps complaining about the file "C:\TestData\db1" couldn't be found. Althought i've created the file in C:\.






function adddataexcel()



{



// Launch Excel



var app;



var book;



var sheet;



var i,j;



var val ="dpl007";



app= Sys["OleObject"]("Excel.Application");



//app = new ActiveXObject("Excel.Application");



book = app["Workbooks"]["Open"]("C:\\TestData\\dp1");



sheet = book["ActiveSheet"];



for(j=0; j<=4; j++)



sheet["Cells"](i,j).value= val;



book["Save"]();



app["Quit"]();



}