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 or tab or some other webdna [url]'d value. e always get around this by writing out files in .csv format "[field]","[field2]" etc etc .. Alain ----- Original Message ----- From: "Stuart Tremain" To: "WebDNA Talk" Sent: Wednesday, July 23, 2003 12:43 PM Subject: 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:

    
  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)
You will get this error if any of the fields contain a carriage return or tab or some other webdna [url]'d value. e always get around this by writing out files in .csv format "[field]","[field2]" etc etc .. Alain ----- Original Message ----- From: "Stuart Tremain" To: "WebDNA Talk" Sent: Wednesday, July 23, 2003 12:43 PM Subject: 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)