there are some free components available that allow you to view excel documents in asp.net i cant think for the love of god where i saw them tho. best to GOOGLE it. Another alternative is to use something like a datagrid and create your own excel like application. this way you would have full control over everthing as youve hand made it.

Hello Mr.Fungus,
Thank you for the reply and the suggestion. Yes, I agree with you that I can make use of something like a datagrid and create my own wxcel application and have full control on it. But my requirement is demanding me to display excel sheet online and make it editable to authorized users. Actually I tried to attain the above said scenario using IIS, asp.net, C# and MS Excel and I am partially successful. I am able to display excel sheets online but unable to edit, add and update. Even if I am edit the excel sheet displayed online it is saving the updated or edited file in some other location.
So my requirement needs excel sheet displayed online and make it editable to authorized users and at the same time save the updated file in the same location where the actual file exists.
I have googled to acheive this problem and I have learnt that using MS Office Share Point Server 2007 I can acheive this problem. Now, I request youand all the members in daniweb.com to suggest how I attain the problem using SharePoint Server, asp.net, c# and MS Excel. Hope you all enjoy taking this problem as a challenge and solve this problem together.
Vamsi K Gummadi.
United we stand divided we fall. We can make things better by working together.

Google has their Excel
you can use it for free

I don't know that it'd be the most efficient, but you could save the Excel document as XML and use that as a data source on your website. You could then set up permissions to edit the XML data through a web interface. Like I said, this might not be the best way, but it should be functional.

Hello friends,Thank you for the replies and suggestions. Yes as some of you have suggested I have also tried to use Google spread sheets which are similar to MS Excel but my requirement is demanding me display MS Excel spreadsheets online.Yes I can save the Excel document as XML and use that as a data source on my website. But I don't know how to manage permissions. If I am editing the excel sheet that is displayed online and trying to save it then it is saving in some other location instead of updating the file in the same location.So for this purpose some of my friends are suggesting me to use Microsoft Share Point Services 2007.So I request you to kindly guide me how to manage perrmissions while displaying excel sheets online and save it in the same location or how to use Microsoft Office Share Point Server 2007 to display Excel Sheets online using C#,asp.net. Hope I am clear with my problem.I will be very greatful if you can help me in this aspect.VamsiKGummadi

the way i did it was not through sharepoint server but through owc (office web components)
the coding for it it is quite easy and i could show you some exact code snippets if you're interested in
I've used asp.net 2.0 with c#; another thing you need to know is what owc you want to use (coding can be a little bit different); i have used owc11 (the office web components for office 11 (office 2003));
you also need to have the actual office installed on the server;
displaying real excel spreadsheets in web pages it is not too recommended because for each spreadsheet shown an office instance is running on the server;
anyway if this is what you want just post a reply and I'll give you the actual samples

Hello Sir,
Have gone through your reply. I think the solution you have given will be useful to me. Yes I agree with you that displaying real excel spreadsheets in the web pages is not advisible. I want these excel spreadsheets to be viewable to all users and editable only to authorized users.
I have actual office installed on the server. I am also having asp.net 2.0 installed.So, please kindly forward me the exact code snippets and any other links that can help me to find out a solution for this problem. Hope you will do the necessary.
Vamsi K Gummadi.
Ideal brain work like a devil

snapshot from spreadsheet.aspx.cs

...
inside a method of yours or in page_load:


the other part is spreadsheet.aspx

i hope you understand all the things above

have a nice day

you can google for "SpreadsheetClass" to find more details

Hello Sir,
Thank you for the help. I will work in this aspect and get back to you if I have any doubts. Thank you for the support offered. I will let you know the details at the earliest.
Vamsi K Gummadi.
Working hard is the only key of success.