how can I copy & paste from excel into AAC's table function?

Discussion in 'Off-Topic' started by strantor, Apr 13, 2012.

  1. strantor

    Thread Starter AAC Fanatic!

    Oct 3, 2010
    4,302
    1,988
    I've copied & pasted tables from websites into AAC before and it worked just fine. I just selected the text data, and then clicked the table button and AACs table function automatically recognized each cell and each row and did i perfectly. So I know it has the capability. When I do the same thing from Excel however, it doesn't work. It lump all the columns together in each row. I tried saving my document in several formats thinking it was some kind of invisible formatting issue but no luck. So what do I have to do?
     
  2. nerdegutta

    Moderator

    Dec 15, 2009
    2,515
    785
    You could try:

    Save the Excel file as an *.html file
    View the file in your Internet browser
    Copy/paste from that file
     
  3. strantor

    Thread Starter AAC Fanatic!

    Oct 3, 2010
    4,302
    1,988
    Yeah the result is the same. looks like this:
    (copied from HTML file)
    QTYNewark PART #DESCRIPTION UNIT COST TOTAL COST 393K5434 PCB mount 12V relay $ 2.28 $ 6.84 226R4228 RESISTOR, METAL GLAZE, 20 MOHM, 500 MW, ± 5% $ 0.12 $ 0.24 196M9178
    12V wall wart p/s for fault tester $ 13.53 $ 13.53 1070R0064TERM BLK, PCB, SCREW, 5.0MM, 2WAY $ 0.73 $ 7.30 113T9276Enclosure for the Arduino Duemilanove or Mega w/ Ethernet Shield $ 9.46 $ 9.46 113T9277
    ARDUINO UNO Board w/ Workshop Starter Kit (just buy the 25$ arduino, not the kit)
    $ 71.38 $ 71.38 213T9280
    PROTOTYPE BOARD FOR ARDUINO UNO $ 10.42 $ 20.84 389K1072TIP120 DARLINGTON TRANSISTOR, NPN, 60V, TO-220 $ 0.43 $ 1.29 101M7886CONVERTER, DC/DC, 1.5W, +1000V
    $ 183.00 $ 183.00 131K7040OPTOCOUPLER, DARLINGTON, 3750VRMS $ 7.02 $ 7.02 Total $ 320.90


    I've tried html, csv, etc.

    should look like this:
    [​IMG]
     
  4. MrChips

    Moderator

    Oct 2, 2009
    12,437
    3,360
    As far as I know, columns are separated by the | symbol.
    You have to have the same number of columns in each line.
     
  5. strantor

    Thread Starter AAC Fanatic!

    Oct 3, 2010
    4,302
    1,988
    That's not working either.
    QTY Newark PART # DESCRIPTION UNIT COST TOTAL COST
    3 93K5434 PCB mount 12V relay $ 2.28 $ 6.84
    2 26R4228 RESISTOR, METAL GLAZE, 20 MOHM, 500 MW, ± 5% $ 0.12 $ 0.24
    1 96M9178 12V wall wart p/s $ 13.53 $ 13.53
    10 70R0064 TERM BLK, PCB, SCREW, 5.0MM, 2WAY $ 0.73 $ 7.30
    1 13T9276 Enclosure for the Arduino Duemilanove or Mega $ 9.46 $ 9.46
    1 13T9277 ARDUINO UNO Board w/ Workshop Starter Kit (just buy the 25$ arduino, not the kit) $ 71.38 $ 71.38
    2 13T9280 PROTOTYPE BOARD FOR ARDUINO UNO $ 10.42 $ 20.84
    3 89K1072 TIP120 DARLINGTON TRANSISTOR, NPN, 60V, TO-220 $ 0.43 $ 1.29
    1 01M7886 CONVERTER, DC/DC, 1.5W, +1000V $ 183.00 $ 183.00
    1 31K7040 OPTOCOUPLER, DARLINGTON, 3750VRMS $ 7.02 $ 7.02
    Total $ 320.90


    Code ( (Unknown Language)):
    1. |QTY | Newark PART # | DESCRIPTION                                   | UNIT COST | TOTAL COST
    2. |3   | 93K5434       | PCB mount 12V relay                           | $ 2.28    | $ 6.84
    3. |2   | 26R4228       | RESISTOR, METAL GLAZE, 20 MOHM, 500 MW, ± 5%  | $ 0.12    | $ 0.24
    4. |1   | 96M9178       | 12V wall wart p/s                             | $ 13.53   | $ 13.53
    5. |10  | 70R0064       | TERM BLK, PCB, SCREW, 5.0MM, 2WAY             | $ 0.73    | $ 7.30
    6. |1   | 13T9276       | Enclosure for the Arduino Duemilanove or Mega | $ 9.46    | $ 9.46
    7. |1   | 13T9277       | ARDUINO UNO Board w/ Workshop Starter Kit (just buy the 25$ arduino, not the kit) | $ 71.38 | $ 71.38
    8. |2   | 13T9280       | PROTOTYPE BOARD FOR ARDUINO UNO               | $ 10.42   | $ 20.84
    9. |3   | 89K1072       | TIP120 DARLINGTON TRANSISTOR, NPN, 60V, TO-220| $ 0.43    | $ 1.29
    10. |1   | 01M7886       | CONVERTER, DC/DC, 1.5W, +1000V                | $ 183.00  | $ 183.00
    11. |1   | 31K7040       | OPTOCOUPLER, DARLINGTON, 3750VRMS             | $ 7.02    | $ 7.02  
    12. |    |               |                                               | Total     | $ 320.90  
    13.  




    EDIT: AHA! apparently it is working, just not in the post preview. how strange!
    Still, That took me a while in noepad putting all those extra characters in. it would be nice if it were as simple as copy & paste.
     
  6. studiot

    AAC Fanatic!

    Nov 9, 2007
    5,005
    513
    Hey guys that's fantastic. Thanks a bundle I've been wanting to display tables for ages.


    Code ( (Unknown Language)):
    1. | 1234 |Col test1|tabletest1|
    2. |123456|line2|tabletest1
     
  7. Markd77

    Senior Member

    Sep 7, 2009
    2,803
    594
    I guess you could insert columns of | in the spreadsheet. Still fairly tedious.

    This little formula should do it:
    [​IMG]

    ITEM PRICE
    Resistor 0.01
    Flux Capacitor 12700.39
    PIC10F200 0.34


    I guess you have to convert the original to text if you want the currency sign to work.
     
    Last edited: Apr 13, 2012
    strantor likes this.
  8. loosewire

    AAC Fanatic!

    Apr 25, 2008
    1,584
    435
    The wise men of the Forum,good job guys.
     
Loading...