SOFiSTiK Read Spreadsheet Matrix m*n

Hi all,

I have a question regarding the extraction of data from Excel with the Plugin SOFiSTiK Interface, where I have a matrix with an unknown number of rows (m) and columns (n).

For better understanding, I have attached a sample file.
Read Excel.zip (27.9 KB)

Case 1: Vertical Reading

  • A variable number of Excel rows is possible.
  • GH reads only the filled rows.
  • In the example: With a new row, a new path {0;n-1} is simply created.

Case 2: Horizontal Reading

  • A variable number of Excel columns is possible.
  • GH reads only the filled columns.
  • In the example: With a new column, a new path {0;n-1} is simply created.

Problem: Variable Number of Columns AND Rows In both cases, it becomes impossible to change the number of items per path. For this, a new cable connection between ReadXLS and Merge would need to be manually established and this is not desirable as the user should ideally only have access to Excel and not GH.

What is the solution to handle this?

Thank you in advance for your support.