Re: Another Excel Problem
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 51850
interpreted = N
texte = Stuart Tremain wrote:> 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]Stuart,(don't know if your problem is solved but upon copying this into a text editor you have a return after the first founditems. (you should just start the first field value after thefirst founditems.)Donovan> > 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> -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design Developer / Consultant <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design P.O. Box 260153 Madison, WI 53726-0153 PH:> 1.608.442.5217 email:> dbrooke@euca.us Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o-------------------------------------------------------------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:
Stuart Tremain wrote:> 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]Stuart,(don't know if your problem is solved but upon copying this into a text editor you have a return after the first founditems. (you should just start the first field value after thefirst founditems.)Donovan> > 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> -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design Developer / Consultant <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design P.O. Box 260153 Madison, WI 53726-0153 PH:> 1.608.442.5217 email:> dbrooke@euca.us Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o-------------------------------------------------------------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/
Donovan
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:
Can WebDNA do this? (2000)
multiGroupChecker code redundant? (2000)
RE: WebCatalog and Webstar 3.02 (1998)
Searchable WebCat (etc.) Docs ? (1997)
frames & carts (1997)
success - serial numbers and webmerch (1997)
[WriteFile] problems (1997)
Webcat 2.0.1 date math bug -> Crash! (1997)
Multiple Currencies (2002)
problems with 2 tags (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
tcpconnect return (2003)
how to post without certain data appearing in the html source (2001)
possible, WebCat2.0 and checkboxes-restated (1997)
[WebDNA] Deliminating encrypted values (2008)
[shell]? (2000)
WebCat, The Trend, & Consolidating... (1997)
Authenticate (2000)
[WebDNA] Developer Resources (2011)
A Global Variable (1997)