Re: Another Excel Problem

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 51852
interpreted = N
texte = Donovan Alain's .csv format suggestion solved the problem. A carriage return is required somewhere in the writefile, to specify a new record in the file, it can be at the beginning of the founditems or at the end. I seem to remember when I originally did this code a year or so ago that it worked best where it is now :) On Wednesday, July 23, 2003, at 01:07 PM, Donovan wrote: > 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/ > > 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/ 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)
Donovan Alain's .csv format suggestion solved the problem. A carriage return is required somewhere in the writefile, to specify a new record in the file, it can be at the beginning of the founditems or at the end. I seem to remember when I originally did this code a year or so ago that it worked best where it is now :) On Wednesday, July 23, 2003, at 01:07 PM, Donovan wrote: > 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/ > > 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/ 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:

Expires header (1999) can WC render sites out? (1997) Add message to Order (1997) Dummy Credit Card Number for debug? (1997) Multiple Admins through users.db (1997) How true is this? (1999) WebCatalog for guestbook ? (1997) [HIDEIF] inside [FOUNDITEM] (1997) select multiple 2 more cents (1997) What really killed WebDNA? (2007) Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997) WC --> printer (1998) The old multiple selection bit (2000) Robert Minor duplicate mail (1997) WebCat2 beta 11 - new prefs ... (1997) Cannot calculate prices (1997) Support ?? (1997) Setting up shop (1997) Testing (2003) Wait, I forgot something! (was authenticating a seconduser, the sequel) (1997)