Re: Another Excel Problem

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 51841
interpreted = N
texte = FWIW, I always do a normal append to a temporary database and then copy that database to another location and rename the file with an .xls extension (or copy to a location and give it the .xls extension on the copyfile). You can then do a delete on the temp db to clear it for another append with different values. I just don't trust the [field1][field2] in a writefile. The way I've done it opens up perfectly in Excel every time for me. GK ----- Original Message ----- From: "Alain Russell" To: "WebDNA Talk" Sent: Tuesday, July 22, 2003 8:06 PM Subject: Re: Another Excel Problem > 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/ 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)
FWIW, I always do a normal append to a temporary database and then copy that database to another location and rename the file with an .xls extension (or copy to a location and give it the .xls extension on the copyfile). You can then do a delete on the temp db to clear it for another append with different values. I just don't trust the [field1][field2] in a writefile. The way I've done it opens up perfectly in Excel every time for me. GK ----- Original Message ----- From: "Alain Russell" To: "WebDNA Talk" Sent: Tuesday, July 22, 2003 8:06 PM Subject: Re: Another Excel Problem > 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/ "Gary Krockover"

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:

WebCat NT v. Mac (1997) Include a big block of text (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) off topic - dna snipets (1997) # fields limited? (1997) Forcing a NEWCART (1997) WebCatalog2 Feature Feedback (1996) Smart caching problems with 2.1b3? (1997) [WebDNA] WebDNA Showcase? (2008) Beta 18 (1997) Multi Colonns (1998) WC 2.0 frames feature (1997) First n words (2000) View order not right (1997) About Cookies... (2004) Re1000002: Setting up shop (1997) Help name our technology! I found it (1997) Summing fields (1997) Webcatalog Future?!? (2000) can WC render sites out? (1997)