6 Replies Latest reply: Feb 23, 2017 8:55 AM by Cotiso Hanganu RSS

    Automatically pulling data from multiple Excel files.

    Shiva Nagesh

      Hi All,

       

      I have an excel "Mapping Details" which has the cell and sheet details I need to pull for various departments (Each department has different EXCEL files with different formats). Can I do any automation so that if I update any mapping in Mapping Details file, the script should pull the data from the new column automatically when reloaded....