2 Replies Latest reply on Oct 29, 2013 10:53 AM by Jax

    simple import script to read specific Excel cells

    Jax

      Title

      simple import script to read specific Excel cells

      Post

           To work around the limitation that standard Excel import is row by row, I would like to create a short script that reads Excel cells that are in the same column into different fields in an FM table. How would one set up a simple Filemaker script that import specific Excel cells?

                                                                                                                                                                                                                                                                                                         
                                                A                     B
                          1                     ID                     1234567
                          2                     last name                     Smith
                          3                     start date                     1/1/2013

            

           The script would:

             
      1.           open a file, e.g. ~/Desktop/import.xls
      2.      
      3.           import B1, B2, B3 into an FM table

            

           I have searched the forum for 20 minutes and found lots of discussion on scripts but very few actual scripts.