Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
  1. Home
  2. Web Development
  3. ASP.NET
  4. Edit Excel Sheet Online and Saving Changes?

Edit Excel Sheet Online and Saving Changes?

Scheduled Pinned Locked Moved ASP.NET
csharpasp-nethelpquestion
4 Posts 3 Posters 1 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • C Offline
    C Offline
    codingrocks
    wrote on last edited by
    #1

    Hello, I use ASP .NET to publish office document on the web. My problem is I want to modify Excel file through IE (without downloading them). I need to open the Excel sheet using IE and do all the functions available in Excel like grouping, merging cells and changing cell colors etc... Has anybody got some tips for me ? Any suggestions would be appreciable?

    CodingRocks ASP.NET,C#.NET Programmer BANGALORE "Winners don't do different things. They do things differently. ...

    L S 2 Replies Last reply
    0
    • C codingrocks

      Hello, I use ASP .NET to publish office document on the web. My problem is I want to modify Excel file through IE (without downloading them). I need to open the Excel sheet using IE and do all the functions available in Excel like grouping, merging cells and changing cell colors etc... Has anybody got some tips for me ? Any suggestions would be appreciable?

      CodingRocks ASP.NET,C#.NET Programmer BANGALORE "Winners don't do different things. They do things differently. ...

      L Offline
      L Offline
      Lost User
      wrote on last edited by
      #2

      Excel Services in the SharePoint 2007 can be used to use, share, calculate and edit Excel Workbooks online.

      C 1 Reply Last reply
      0
      • L Lost User

        Excel Services in the SharePoint 2007 can be used to use, share, calculate and edit Excel Workbooks online.

        C Offline
        C Offline
        codingrocks
        wrote on last edited by
        #3

        I am using Microsoft.Office.Interop.Owc11 for the excel editing. But when I tried to open the file using the following code in Page Load event

        public string SSxml;
        protected void Page\_Load(object sender, EventArgs e)
        {
            SpreadsheetClass spsh = new SpreadsheetClass();
           
            string str = Server.MapPath(".") +"\\\\test.xls";
               
            SSxml = spsh.XMLData;
            
        }
        

        I am getting an error saying "Exception from HRESULT: 0xE0040104" How can I fix this issue. I want to open the test.xls file as XMl Spreadsheet now.

        CodingRocks ASP.NET,C#.NET Programmer BANGALORE "Winners don't do different things. They do things differently. ...

        1 Reply Last reply
        0
        • C codingrocks

          Hello, I use ASP .NET to publish office document on the web. My problem is I want to modify Excel file through IE (without downloading them). I need to open the Excel sheet using IE and do all the functions available in Excel like grouping, merging cells and changing cell colors etc... Has anybody got some tips for me ? Any suggestions would be appreciable?

          CodingRocks ASP.NET,C#.NET Programmer BANGALORE "Winners don't do different things. They do things differently. ...

          S Offline
          S Offline
          Shelly2864
          wrote on last edited by
          #4

          Google Docs may help. Or if you are dealing with a project or an OA system, a software called Aceoffix may be more helpful for it can be compatible to your system. Google Docs just for personal use. Hope this will be useful for you.

          1 Reply Last reply
          0
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • World
          • Users
          • Groups