Hi guys,

                 i have a requierment like  when i click on excel sheet link which was uploaded it must open in an editable mode. Please do help me in resolveing this problem as soon as possible

There is a technology called WebDAV which will let you serve office files and let them be opened in excell or word and then saved back to the server from excel or word.

If you want the spreadsheets to be editable via the website then you are going to be looking at buying a commercial component.

It depends on what level of control you have over the environment - are they all going to be xls files, or xlsx (2007) files? are they going to contain calculations or just straight data? if the requirements are simple then you might be able to attempt writing your own xls loader, convert it to database format and then allow editing and then allow export to xls....

 Hi,

Try this code

        Process Proc = new Process();
        Proc.StartInfo.FileName = "excel";
        Proc.StartInfo.Arguments = "C:\\Book1.xlsx";
        Proc.Start();

Hope this helps.

Cheers

Just to be clear - the Process() code suggested by Sangeeth will start up a copy of excel on the server not on a clients computer.

Hi Harry,

               Thanks for your reply. The thing is that  i can't afford to buy a third party component and if i can get any such components  for free of cost let me know. The requirement is  adding rows and columns and editing  online . As we click on save button the edited xls file replace the existing one and there should be an option where user can download the excel file. Harry, i think u know about google documents  where we can upload the documents and excel sheet. There is an option of adding rows and columns  and editing the uploaded excel sheet. If we can do in such a way please do let me know and post the code also. The requirement is urgent

                                            Thanks in advance 

Hey,

praveen.k:

Thanks for your reply. The thing is that  i can't afford to buy a third party component and if i can get any such components  for free of cost let me know. The requirement is  adding rows and columns and editing  online . As we click on save button the edited xls file replace the existing one and there should be an option where user can download the excel file.

I understand that you are on a budget but this means that you will have to get several tutorials and string them together yourself.

There are tools that allow import of excel spreadsheets into a database:

• http://www.aspsnippets.com/post/2009/06/06/Read-and-Import-Excel-Sheet-into-SQL-Server-Database-in-ASPNet.aspx
  
• http://www.aspsnippets.com/post/2009/06/04/Read-and-Import-Excel-Sheet-into-ASPNet-GridView-Control.aspx
  

There are tools that allow bulk excel like editing:

• http://mattberseth.com/blog/2008/05/bulk_inserting_data_with_the_l.html
  

There are tools that allow export to excel spreadsheet:

• http://www.aspsnippets.com/post/Export-GridView-To-WordExcelPDFCSV-in-ASPNet.aspx
  
• http://www.aspsnippets.com/post/2009/06/19/Exporting-Multiple-GridViews-To-Excel-SpreadSheet-in-ASPNet.aspx
  

praveen.k:

Harry, i think u know about google documents  where we can upload the documents and excel sheet. There is an option of adding rows and columns  and editing the uploaded excel sheet. If we can do in such a way please do let me know and post the code also. The requirement is urgent

Yes its called WebDAV - there isnt a source code example I can give you because it is not that kind of technology. Its a feature that you can configure on IIS so that Microsoft Excel and Word can communicate directly to your server to save and load files. There isnt much information that I could find when I did a quick search for another question on these forums recently. I think you are just going to have to dig deep.

Something you should think about is what your time is worth to you - dont spend 10s of man hours creating a solution that can be solved by buying a component.