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 any webpage and it will import all the columns right into Excel for you. Gary Krockover wrote:Can you send me a sample file? What version of Excel are you using, PC or Mac? I avoid importing/exporting to/from Excel at all costs, that's when you get M$ doing it's thing to your data. Instead, I open a sheet, select all, set to "Text" and then past in the data into cell A1 from the text file (it will recognize the tabs and set your columns). No formatting or calculations done at all. GK At 11:24 PM 6/4/2004, you wrote: >Unfortunately it still tries to evaluate numeric fields. > >They only way I have seen around this is to treat the exported file as a >text file and use the excel text import wizard. > >I just recently purchased Urchin and it has an excel and word export option >for all its reports. They actually are in excel 2000 and word 2000 format. I >am assuming this is done within the app. Are their any 3rd party cgi prog >that can do this? I am trying to make this as idiot proof for the client as >possible. > >Vincent ------------------------------------------------------------- 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/ ===== Salvatore D'anna MCP, 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:

    
  1. Re: writefile, csv, tab and excel import behavior ( Sal D'Anna 2004)
  2. Re: writefile, csv, tab and excel import behavior ( Gary Krockover 2004)
  3. Re: writefile, csv, tab and excel import behavior ( "Vincent Medina" 2004)
  4. Re: writefile, csv, tab and excel import behavior ( Gary Krockover 2004)
  5. writefile, csv, tab and excel import behavior ( "Vincent Medina" 2004)
With Excel 2003, you can right click a grid on any webpage and it will import all the columns right into Excel for you. Gary Krockover wrote:Can you send me a sample file? What version of Excel are you using, PC or Mac? I avoid importing/exporting to/from Excel at all costs, that's when you get M$ doing it's thing to your data. Instead, I open a sheet, select all, set to "Text" and then past in the data into cell A1 from the text file (it will recognize the tabs and set your columns). No formatting or calculations done at all. GK At 11:24 PM 6/4/2004, you wrote: >Unfortunately it still tries to evaluate numeric fields. > >They only way I have seen around this is to treat the exported file as a >text file and use the excel text import wizard. > >I just recently purchased Urchin and it has an excel and word export option >for all its reports. They actually are in excel 2000 and word 2000 format. I >am assuming this is done within the app. Are their any 3rd party cgi prog >that can do this? I am trying to make this as idiot proof for the client as >possible. > >Vincent ------------------------------------------------------------- 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/ ===== Salvatore D'anna MCP, 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:

RE: WebDNA-Talk searchable? (1997) Emailer (1997) Foreign Chars ( יאצה and so on) (1998) Sort Order on a page search (1997) unique ID (1997) Inventory Adjustment SOLUTION (2000) Creating folders and deleting files (1997) Showif with an or (2003) restart needed???? (1997) Convert words (2002) Who is doing sign-ups (1998) Date Range Sorting (1997) Separate SSL Server (1997) Download to disk NOT display in browser (2002) America Online Issues (1998) View order not right (1997) Webcat 2.0.1b1 bug with IE 3.01/4.0p1 (1997) Summing fields (1997) Error & Problem (1997) Help: Append context problems (1999)