Re: Another Excel Problem
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 51840
interpreted = N
texte = You will get this error if any of the fields contain a carriage return ortab or some other webdna [url]'d value. e always get around this by writingout files in .csv format"[field]","[field2]" etc etc ..Alain----- Original Message ----- From: "Stuart Tremain"
To: "WebDNA Talk" Sent: Wednesday, July 23, 2003 12:43 PMSubject: Another Excel Problem> This creates a tab delimited file that I hope would open in Excel.>> [Search db=recall.db&geIDdatarq=0&asIDsort=1&IDtype=num]>> [WriteFile> file=recallreports/recall[math]{[date]}[/math].xls]ID dBDate dBTime> Salutation Firstname Surname Address City State Zip Country Phone Email> Model SerialNumber> [FoundItems]> [ID] [dBDate] [dBTime] [Salutation] [Firstname] [Surname] [Address]> [City] [State] [Zip] [Country] [Phone] [Email] [Model] [SerialNumber][/> FoundItems][/WriteFile]>> [/Search]>> Unfortunately I get an error "SYLK: File format is not valid" when> opening in Excel.>> any ideas?>>> Regards>> Stuart Tremain> idfk web developments> 114a/40 yeo street neutral bay 2089 australia> t +612 9908 2134> f +612 9908 4837>>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to> Web Archive of this list is at: http://webdna.smithmicro.com/>-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
You will get this error if any of the fields contain a carriage return ortab or some other webdna [url]'d value. e always get around this by writingout files in .csv format"[field]","[field2]" etc etc ..Alain----- Original Message ----- From: "Stuart Tremain" To: "WebDNA Talk" Sent: Wednesday, July 23, 2003 12:43 PMSubject: Another Excel Problem> This creates a tab delimited file that I hope would open in Excel.>> [Search db=recall.db&geIDdatarq=0&asIDsort=1&IDtype=num]>> [WriteFile> file=recallreports/recall[math]{[date]}[/math].xls]ID dBDate dBTime> Salutation Firstname Surname Address City State Zip Country Phone Email> Model SerialNumber> [founditems]> [ID] [dBDate] [dBTime] [Salutation] [Firstname] [Surname] [Address]> [City] [State] [Zip] [Country] [Phone] [Email] [Model] [SerialNumber][/> FoundItems][/WriteFile]>> [/Search]>> Unfortunately I get an error "SYLK: File format is not valid" when> opening in Excel.>> any ideas?>>> Regards>> Stuart Tremain> idfk web developments> 114a/40 yeo street neutral bay 2089 australia> t +612 9908 2134> f +612 9908 4837>>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to> Web Archive of this list is at: http://webdna.smithmicro.com/>-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
"Alain Russell"
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:
is your webDNA site 'froogle' ready ??? (2003)
Okay, I give up... (1999)
Web Site (2000)
UPDATE PROBLEM (1997)
[WebDNA] Ubuntu 14.04 & WebDNA (2017)
[TaxableTotal] - not working with AOL and IE (1997)
ShowIf inside formulas (1997)
RE: [WebDNA] [OT] Free Windows FTP client recommendations (2009)
[WebDNA] WebDNA code displaying on page (2012)
Fun with dates (1997)
Sorting by sku (2001)
WebCat2b12 CGI Mac -- Problems propagating the cart through (1997)
WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997)
[isfile] ? (1997)
Return records from another (1997)
authorizenet and netscape (2002)
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)
customizing the color of user's pages (1997)
FAX orders (1996)
Automated FTP from Shell - Update (2004)