opening and modifying excel sheet

K

kulandaivel_mca

Newcomer
Joined
Jan 26, 2009
Messages
5
Location
INDIA
i am developing web application asp.net with c#...

if i click a particular link one excel file will opent (it contains reports)...

how can i open this excel file and i have to modify that excel file...
 
Do you want to modify the excell file in your code or launch Excell?

I don't know about the old xls files, but the new *.xlsx files are actually zip archives (you can test this by renaming the file). You need to first extract the contents. After that all contents are in xml files.
 
I'm not sure you can do this with web app since I normally use winforms, but try looking at the Excel Object library 12.0. (office 2007 equals version 12)
You can add reference to this COM library, and edit excel files.
Within this library are objects like an excel sheet, document, and application.
Hope it brings you a little further..
~DP
 
Back
Top