Even simpler answer came up at the client site today - Excel lets the user "Save as web page" - so I directed the user to save the phonelist to the right spot, where I pointed a <CFINCLUDE template="phonelist.htm"> embedded in a typical-looking web page for their intranet and VOILA - it came up working like a charm, and they are able to replace it at will.
----- Original Message ----- From: "Sim Graves" <[EMAIL PROTECTED]> To: "Ed Gordon" <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 10:33 AM Subject: Re: columns of user-editable text: Link to Excel sheet? > Dear Ed, > > You can make an ODBC connection to an Excel file just like it is a database. I > have an application where the client changes the data in an application just by > uploading a new Excel file to the server. The Excel file always has the same > name. ColdFusion accesses the file like it is a database table. > > You need to set some definitions in the Excel file so that ColdFusion knows that > the first row is the field names, etc. Look online for the exact procedure, I > can't remember all of the details off hand. > > Hope this helps. > > > Sincerely, > > Sim Graves > > Ed Gordon wrote: > > > Hi ! > > > > Thank you very much for writing... > > > > Sort of like the first choice... > > > > >...want the user to upload an Excel spreadsheet that's displayed > > > on a Web page? > > > > .... only it's an admin-level user who has access to the server itself. They > > already perform the function using data in a table with a CFGRID - but when > > they do, the secretary a whole division over has already maintained the > > office phone list electronically - only it's in an Excel spreadsheet. They > > just don't want to have to re-type everything into the grid. > > > > I figger I'll just tell them to export the text to a file, which I then > > CFINCLUDE on a typical (but blank) page on their (intranet) site - and in > > order to retain the line breaks, I put it between > > <PRE> > > ... > > </PRE> > > ... or some other variation - can't think of how I would keep the data in > > columns though... > > > > Thanks, > > > > Ed > > > > ----- Original Message ----- > > From: "Sim Graves" <[EMAIL PROTECTED]> > > To: "Ed Gordon" <[EMAIL PROTECTED]> > > Sent: Tuesday, October 29, 2002 10:49 PM > > Subject: columns of user-editable text: Link to Excel sheet? > > > > > Dear Ed, > > > > > > I'm not sure what you are trying to accomplish here. > > > > > > Do you want the user to upload an Excel spreadsheet that's displayed > > > on a Web page? > > > > > > Do you want the user to download a Web page that's an Excel > > > spreadsheet? > > > > > > Or, is this something else that I'm not understanding? > > > > > > CFGRID will update like a spreadsheet, but that's not what you want > > > . . or is it? > > > > > > Tell me more and I'll try to help. > > > > > > Sincerely, > > > > > > Sim Graves > > > > > > > > > > >
