5 Replies Latest reply: Feb 25, 2016 12:11 AM by V SUDHAKAR RSS

    auto load all excel files in a root directory

    Josh Chang

      Hello,

       

      One of root directory keeps all excel files and they are organized in a hierarchical structure like:

      root --- vendor A --- year2010 -- *.xls

               |                   |

               |                   +-- year 2011 -- *.xlsx

               |                              ...

               ---vendor B --- year2011 -- *.xls

                                   |

                                   +--year2012 -- *.xls

                                   |

                                   +--year2013 -- *.xlsx

                                         .....

      ....

       

      How to write a script to load all *.xls or *.xlsx files under root directory, and once a file has been loaded it won't be loaded again?

       

      Thanks,

      Josh