I hope there's an easy answer to this, I'm trying to import some data from a single excel file and also same sheet, but it is not ordered consecutively, so what I did was this:
myRange = get(handles.listbox1,'Value'); myCells = sprintf('AF%d:AF%d',myRange+1, myRange+1); BTF = xlsread('Section.xls', 1, myCells); myCells2 = sprintf('AH%d:AH%d',myRange+1, myRange+1); HTW = xlsread('Section.xls', 1, myCells2); myCells3 = sprintf('AL%d:AL%d',myRange+1, myRange+1); ZX = xlsread('Section.xls', 1, myCells3); myCells4 = sprintf('AR%d:AR%d',myRange+1, myRange+1); RY = xlsread('Section.xls', 1, myCells4); myCells5 = sprintf('AU%d:AU%d',myRange+1, myRange+1); JJ = xlsread('Section.xls', 1, myCells5); myCells6 = sprintf('AV%d:AV%d',myRange+1, myRange+1); CW = xlsread('Section.xls', 1, myCells6);
This takes too much time to process and I still need to import more ranges. Any Ideas anyone??
Best Answer