Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
22 Points
8 Posts
Jun 16, 2011 08:19 AM|LINK
It's known Excel problem. Microsoft Excel API is a COM library with bad integration with .NET Framework.
I've worked with Excel Jetcell .NET for a long time and can really recommend it.
At Excel Sample page you will find many useful C# VB.NET Excel codes, for instance:
// Create New Excel Workbook in C# ExcelWorkbook Wbook = new ExcelWorkbook(); ExcelCellCollection Cells = Wbook.Worksheets.Add("Sheet1").Cells; Cells["A1"].Value = "Excel writer example (C#)"; Cells["A1"].Style.Font.Bold = true; Cells["B1"].Value = "=550 + 5"; // Write Excel XLS file Wbook.WriteXLS("excel_net.xls");
John Flor
Member
22 Points
8 Posts
Re: Excel problem
Jun 16, 2011 08:19 AM|LINK
It's known Excel problem. Microsoft Excel API is a COM library with bad integration with .NET Framework.
I've worked with Excel Jetcell .NET for a long time and can really recommend it.
At Excel Sample page you will find many useful C# VB.NET Excel codes, for instance:
// Create New Excel Workbook in C# ExcelWorkbook Wbook = new ExcelWorkbook(); ExcelCellCollection Cells = Wbook.Worksheets.Add("Sheet1").Cells; Cells["A1"].Value = "Excel writer example (C#)"; Cells["A1"].Style.Font.Bold = true; Cells["B1"].Value = "=550 + 5"; // Write Excel XLS file Wbook.WriteXLS("excel_net.xls");