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:
Lookup Notfound (1998)
I need to get a [grep] (2003)
Share cost of training videos! (1998)
Dual 2GHz G5 (2003)
Re:Why did PCS send me this? (1999)
To Err or Not Custom Error (1999)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
totals (1997)
Using [Showif] tag. Mac (1997)
RE: HTTP Header info (1997)
Emailer on NT not working. (1999)
Reversed words (1997)
Garbage display after 100 records (was WebCatalog usage) (1997)
[OT] Happy Turkey Day! (2003)
WebCat2final1 crashes (1997)
For those of you not on the WebCatalog Beta... (1997)
Lots of bounce errors (2007)
[cart] clarification... (1997)
RE: Displaying Location (1997)
$purchase WITHOUT creditcar (1997)