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 the first 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:

    
  1. Re: Another Excel Problem ( Donovan 2003)
  2. Re: Another Excel Problem ( Stuart Tremain 2003)
  3. Re: Another Excel Problem ( Donovan 2003)
  4. Re: Another Excel Problem ( Donovan 2003)
  5. Re: Another Excel Problem ( Stuart Tremain 2003)
  6. Re: Another Excel Problem ( Glenn Busbin 2003)
  7. Re: Another Excel Problem ( "Gary Krockover" 2003)
  8. Re: Another Excel Problem ( "Alain Russell" 2003)
  9. Another Excel Problem ( Stuart Tremain 2003)
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 the first 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)