report in word or excel not crystal report

Question

hi this is kavita. currently I m creating report in .net n the requirement is not to use crystal report.report should be in ms-excel or ms-word any help?

Michael · Answer

Excel.Application ex = new Excel.Application(); Excel.Workbook wb = ex.Workbooks.Add(Type.Missing); Excel.Worksheet ws = Excel.Worksheets[1]; Excel.Range r = ws.get_Range(A1Type.Missing); r.Value2 = From Russia With Love; r.Font.Bold = true; r.Interior.ColorIndex = 6; ex.Visible = true;