10 Replies Latest reply: Apr 21, 2017 2:43 AM by Anat Dagan RSS

    How can I limit the amount of table rows uploaded in a script?

    Anat Dagan

      I have an excel spreadsheet that contains 2 separate tables one under the other . They are separated by a blank row. The top table has a permanent amount of rows (4 + headers). The structure of the spreadsheet  cannot be changed.

       

      I want to load them as 2 separate tables.

      I can easily set the beginning of the dataload for the bottom table by setting the correct number in "header is x lines".

       

      Is there a way to limit the amount of rows uploaded from the top table?

       

      example:

      Propertiesoption 1Option 2
      size35
      weight3030
      height1.52.3
      depth

      5

      6

      Color PricesOption 1Option 2
      Blue5$10$
      Red6$10$
      Yellow7$10$