AnsweredAssumed Answered

simple import script to read specific Excel cells

Question asked by Jax on Oct 29, 2013
Latest reply on Oct 29, 2013 by 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.

Outcomes