Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shiveshsingh
Master
Master

Standard Height and Width of Row in Excel

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?

14 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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
Master
Master
Author

Thanks for analysis.

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

Am I correct?

marcus_sommer

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
Master
Master
Author

Thanks for your time