Opening an Excel document from a webpage, and returning a cell value to a DB.
Opening an Excel document from a webpage, and returning a cell value to a DB.
Opening an Excel document from a webpage, and returning a cell value to a DB.
Opening an Excel document from a webpage, and returning a cell value to a DB.
Opening an Excel document from a webpage, and returning a cell value to a DB.
Opening an Excel document from a webpage, and returning a cell value to a DB. Opening an Excel document from a webpage, and returning a cell value to a DB. Opening an Excel document from a webpage, and returning a cell value to a DB. Opening an Excel document from a webpage, and returning a cell value to a DB. Opening an Excel document from a webpage, and returning a cell value to a DB. Opening an Excel document from a webpage, and returning a cell value to a DB. Opening an Excel document from a webpage, and returning a cell value to a DB. Opening an Excel document from a webpage, and returning a cell value to a DB.
Opening an Excel document from a webpage, and returning a cell value to a DB. Opening an Excel document from a webpage, and returning a cell value to a DB.
Opening an Excel document from a webpage, and returning a cell value to a DB.
Go Back  Xtreme Visual Basic Talk > > > Opening an Excel document from a webpage, and returning a cell value to a DB.


Reply
 
Thread Tools Display Modes
  #1  
Old 01-08-2009, 09:57 AM
7h0m's Avatar
7h0m 7h0m is offline
Regular
 
Join Date: Feb 2008
Posts: 64
Question Opening an Excel document from a webpage, and returning a cell value to a DB.


Hello!

I would like from a certain url, to launch an excel file, have the user fill some cells and then return the value to a database by aspx perhaps.

What would be the best route iyo?

Thanks alot.
__________________
Nasa predicts Pole Shift in 2012. Google it.
Reply With Quote
  #2  
Old 01-08-2009, 12:42 PM
Mike Rosenblum's Avatar
Mike Rosenblum Mike Rosenblum is offline
Microsoft Excel MVP

Forum Leader
* Guru *
 
Join Date: Jul 2003
Location: New York, NY, USA
Posts: 7,848
Default

I really wouldn't try to do this, and I wouldn't have a clue how to help you if you did try... I just don't know enough about web programming to advise you.

In theory, I would guess that a web page could include code to launch an Excel Application, but I don't know how you would hook the Excel events, I just don't know if a web-page based application could work that way? Can you hook COM events using JavaScript, for example? I just don't have any idea here -- you'd be much better off asking this question in a Web forum, if this is really the direction you want to go. But I don't think I really recommend this unless you are very strong in both Web programming and the Excel object model.

And while Excel is fairly ubiquitous, it certainly can't be found on all computer installations, so your Web page would crash (or have a serous hole in it's functionality) with some computers, even if you did get this to work.

Personally, I would utilize a grid control that you can embed on your Web page. The user can type in their values and then hit the "Submit" button, or the like.

But this is just my opinion, I don't really know anything about web programming, so you might want to ask this question in a Web forum to see what they suggest -- but I'm betting they'd suggest something similar.

I hope this helps?
Mike
__________________
My Articles:
| Excel from .NET | Excel RibbonX using VBA | Excel from VB6 | CVErr in .NET | MVP |
Avatar by Lebb

Last edited by Mike Rosenblum; 01-08-2009 at 07:18 PM.
Reply With Quote
  #3  
Old 01-08-2009, 02:24 PM
7h0m's Avatar
7h0m 7h0m is offline
Regular
 
Join Date: Feb 2008
Posts: 64
Default

Thank you for your well written response... however my problem has changed since I wrote my thread. I will try to repost it on the aspx side of the forums.

Thanks again!
__________________
Nasa predicts Pole Shift in 2012. Google it.
Reply With Quote
  #4  
Old 01-13-2009, 12:15 PM
Mike Rosenblum's Avatar
Mike Rosenblum Mike Rosenblum is offline
Microsoft Excel MVP

Forum Leader
* Guru *
 
Join Date: Jul 2003
Location: New York, NY, USA
Posts: 7,848
Default

For those interested, there's a thread on StackOverflow on this topic:

How can I hook up to Excel events in Javascript

I don't know if the OP there, alexfeygin, is you 7h0m or not, but either way, any replies there could be of interest...
__________________
My Articles:
| Excel from .NET | Excel RibbonX using VBA | Excel from VB6 | CVErr in .NET | MVP |
Avatar by Lebb
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Opening an Excel document from a webpage, and returning a cell value to a DB.
Opening an Excel document from a webpage, and returning a cell value to a DB.
Opening an Excel document from a webpage, and returning a cell value to a DB. Opening an Excel document from a webpage, and returning a cell value to a DB.
Opening an Excel document from a webpage, and returning a cell value to a DB.
Opening an Excel document from a webpage, and returning a cell value to a DB.
Opening an Excel document from a webpage, and returning a cell value to a DB. Opening an Excel document from a webpage, and returning a cell value to a DB. Opening an Excel document from a webpage, and returning a cell value to a DB. Opening an Excel document from a webpage, and returning a cell value to a DB. Opening an Excel document from a webpage, and returning a cell value to a DB. Opening an Excel document from a webpage, and returning a cell value to a DB. Opening an Excel document from a webpage, and returning a cell value to a DB.
Opening an Excel document from a webpage, and returning a cell value to a DB.
Opening an Excel document from a webpage, and returning a cell value to a DB.
 
Opening an Excel document from a webpage, and returning a cell value to a DB.
Opening an Excel document from a webpage, and returning a cell value to a DB.
 
-->