Sorry, but it looks like the last M-code sample that I posted does NOT import all Excel files in a folder. Well, at least I couldn't get it to work. This, however, does work.
% % Import all excel files in a folder into multiple Matlab variables. % % Your variables will be num1, num2, ...etc d = dir('C:\Users\Ryan\Desktop\Excel_Files\*.xls*'); nfiles = length(d); for k = 1:nfiles n=int2str(k); eval(['[num' n ', txt' n ', raw' n '] = xlsread(d(k).name,1);']); end
"Ryan" wrote in message <firstname.lastname@example.org>... > Run this code to convert all .XSLX files in a specific folder, of your choosing, to .XSL files. > > Sub Convert_xls_Files() > > Dim strFile As String > Dim strPath As String > > With Application > .EnableEvents = False > .DisplayAlerts = False > .ScreenUpdating = False > End With > 'Turn off events, alerts & screen updating > > strPath = "C:\Users\rshuell\Desktop\Excel_Files\" > strFile = Dir(strPath & "*.xls") > 'Change the path as required > > Do While strFile <> "" > Workbooks.Open (strPath & strFile) > strFile = Mid(strFile, 1, Len(strFile) - 5) & ".xls" > ActiveWorkbook.SaveAs Filename:=strPath & strFile, FileFormat:=xlOpenXMLWorkbook > ActiveWorkbook.Close True > strFile = Dir > Loop > 'Opens the Workbook, set the file name, save in new format and close workbook > > With Application > .EnableEvents = True > .DisplayAlerts = True > .ScreenUpdating = True > End With > 'Turn on events, alerts & screen updating > > End Sub > > Try to import the .XLS files into your Matlab. > > > > You won't be able to load them all at once but you could easily use a for-loop to process them one at a time. Something like this: > > source_dir = 'path/to/source/' > dest_dir = '/path/to/dest' > source_files = dir(fullfile(source_dir, '*.xls')); > for i = 1:length(source_files) > data = xlsread(fullfile(source_dir, source_files(i).name))); > #do something with data > xlswrite(fullfile(dest_dir, source_files(i).name))); > end > > > > "Ryan" wrote in message <email@example.com>... > > I hate Macs so much!! What exactly is the problem? You need to convert a bunch of XLSX files to XLS files b/c you don't have Matlab 2012a? I can crate an Excel Macro for you to go into all XLSX files in a specific folder, and convert all files to XLS files. Will that do it for you? > > > > Regards, > > Ryan-- > > > > Gadi Reinhorn <firstname.lastname@example.org> wrote in message <5130E273.email@example.com>... > > > The functionality you need was added in R2012a: > > > http://www.mathworks.com/help/releases/R2012a/techdoc/rn/bs7oakc-1.html#btau8hq > > > > > > xlsread Reads XLSX Files on All Platforms > > > > > > The xlsread function now reads data from XLSX files on all platforms, > > > including support for specifying the range and worksheet number. > > > Previously, this functionality was available only on Microsoft Windows > > > systems with Excel® software. > > > > > > > > > Gadi