Re: writefile, csv, tab and excel import behavior
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58225
interpreted = N
texte = With Excel 2003, you can right click a grid on anywebpage and it will import all the columns right intoExcel for you.Gary Krockover
wrote:Can yousend me a sample file? What version of Excel are youusing, PC or Mac? I avoid importing/exporting to/from Excel at allcosts, that's when you get M$ doing it's thing to your data. Instead, Iopen a sheet, select all, set to "Text" and then past in the data into cellA1 from the text file (it will recognize the tabs and set yourcolumns). No formatting or calculations done at all.GKAt 11:24 PM 6/4/2004, you wrote:>Unfortunately it still tries to evaluate numericfields.>>They only way I have seen around this is to treat theexported file as a>text file and use the excel text import wizard.>>I just recently purchased Urchin and it has an exceland word export option>for all its reports. They actually are in excel 2000and word 2000 format. I>am assuming this is done within the app. Are theirany 3rd party cgi prog>that can do this? I am trying to make this as idiotproof for the client as>possible.>>Vincent-------------------------------------------------------------This message is sent to you because you are subscribedtothe 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/=====Salvatore D'annaMCP, MCSE-------------------------------------------------------------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:
|
- Re: writefile, csv, tab and excel import behavior ( Sal D'Anna 2004)
- Re: writefile, csv, tab and excel import behavior ( Gary Krockover 2004)
- Re: writefile, csv, tab and excel import behavior ( "Vincent Medina" 2004)
- Re: writefile, csv, tab and excel import behavior ( Gary Krockover 2004)
- writefile, csv, tab and excel import behavior ( "Vincent Medina" 2004)
|
With Excel 2003, you can right click a grid on anywebpage and it will import all the columns right intoExcel for you.Gary Krockover wrote:Can yousend me a sample file? What version of Excel are youusing, PC or Mac? I avoid importing/exporting to/from Excel at allcosts, that's when you get M$ doing it's thing to your data. Instead, Iopen a sheet, select all, set to "Text" and then past in the data into cellA1 from the text file (it will recognize the tabs and set yourcolumns). No formatting or calculations done at all.GKAt 11:24 PM 6/4/2004, you wrote:>Unfortunately it still tries to evaluate numericfields.>>They only way I have seen around this is to treat theexported file as a>text file and use the excel text import wizard.>>I just recently purchased Urchin and it has an exceland word export option>for all its reports. They actually are in excel 2000and word 2000 format. I>am assuming this is done within the app. Are theirany 3rd party cgi prog>that can do this? I am trying to make this as idiotproof for the client as>possible.>>Vincent-------------------------------------------------------------This message is sent to you because you are subscribedtothe 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/=====Salvatore D'annaMCP, MCSE-------------------------------------------------------------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/
Sal D'Anna
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:
[WebDNA] 2nd pair of eyes on redirect please (2011)
customer info (2001)
Summing fields in a search/founditems context?? (2000)
Listserver problem (1997)
UnitShipCost, Formulas.db and passwords (2003)
Searchable list archive (1997)
I'm new be kind (1997)
OT: Alias/Shortcut on Windows server (2003)
You know you have made your client successfully when... (2003)
[SHOWIF] (1997)
[OT] Next Gen Browsers [Was] Decimal point in search.... (2004)
Writefile, Raw & include (2002)
FEA REQ: One .hdr, multiple .db's (2003)
setting values (1998)
Text limits in NT version? (1997)
problem with NT beta (1997)
OT: Backup Strategies (2007)
Cookie set browser session. (1998)
form crasehes server (1997)
[cart] not being interpreted inside [founditems] (1997)