2 Replies Latest reply on Nov 2, 2016 12:01 PM by Jump_Over

    javascript .xls import range = a1: "end of table"  ?

    universe5554

      Dear Indesign-script developers!


      i'm scripting the import of xls tables that are placed in the indd. within the excelimportpreferences i can define the range of cells to import by "range = a1:b4" (importing row a column1 to row b column4)

      simple question: is there a way to get the last row and last column of the xls table? with last i mean the last cell thats not empty.
      depending on that information i'd be able to decide if a set range fills my page, or if my range is at the end of the xls table (if the range is beyond the rows/columns end it results in an error and the script simply aborts.)  "try and catch" to import each single row seperately will take too long for real life xls tables, which have up to 10.000 rows...