Standard Height and Width of Row in Excel

[shiveshsingh]

Please let me know what should be Standard Height and Width of Row in Excel, during loading in Qlikview

If Dimension is more then this filter works "(ooxml, embedded labels, header is 1 lines, table is [Excel_GSK_SOB_Export_Template-R])"

else this works "(ooxml, embedded labels, table is [Excel_GSK_SOB_Export_Template-R])"

May be someone came across such issue?

[Peter_Cammaert]

Just try it.

[marcus_sommer]

I made also a check and could confirm this behaviour. I assume that Excel marked the row as not empty if the row-height s different to the default value.

edit: If we look on the xml behind of those sheets we see that they are different by the dimension ref:

<?xml version="1.0" encoding="UTF-8" standalone="true"?>

<worksheet xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac" mc:Ignorable="x14ac" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

<dimension ref="A1:A2"/>

<sheetViews>

...

<?xml version="1.0" encoding="UTF-8" standalone="true"?>

<worksheet xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac" mc:Ignorable="x14ac" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

<dimension ref="A1:A3"/>

<sheetViews>

...

- Marcus

[shiveshsingh]

Thanks for analysis.

So, the root cause is excel behaviour on changing the default Row Height?

Am I correct?

[marcus_sommer · Accepted solution]

Yes, I think that's the reason. You could try a shot within the office-communities if you could find anything about it but I think if you couldn't influence the excel-source you will need some logics to ensure a stable load-process.

Maybe a first load of a single record and then checking a certain cell-value with peek() and based on this setting the header-lines through a variable or some other logics maybe with ERRORMODE.

- Marcus

[shiveshsingh]

Thanks for your time