Dear friends,
i gotta problem in genrating report in excel sheet My code is as follows :
Excel.Application xlApp = new Excel.Application();
xlApp.Visible = true;
//Excel.Workbook xlWorkBook = new Workbook();
Excel.Workbook xlWorkBook = xlApp.Workbooks.Add(Missing.Value);
Excel.Worksheet xlWorkSheet = new Worksheet();
xlWorkBook = new Excel.Application().Workbooks.Add(Missing.Value);
xlWorkBook.Application.Visible = true;
// xlWorkSheet =(Excel.Worksheet) xlWorkBook.ActiveSheet;
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets[1];
string getstr = "select * from budcat_master where cat_id like '" + val +
"'";
DataSet ds = ICPDDal.GetData(getstr);
int i = 2;
xlWorkSheet.Cells[1, 1] = "Category ID";
xlWorkSheet.Cells[1, 2] = "Category Name";
xlWorkSheet.Cells[1, 3] = "Categroy Description";
xlWorkSheet.get_Range("A1","E1").Font.ColorIndex = Excel.Constants.xlColor1;
xlWorkSheet.get_Range("A1", "E1").Font.Bold = true;
foreach (DataRow dr in ds.Tables[0].Rows)
{
xlWorkSheet.Cells[i, 1] = dr[0];
xlWorkSheet.Cells[i, 2] = dr[1];
xlWorkSheet.Cells[i, 3] = dr[2];
i++;
}
xlWorkSheet.Columns.AutoFit();
the problem is in runtime.... i got a error like
*Retrieving the COM class factory for component with CLSID
{00024500-0000-0000-C000-000000000046} failed due to the following error:
80040154.*
i am cluless !!!! please help me get rid of this error
--
Sarvesh
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://cm.megasolutions.net/forums/default.aspx
-~----------~----~----~----~------~----~------~--~---
