I am loading multiple excel sheets to my Qlikview document. the excels are of same format and have same field names, bu with different sheet names. I am loading all the files separately and it takes lot of time to load the files. Is there a better way to load excel to Qliview and to reduce the reload time.
Could you tell us what "lot of time" is. How many Excel sheets are you loading and how many workbooks? What is the size of each spreadsheet - in rows, columns and bytes. Is it the old XLS format or the new XLSX format?
You need to provide more information if you want useful help. How are you loading them, how many fields, how many columns, any special format. A load script and a sample of one of the files would also help us help you.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein