? about Tony's csvout routine

Discussion in 'AutoCAD' started by coachball8, Jun 10, 2004.

  1. coachball8

    coachball8 Guest

    This maybe user ignorance, as I'm not an excel guru by any stretch. I'm using Tony 's csvout to extract electrical tags to a csv file in excel, and it works like a charm with the exception of one little hitch. When a tag number is equal to a date, it changes it to the date in excel. For example, tag #1-25 in AutoCAD is placed in excel as Jan 01. Any insight on why this happens? TIA
     
    coachball8, Jun 10, 2004
    #1
  2. coachball8

    ECCAD Guest

    Excel is changing it. Rename the .csv to .txt, and check it
    in Notepad. You should see the proper data in the .txt file.
    You could open Excel, format the columns as 'text'., then
    import the .csv.

    Bob
     
    ECCAD, Jun 10, 2004
    #2
  3. coachball8

    coachball8 Guest

    Thanks Bob. Works like a charm. But why can't I just change the format of that particular column in the csv file, and it be correct. If I do that, I end up with some weird numbers like 88365. Any idea?
     
    coachball8, Jun 10, 2004
    #3
  4. coachball8

    molokaiboy Guest

    do you have to reformat the values in excel that are extracted? I am trying to do something similar. Could you tell me where you got that csvout lisp.

    TIA

    Collin
     
    molokaiboy, Jun 25, 2004
    #4
  5. coachball8

    ECCAD Guest

    ECCAD, Jun 25, 2004
    #5
  6. coachball8

    molokaiboy Guest

    thanks!
     
    molokaiboy, Jun 25, 2004
    #6
  7. coachball8

    molokaiboy Guest

    This seems to extract text only. Is it able to extract attributes as well?

    Collin
     
    molokaiboy, Jun 25, 2004
    #7
  8. Tony Tanzillo, Jun 25, 2004
    #8
  9. coachball8

    molokaiboy Guest

    I am trying to extract the attribute values to specific cells on an Excel template. Can this be done?

    TIA
    Collin
     
    molokaiboy, Jun 26, 2004
    #9
  10. coachball8

    coachball8 Guest

    Don't know whether you can extract attributes with lisp. I've got a macro that I use to extract them to excel. :)
     
    coachball8, Jun 26, 2004
    #10
  11. coachball8

    molokaiboy Guest

    Can you post or email it to me. Much appreciated.

    Thanks,

    Collin
     
    molokaiboy, Jun 28, 2004
    #11
  12. coachball8

    ECCAD Guest

    Yes, can be easily done - output attribute values to a .csv
    click-on the .csv. Place all in copy-buffer, then paste-special to your .xls. All you need is to define which blocks, which attributes, and how you want them laid-out as far as the columns. I can do the rest..

    Bob
     
    ECCAD, Jun 28, 2004
    #12
  13. coachball8

    molokaiboy Guest

    I am still working on the template. Could you send me a sample so that when I complete my template, I can just add or delete the code.

    TIA

    Collin
     
    molokaiboy, Jun 28, 2004
    #13
Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.