2 Replies Latest reply: Mar 3, 2014 11:37 PM by Anna ZHuk RSS

    Conditional LOAD

      Hi. I have 2 types of exel files. One type contents direct tables,  another type contents transposed tables.

      I can open each one in macro by excel API to check is table direct or transope, then  make script by macro and after it load.

      But it seems to me this is too difficult for such a simple problem

      Is there another solution?

      Maybe something like

      Load * from [2.xlsx](ooxml, embedded labels, table is Лист1, if( value = 1,  filters(Transpose())); ?