Hi this is kavita,
can anybody tell me what wrong inthis code :Excel.Application ex = new Excel.Application(); Excel.Workbook wb = ex.Workbooks.Add(Type.Missing);
Excel.Worksheet ws = Excel.Worksheets[1]; //ERROR IN THIS LINE//////
Excel.Range r = ws.get_Range("A1",Type.Missing); r.Value2 = "From Russia With Love"; r.Font.Bold = true; r.Interior.ColorIndex = 6; ex.Visible = true;
actually I want to fetch data from sql table & show in Excel report.What is the cirrect code ?please help me!