MATLAB: .mat file name as a variable

file namemat

I have ~50 .mat files to run through a script and extract one row of specified values per file. I'm then exporting each row to an excel spreadsheet. My problem is that I want to include the .mat file name as a column in the spreadsheet, so I need to save the name as a variable. Since I'm manually opening each .mat file, I can't find a way to reference its name in the script. Any suggestions? Thanks!

Best Answer

use uigetfile to manually select the file name, so that you have the name as a string, fname. Then you can use load(fname) to load in the file and you can store fname in a cell of the spreadsheet.

Related Solutions

MATLAB: .mat file

You can use MAT-file interface library to read & write MAT files from standalone C or Fortran code.

See Custom Applications to Read and Write MAT-Files

MATLAB: How to save matlab file according to excel sheet name

Try this:

file_list={'filename1', 'filename2'};
sheet_list= {'sheet1', 'sheet2'};
for q = 1 : length(file_list)
  baseFileName = file_list{q};  
  sheetName = sheet_list{q};
  thisInputFileName = sprintf('%s.xlsx', baseFileName);
  if exist(thisInputFileName, 'file')
    % Import data:
    xlsx_file = xlsread(thisInputFileName, sheetName);
    % Create filename for the output .mat file:
    thisOutputFileName = sprintf('%s_%s.mat', baseFileName, sheetName);
    % Export 'xlsx_file' variable contents to mat file:
    save (thisOutputFileName, 'xlsx_file')
  end
end

Best Answer

Related Solutions

MATLAB: .mat file

MATLAB: How to save matlab file according to excel sheet name

Related Question