excel sheet problem

[yogarajan]

hi i had xls template in server and write some value show to the client browser. if i click save (file -> save) button . it is save in server but i need save in client location

here is my code

<----Code start here --->


SqlConnection db_con = new SqlConnection("Data Source=192.168.0.10;Initial Catalog=test; User Id=sa; Password=");
db_con.Open();

//Excel.Application objExl = new Excel.ApplicationClass();
Excel.Application objExl = new Excel.Application();
string excelfilepath = Server.MapPath(".")+"/ExcelReport/sampleReport.xls";


//Excel.Workbook ExlWrBk = objExl.Workbooks.Open(@"\\192.168.50.252\software\ _Common\manju" + @"\sampleReport.xls", 0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);
Excel.Workbook ExlWrBk = objExl.Workbooks.Open(excelfilepath, 0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);
Excel.Sheets ExlShts = ExlWrBk.Worksheets;

Excel.Worksheet objWrSht = (Excel.Worksheet)ExlShts.get_Item("sampleReport");

Excel.Range ExlRng = (Excel.Range)objWrSht.get_Range("A1", "A1");


SqlCommand cmd = new SqlCommand("select * from customermaster", db_con);

//SqlDataReader dr = null;
SqlDataReader dr5 = cmd.ExecuteReader();

DataSet ds = new DataSet();




int Row = 2;


while(dr5.Read())

{

objWrSht.Cells[Row, 1] = "1";

objWrSht.Cells[Row, 2] = dr5["cusname"];//ds.Tables[0].Columns["cusName"];

objWrSht.Cells[Row, 3] = dr5["cusCompnay"];

objWrSht.Cells[Row, 4] = dr5["cusindustry"];

objWrSht.Cells[Row, 5] = dr5["cusdesig"];

objWrSht.Cells[Row, 6] = dr5["cusaddress1"];

objWrSht.Cells[Row, 7] = dr5["cusaddress2"];

objWrSht.Cells[Row, 8] = dr5["cuscity"];

objWrSht.Cells[Row, 9] = dr5["cuspincode"];

objWrSht.Cells[Row, 10] = dr5["cusmobileno"];

objWrSht.Cells[Row, 11] = dr5["cusLandLineNo"];

objWrSht.Cells[Row, 12] = dr5["cusEmail"];

objWrSht.Cells[Row, 13] = dr5["cusintereston"];

objWrSht.Cells[Row, 14] = dr5["cusinterestlevel"];

objWrSht.Cells[Row, 15] = dr5["cusdatelastmet"];

objWrSht.Cells[Row, 16] = dr5["cusnextmeetingdate"];

objWrSht.Cells[Row, 17] = dr5["cusFollowupstatus"];


Row = Row + 1;

}
objExl.Visible = true;

<-----Code End here--->


pls response immd Asap

Thanks

[yogarajan]

hi All

i have one more doubt

my program is working fine in local. but it is not working in server

why?

pls response immd

Thanks

Yogarajan.G