ASP.NET

ASP.NET RSS

Diplaying Excel Spread aheets online

Please support our ASP.NET advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: May 2007

Posts: 14

Reputation: vamsikgummadi is an unknown quantity at this point

Solved Threads: 0

vamsikgummadi vamsikgummadi is offline

Offline

Newbie Poster

Diplaying Excel Spread aheets online

Jul 9th, 2007

Dear friends,

Hope all of U are having a great time.
I need to display Excel sheets online using asp.net ,C#, MS SQL and Microsoft Office Share Point Server 2007. I need to make this Excel sheet editable to some authorized users. Do anyone of you have idea of attaining this scenario. Please respond if you have any hints make this possible. Thanking you in anticipation.
Regards,
Vamsi K Gummadi

•

Join Date: Apr 2007

Posts: 437

Reputation: Fungus1487 is on a distinguished road

Solved Threads: 50

Fungus1487 Fungus1487 is offline

Offline

Posting Pro in Training

Re: Diplaying Excel Spread aheets online

Jul 9th, 2007

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.

When Autumn Falls [ http://www.whenautumnfalls.co.uk ] &&
Designdotworks [ http://www.designdotworks.co.uk ] Web / Graphic / Software Design

•

Join Date: May 2007

Posts: 14

Reputation: vamsikgummadi is an unknown quantity at this point

Solved Threads: 0

vamsikgummadi vamsikgummadi is offline

Offline

Newbie Poster

Re: Diplaying Excel Spread aheets online

Jul 10th, 2007

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.

•

Join Date: Jun 2007

Posts: 83

Reputation: ProgrammersTalk is an unknown quantity at this point

Solved Threads: 7

ProgrammersTalk ProgrammersTalk is offline

Offline

Junior Poster in Training

Re: Diplaying Excel Spread aheets online

Jul 16th, 2007

Google has their Excel

you can use it for free

The ProgrammersTalk Community | Programming & Marketing | Buying & Selling Script
Hang out place of novice and intermediate programmers

•

Join Date: May 2006

Posts: 1,580

Reputation: Infarction has a spectacular aura about

Solved Threads: 52

Infarction Infarction is offline

Offline

Battle Programmer

Re: Diplaying Excel Spread aheets online

Jul 16th, 2007

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.

Last edited by Infarction; Jul 16th, 2007 at 3:16 am.

•

Join Date: May 2007

Posts: 14

Reputation: vamsikgummadi is an unknown quantity at this point

Solved Threads: 0

vamsikgummadi vamsikgummadi is offline

Offline

Newbie Poster

Re: Diplaying Excel Spread aheets online

Jul 17th, 2007

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

•

Join Date: Jul 2007

Posts: 2

Reputation: pbogd is an unknown quantity at this point

Solved Threads: 1

pbogd

Offline

Newbie Poster

Re: Diplaying Excel Spread aheets online

Jul 18th, 2007

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

•

Join Date: May 2007

Posts: 14

Reputation: vamsikgummadi is an unknown quantity at this point

Solved Threads: 0

vamsikgummadi vamsikgummadi is offline

Offline

Newbie Poster

Re: Diplaying Excel Spread aheets online

Jul 18th, 2007

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

•

Join Date: Jul 2007

Posts: 2

Reputation: pbogd is an unknown quantity at this point

Solved Threads: 1

pbogd

Offline

Newbie Poster

Re: Diplaying Excel Spread aheets online

Jul 19th, 2007

snapshot from spreadsheet.aspx.cs

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
using Microsoft.Office.Interop.Owc11;
 
...
 
public string SSxml;
using Microsoft.Office.Interop.Owc11;

...

public string SSxml;

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

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
SpreadsheetClass spsh = new SpreadsheetClass();
 
... //you do here whatever you want with this spreadsheet (here is where you have to load it from file using obj spsh exposed methods)
//you can do loads of things with this obj through its methods
 
SSxml = spsh.XMLData; //at the end you set this var in order to actually have it in the webpage
SpreadsheetClass spsh = new SpreadsheetClass();

... //you do here whatever you want with this spreadsheet (here is where you have to load it from file using obj spsh exposed methods)
//you can do loads of things with this obj through its methods

SSxml = spsh.XMLData; //at the end you set this var in order to actually have it in the webpage

the other part is spreadsheet.aspx

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="spreadsheet.aspx.cs" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>spreadsheet</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
		<object id="spreadsheet1" classid="clsid:0002E559-0000-0000-C000-000000000046" width="1000" height="700">
			<param name="XMLData" value='<%= SSxml %>' />
		</object>
    </div>
    </form>
</body>
</html>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="spreadsheet.aspx.cs" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>spreadsheet</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
		<object id="spreadsheet1" classid="clsid:0002E559-0000-0000-C000-000000000046" width="1000" height="700">
			<param name="XMLData" value='<%= SSxml %>' />
		</object>
    </div>
    </form>
</body>
</html>

i hope you understand all the things above

have a nice day

you can google for "SpreadsheetClass" to find more details

•

Join Date: May 2007

Posts: 14

Reputation: vamsikgummadi is an unknown quantity at this point

Solved Threads: 0

vamsikgummadi vamsikgummadi is offline

Offline

Newbie Poster

Re: Diplaying Excel Spread aheets online

#10

Jul 20th, 2007

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.