Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

For HES

Posted on 2000-03-13
2
Medium Priority
?
290 Views
Last Modified: 2013-12-25
Hes,

Sorry:  I got distracted with other projects, but I did not forget your assistance nor did I mean to ignore you.

The question was:
I need to display the contents of a number of spreadsheets (one at a time) on a web page.  The clients browsing the site need to be able to change the numbers (on-line in the browser window) and see the results of the new calculations.)  The clients will not be allowed to save changes to the spreadsheet to the web server but may export the spreadsheet to his/her hard drive.  The clients will NOT necessarily have Excel so a simple hyperlink to the spreadsheet so it loads within his or her browser in Excel will not work here.

The good news is Microsoft provides an ActiveX component "Office Spreadsheet component" that does everything I need.  

** My question is: How do I tell the ActiveX component which spreadsheet file to load? **

Does anyone have some experience with this component or sufficent ActiveX experience to offer a solution?


These are not possibible solutions:

I can not simply display a static spreadsheet.

I can not simply provide a link for the client browser to download the spreadsheet into his own computer.

I need to display the spreadsheet and allow the dynamic interaction provided by the above mentioned web component.  

I am talking hundreds of spreadsheets which need to remain in Excel format and are going to be changing daily.

I would consider another product as a possibile solution, for example "Net-it Central", (however Net-It does not provided the function of being able to actually modify the spreadsheet contents in the browser window.)

I have a lot of control over the server environement and can use virtually any server side technology to solve this problem.  I can also insist the clients browsers be IE 5, for example.  The only thing I can not do is insist the clients go buy Excel <grin>.

To sum up:

1. How can I the the component to load my spreadsheet of choice, or

2. How can I display any of a number of excel spreadsheets, one at a time in the client's browser and allow the client to play with the numbers, seeing the results of the changes while on-line.

And your answer was:
per MS Bulletin:http://support.microsoft.com/support/kb/articles/Q235/8/83.ASP

"... there is no way to bind the Spreadsheet control to data directly."

Not the answer I wanted...but it was the right answer.  So the points are here for the taking and much thanks for your quick response to my problem.

Regards,
Rod

0
Comment
Question by:rdivilbiss
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 20

Accepted Solution

by:
hes earned 800 total points
ID: 2616330
Sorry it wasn't the answer you were looking for.
hes
0
 
LVL 29

Author Comment

by:rdivilbiss
ID: 2616456
So am I but it is the right answer!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Because your company can’t afford for you to make SEO mistakes, you’ll want to ensure you’re taking the right steps each and every time you post a new piece of content. This list of optimization do’s and don’ts can help you become an SEO wizard.
Without even knowing it, most of us are using web applications on a daily basis.  In fact, Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We generally confuse these web applications to…
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Suggested Courses

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question