Re: columns of user-editable text: Link to Excel sheet?
You can configure an Excel file as an ODBC datasource. Then you could display it in a CFGRID, if you like. Cary At 08:23 PM 10/29/2002 -0600, you wrote: Someone wants to have a page that's mainly an Excel spreadsheet... anyone know how to do that? Does it change when they change the spreadsheet? Or, I was thinking the user could export to a text file, which I could cfinclude between PRE /PRE tags... but there are columns of data - how would I get them to line up? This is the user phone list - name, dept, phone, employee no... tabular data. They HAVE an actual cfgrid of data for it now, and I knew they would eventually NOT want to keep it up (in duplicate with whatever the secretary is using to distribute the real phone list!). Suggestions? Sample code? TIA Ed Gordon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: columns of user-editable text: Link to Excel sheet?
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
columns of user-editable text: Link to Excel sheet?
Someone wants to have a page that's mainly an Excel spreadsheet... anyone know how to do that? Does it change when they change the spreadsheet? Or, I was thinking the user could export to a text file, which I could cfinclude between PRE /PRE tags... but there are columns of data - how would I get them to line up? This is the user phone list - name, dept, phone, employee no... tabular data. They HAVE an actual cfgrid of data for it now, and I knew they would eventually NOT want to keep it up (in duplicate with whatever the secretary is using to distribute the real phone list!). Suggestions? Sample code? TIA Ed Gordon
Re: columns of user-editable text: Link to Excel sheet?
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