Report should not show rows and columns that are hidden in Excel document.
Many Excel spread sheet that we use have rows and columns that are hidden. When importing these into Tables those hidden rows and columns are not hidden any more. Tables should import from excel exactly like they are shown in Excel spread sheet.