[WebDNA] Generating Excel File Via WebDNA
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 104641
interpreted = N
texte = Hi all, Got a client that wants to extract a range of data from an existing WebDNA DB server ...not an issue. He wants the data extracted to be an Excel file that shows up as a link which allows him to click and download the file via his browser. OK, from the archives ...it was stated that the extracted file saved in tab-delimited format and named xxx.xls will do the trick of getting the file to open in Excel after download. Yes that is true ...after a warning popping up in Excel about format issues ...but it works. Here is the problem ...downloading the file via a link does not work. Simply pointing it to xxx.xls on the server causes the download to never start with warning boxes popping up on IE stating so. Remember, the xxx.xls is actually a tab-delimited file. However, if the xxx.xls file was converted into an actual Excel XLS file ...the download link works and is allowed to proceed. This appears to be an IE thingy that checks the file type before downloading. It appears you cannot trick IE to download a file that is not an actual Excel file even though it has the correct postfix. So ...anyone can propose a solution for me to pursue ...simple requirement ...extract data from WebDNA DB, save it as Excel with a link for download that works (not blocked by IE). Many thanks ...Terry Nair
Associated Messages, from the most recent to the oldest:
Hi all, Got a client that wants to extract a range of data from an existing WebDNA DB server ...not an issue. He wants the data extracted to be an Excel file that shows up as a link which allows him to click and download the file via his browser. OK, from the archives ...it was stated that the extracted file saved in tab-delimited format and named xxx.xls will do the trick of getting the file to open in Excel after download. Yes that is true ...after a warning popping up in Excel about format issues ...but it works. Here is the problem ...downloading the file via a link does not work. Simply pointing it to xxx.xls on the server causes the download to never start with warning boxes popping up on IE stating so. Remember, the xxx.xls is actually a tab-delimited file. However, if the xxx.xls file was converted into an actual Excel XLS file ...the download link works and is allowed to proceed. This appears to be an IE thingy that checks the file type before downloading. It appears you cannot trick IE to download a file that is not an actual Excel file even though it has the correct postfix. So ...anyone can propose a solution for me to pursue ...simple requirement ...extract data from WebDNA DB, save it as Excel with a link for download that works (not blocked by IE). Many thanks ...Terry Nair
"Terry Nair"
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Stopping bad HTML propagation ? (1997)
how to construct a search for not this entire string? (2000)
PCS Frames-Default page is solution! (1997)
Clickable maps and WebCatalog? (1996)
Emailer port change (1997)
Search/sort in URL Was: GuestBook example (1997)
Set Line Item (1999)
Re:appending to the database (1999)
emailer (1997)
suffix mapping for NT? (1997)
Nice package (1998)
Limitations on fields? Server is crashing (1997)
Webcat 2.0.1b1 bug with IE 3.01/4.0p1 (1997)
OT: Web Cams (2003)
WebCat2 several catalogs? (1997)
RE:It just Does't add up!!! (1997)
More questions about serial number dishing (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Emailer errors (1997)
MS Access data conversion (2001)