4 Replies Latest reply: Aug 22, 2012 3:28 AM by lornalouw RSS

    Variable and Excel....

      Hi,

       

      I am reading in the Enclosed Excel Sheet (sheet called "Delivery")

       

      I want to be able to read some Columns, advance a few (having data I'm not interested in) and read another few.

       

      In the past I have been able to do that using variables, but for some reason, today, I cant make it work

       

       

      I want to read in the Day, Distance etc for each Registration no (eg 'WLC729GP'). The registration part reading, works fine.


      (My code also included.)

       

      I get the message...Field not found @1....

       

      What am I doing wrong?

       

      All help appreciated

       

      Thank you

        • Re: Variable and Excel....

          Hi

           

          If you load the excel-file directly to have a look on the field names, you will get the following

           

           

          Directory;

          LOAD [VEHICLE 1],

              
          F2,

              
          F3,

              
          F4,

              
          F5,

              
          F6,

              
          F7,

              
          [VEHICLE 2],

              
          F9,

              
          F10,

              
          F11,

              
          F12,

              
          F13,

              
          F14,

              
          [VEHICLE 3],

              
          F16,

              
          F17,

              
          F18,

              
          F19,

              
          F20,

              
          F21,

              
          [VEHICLE 4],

              
          F23,

              
          F24,

              
          F25,

              
          F26,

              
          F27,

              
          F28,

              
          [VEHICLE 5],

              
          F30,

              
          F31,

              
          F32,

              
          F33,

              
          F34

          FROM

          [501_LOGBOOK_JULY12 V.2.xlsx]

          (
          ooxml, embedded labels, table is DELIVERY);



          So, there is really no field @1, they all are named with F or somethimes Vehicle if you renamed it. Maybe you have to load this without field names, but then you will perhaps get A, B, C, ...

           

          Regards Vicky