Requirement: How to programatically manipulate the contents of an MS Excel spreadsheet

I have a spreadsheet in MS Excel format and I want to be able to edit the contents of the file from within the program, that I am writing. I need to modify individual cell values and insert and delete entire rows each time the program runs.

My application runs on a server so I can't afford to invoke Office Automation and I don't have time to figure out the native file format. I just want an easy to use object model that represents the sheet and gets me straight to the data. Can anyone help with an off-the-shelf code library?



Solutions:

Submit a new solution to this problem >
Insert / Delete rows programmatically in an Excel Worksheet
There are two methods that Aspose.Cells offers i.e., InsertRows and DeleteRows, these two methods are optimized related performance and efficient enough to do the job very quickly. So if you are in need to insert some sets of rows or remove a number of rows, it is recommended that you should always use InsertRows and DeleteRows methods instead of repeatedly using InsertRow and DeleteRow methods in a loop.
(C#, VB.NET, Java\)