Hey QV community,
I have a question, how it is possible that I can delete empty Excel rows while I am loading in QV? Of course I can delete this rows in Excel but this is might too easy.
Click on the cross symbol near F4 and F5 and that columns not loaded in the script or you can also comment this ion script
(ooxml, embedded labels, table is Tabelle1);
thank you for your help!
And also if want to remove null values from the rows then load like
(ooxml, embedded labels, table is Tabelle1)
Where Len(Trim(Spieler)) > 0 or Len(Trim(Tore)) > 0 or Len(Trim(Saion)) > 0;
Retrieving data ...