Programming, website development forum

DaniWeb Graphics
and Web Design Community

Revenue Sharing

Welcome to TechnicalTalk.Net forum! It seems that you are not a member yet. To interact with other members and to post on the forum. Get a free account now

Earn money on this forum

Advertise with us...

TechnicalTalk » Graphics and Web Design » General Web Design » GUI -> Excel -> GUI

Quick Links:

Want to earn money on forum? visit --> Earn money on forum

Pages: [1] Go Down

		Email this topic \| Print
0 Members and 1 Guest are viewing this topic.

GUI -> Excel -> GUI

bryanwt3

Reputation Power: 1

New Poster

Posts: 1

Topics: 1

GUI -> Excel -> GUI

July 06, 2009, 09:12:07 AM

I'm working on a little project where I'm looking to create a web-based graphical user interface that takes the user's inputs, connects with Microsoft Excel, uses the inputs to do some calculations, takes the Excel results, and then display outputs on the GUI. I'm not that savvy with programming, so I'm just looking for a general framework as to how I go about doing this (i.e. what languages do I use and how I implement such a thing?). Thanks in advance for any advice!

Abhi

Reputation Power: 19

Code Guru

Location: India

Gender:

Posts: 1444

Topics: 126

Re: GUI -> Excel -> GUI

July 17, 2009, 08:50:09 AM

This is not that much hard to implement. Yo can achieve this in programming languages like PHP, Classic ASP 3.0 OR ASP.net.

Not sure if there are direct control available to access Excel documents or not but in other programming languages you will need to create connection to Excel document same as you create connection to database. Here only the difference is the connection properties we use to connect to Excel document. Normally the rows in the Excel document are read in the same way we read rows in the database table, and that is why we create connection to the Excel document. Once you create connection to Excel document you can read the document as row wise by using some ADO recordset object, and then using the input you get from users you can perform calculations with the data in the Excel rows.

I am just trying to give you the logic to implement it, you will need to search or self study your self the exact syntax or the programming code for your self.

Hope this helps you in putting your first step in implementation.

Help us to keep this forum clean. Report the SPAM!

Email this topic | Print

Pages: [1] Go Up

Jump to:

Home | Advertise | Forum Help | Privacy Policy | Contact us

Powered by SMF 1.1.16 | SMF © 2011, Simple Machines

Google visited last this page April 27, 2012, 09:21:17 PM