We want to use Microsoft.Office.Interop.Excel in our web application. Everything works fine on our local machines, but on our test machine we’re running into problems. It has neither Visual Studio nor Office installed on it.
We’re using .NET framework 2.0 and the server is running on Windows Server 2003 with IIS6.
I’m using the EPPlus library to read/write Excel files: http://epplus.codeplex.com/
I’m using OpenXML SDK 2.0 to add data to the spreadsheet template but I ran into a problem (since I’ve been using OpenXML for a day that’s not so hard to believe). I can’t figure out how to add new rows while pushing all the rows that are below the new ones down.
i tried to transfer grid view data to excel …. But the output is a blank excel sheet.How to solve this problem?Is there any code to transfer grid view value to excel sheet with data base?
We let users create ad-hoc queries in our website. We would like to have the user select their criteria, then click submit and have the results streamed automatically to Excel. I have the application populating a DataTable, then using the datatable to create a tab delimited string. The problem is getting that to excel.
This is my markup of GridView.
I have data like below
I am getting this error when trying to update excel sheet :
I’m trying to develop a c#/asp.net application to extract data from a SQL server and have it formatted in an excel spreadsheet. I have been practicing with excel object model and recently stumbled upon this: http://support.microsoft.com/kb/257757 Considerations for server-side Automation of Office
I use CarlosAG-Dll which creates a XML-Excel-file for me (inside a MemoryStream).