• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to create a webpage using excel?

B

Brooklynite

New Member
Hi Dilbert,


I have a huge excel file that I continuously modify and I have to email it to a few people. Its long list of about 1500 rows and 10 columns. Each column has a filter at the top row. Each recipient filters the file to get what they need to see and hide everything else.


Is there a way I can make this a webpage so I dont have to email everyone everyday and they can always access it and do the same filtering on a webpage while I update the excel spreadsheet on the backend?


Thanks!!
 
If it is an internal file on an intranet you can use Excel Services or Excel Server running on a sharepoint system

http://blogs.msdn.com/excel/archive/tags/Excel+Server/default.aspx
 
If it is just data, why not use google docs or office live. (live.office.com). You can just save your excel to live and ask others to open it from there everyday. (requires MSN passport or live account, which is free). They give something like 25 gb space, and you can collaborate (or use worksheet protection so that no one messes with formulas etc.)
 
Thanks Chandoo. I can't work on Google docs, its like a toy compared to Excel. I cannot use a free site, it is confidential data and it will be on my own site with restricted access based on users's access previliges. I am looking into Excel Services but I don't understand much. Sharepoint server is a $6000 piece of software + Windows Server etc + user licenses + IT person to set it up, I am looking at over $10k!!


I can't believe converting an excel spreatsheet into a webpage is so complicated and expensive. There should be an easier way.
 
I may be making the question much more complicated than it is. This must be a very basic thing to do on the internet. Lets say you have a site and you want to show the progress of your project on a corner of the page. You put the data in an excel file and save it on your server. The visitors see the chart on page two of the excel file. As you update the data, the chart on page two changes accordingly and the chart shown on the website changes accordingly.
 
Have you thought about the Microsoft online offerings ?

http://www.microsoft.com/online/trial-bpos.mspx
 
Also, if you want to show the data or make charts, you can use some APIs (there are apis to convert excel to jave or excel to php or excel to asp) on the web server. That way, everyday you would upload new excel file to a secure location. and you write a small html / jsp or html / php or html / asp website code (shouldnt take too much time or money if you outsource) to read and show the output in a table and or charts.


There are tons of javascript based (jquery comes to mind) UI libraries or frameworks that can automate the process table sorting, filtering, making charts etc.


people who have access to the web page can see this stuff (access control is still your headache).


AFAIK, Office live is secure too. Unless you are talking about some extremely sensitive (or financial information) you might consider using it. (or go for BPOS, it is MS hosted sharepoint service with all the benefits and some limits like hosting, number of accounts etc. and they charge per month)
 
One of the things you might be able to do quickly and inexpensively is use a network drive on your internal network.


This is something your network admin should be able to set up quickly for you.


The really nice thing about it is that you can actually hyperlink to it, so your users can save the file as a link in their browser.
 
There have been 2 good articles on the Microsoft Excel Web App recently at


http://blogs.msdn.com/excel/


That should be able to do what you want
 
ericlind, that is not exactly what I want.


I am trying to use the great filtering capabilities of Excel on a webpage, not just on my screen, without people knowing its excel or being able to change it. My users only have a BROWSER, not excel or office products.
 
Hello Brooklynnite, I know this is an old post but I am trying to do the same thing now. Did you find out how to do this or what did you end up using?
 
Good day adasie


As you say it is an old post, time moves on and so do people those that where members may not be so now. Also those that originally answered this post may not revisit as they will think it is same question/same person.


Start a new post and mention this post, that way by not burying you question in another post you will get a better response.
 
You must log in or register to reply here.
Back
Top