Re: [WebDNA] Generating Excel File Via WebDNA
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 104660
interpreted = N
texte = I had the same problem on w2003 server & IE.I just changed to .csv extension and all worked 100%, just make sure =that client knows to open in Excel.RegardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 30/01/2010, at 12:21 PM, Terry Nair wrote:> Hi all,>=20> 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.>=20> 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.>=20> 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.>=20> 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.>=20> 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).>=20> Many thanks ...Terry Nair>=20> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list
.> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> old archives: http://dev.webdna.us/TalkListArchive/> Bug Reporting: =http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288
Associated Messages, from the most recent to the oldest:
I had the same problem on w2003 server & IE.I just changed to .csv extension and all worked 100%, just make sure =that client knows to open in Excel.RegardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 30/01/2010, at 12:21 PM, Terry Nair wrote:> Hi all,>=20> 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.>=20> 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.>=20> 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.>=20> 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.>=20> 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).>=20> Many thanks ...Terry Nair>=20> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> old archives: http://dev.webdna.us/TalkListArchive/> Bug Reporting: =http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288
Stuart Tremain
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:
Avery 5160 Mailing Labels (2003)
can WC render sites out? (1997)
disappearing SKU (etc.) fields (1998)
Introduction/Tutorial/QuickStart (1997)
Country & Ship-to address & other fields ? (1997)
WebCat on 10.0.4 - iTools 6.0 (2001)
[WebDNA] WebDNA 8.6 announced - New features (2018)
Accepting credit cards (1997)
Friday night shopping site joke (1997)
[ShowCart] and GET vs. POST (1997)
carriage returns in data (1997)
Another question (1997)
Max Record length restated as maybe bug (1997)
NT License trade for Mac (2000)
RE: WebCatalog2 for NT Beta Request (1997)
Formulas.db + Users.db (1997)
[Sum] function? (1997)
[OT] RSS Feeds (2007)
Word search (1997)
RE: Sum of Quantities (1997)