Re: How do I prevent empty columns from being loaded from excel?
This is caused from any content which is in the columns. I'm not sure how Qlik identifies them but I assume that it just accessed the Excel meta-data information of UsedRange or something similar and this means that each cell which has different object-properties (in content and each kind of layout) then a default cell will be included.
The easiest way is suggested from vishsaggi just to delete this content respectively columns within the Excel itself. But even in Qlik it's quite easy done - not within the wizard else by clicking on finish and then removing all these columns in the script - just mark them by dragging the mouse and delete.