Generating Excel Reports in ASP .NET 2.0
-
I'm trying to work with Excel objects in C# for ASP .NET 2.0. I am receiving the following error: System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC at Microsoft.Office.Interop.Excel.Sheets.Add( I am trying to follow the article here but it is in Visual Basic. The .Add function does not include any parameters but in C#, it seems I must pass the 4 parameters. (Object before, object after, count, and object type). The article for reference is at: Generating Excel Reports in ASP .NET 2.0[^] Unfortunately, I will not be able to post any code, but does anyone know of any good articles on how to work with excel to generate spreadsheet that is generated from data and then the chart added in C#? Thanks
-
I'm trying to work with Excel objects in C# for ASP .NET 2.0. I am receiving the following error: System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC at Microsoft.Office.Interop.Excel.Sheets.Add( I am trying to follow the article here but it is in Visual Basic. The .Add function does not include any parameters but in C#, it seems I must pass the 4 parameters. (Object before, object after, count, and object type). The article for reference is at: Generating Excel Reports in ASP .NET 2.0[^] Unfortunately, I will not be able to post any code, but does anyone know of any good articles on how to work with excel to generate spreadsheet that is generated from data and then the chart added in C#? Thanks
-
Hi, Can you give little more information? Are you sending the data which is in grid to excel file? If so, I have code which exports to .CSV file from a gridview... If your question is the same, I can share the code for you. Thanks...
Yes. My problem is the same. If possible, please share the code with me. My email id is abhisek.ch84@gmail.com.