spreadsheet interface in Frontpage (2003) page

[Larry Rekow]

I'm trying to create a page using frontpage and/or asp with a two
column spreadsheet.

the user could paste in a column:
123
456
789

into the first column of the spreadsheed, and by clicking a button
would get the color value back in the second column
based on the values looked up in a master spreadsheet or queried from
a d/b table.

eg.

123 green
456 blue
789 red

something like this possible? I've created lots of pages using both FP
and ASP using both SQL and Access, but not sure about incorporating a
spreadsheet-like interface. The idea is that the user can paste in a
column of part numbers, as many as 2 or 3 hundred at a time, and then
be able to copy the resulting column of colors back into another
document. Thanks for any ideas or direction.

Larry
- - - - - - - - - - - - - - - - - -
"Forget it, Jake. It's Chinatown."

 

[clintonG]

I've been coding for awhile and I've never seen a web enabled
interface that supports copy and paste in the manner you describe
for those using the Internet. One form field at a time yes, multiple
rows of form fields, no. A ListBox yes, other controls maybe,
but mostly no.

I would check out what can be done using a DataGrid when coding
ASP.NET applications. I'd also suggest you may have an opportunity
to be a real hero to reduce the customer's costs of errors, ommissions,
and labor involved as the task sounds as if it is a perfect fit for XML
Web services.

 

[Larry Rekow]

I've been coding for awhile and I've never seen a web enabled
interface that supports copy and paste in the manner you describe
for those using the Internet. One form field at a time yes, multiple
rows of form fields, no. A ListBox yes, other controls maybe,
but mostly no.

I would check out what can be done using a DataGrid when coding
ASP.NET applications. I'd also suggest you may have an opportunity
to be a real hero to reduce the customer's costs of errors, ommissions,
and labor involved as the task sounds as if it is a perfect fit for XML
Web services.

++++++++++++++++++++++++++++++++++++++++++++++++++++++
In Frontpage, one can insert web components, and one of them is an
"office spreadsheet"

you can paste as much as you want into it, and if i could find a way
for it to be exported or saved to an access table or an excel
spreadsheet (on the server) that would pretty much solve my problem.

So far, to make what I want to happen work, I've created a spreadsheet
as an xml file on the server, and the user can access this as a web
page. in the second page of the workbook, I have the entire list of
partnumbers and their corresponding data......partnumber in column a,
classification code in column b.

then on page one of the workbook, which the user sees when going to
the website, the user can paste in his column of part numbers in
column a, and i have a lookup formula in column b that gets the data
from the second page. so as soon as the user pastes in his column of
part numbers (and i've copied the formula in column b up to 1000
rows), he instantaneously gets the data he needs, so he can copy it
back to his original spreadsheet.

although this works, i will have to keep updating the spreadsheet as
new partnumbers and/or classifications (the data) change over time.

would much rather prefer a scenario where the webpage is linked to an
access database, with a query that matches a linked excel spreadsheet
to a table of values. then i can create an app to add, edit or delete
values from the d/b. but the problem is in transferring any pasted in
partnumbers from a webpage to a linked excel spreadsheet or access
table. I *think* this can be done with sql statements, so i'm now
looking down that path. it's just too bad that i can't use the
spreadsheet (or the spreadsheet control) in the website to save data
on the server side.....that would pretty much be the key to completing
this app the way i'd like it best.

Larry Rekow




- - - - - - - - - - - - - - - - - -
"Forget it, Jake. It's Chinatown."