MATLAB数组与字符串处理困惑：多维度数据导出Excel文件名生成问题

Hey there! Let's break down how to tackle this MATLAB data grouping and Excel export problem step by step—sounds like you're dealing with nested data structures (site → core → depth data) and string formatting snags that can trip up even experienced users. Let's fix this together.

First, make sure your data is structured so MATLAB can loop through each core easily. A struct array is perfect here—each element represents a core, with clear fields for your metadata and depth measurements. Here's a quick example setup:

% Sample core data structure
coreData(1).SiteID = 'Site_Alpha';
coreData(1).CoreName = 'North_Core';
coreData(1).CoreYear = 2019;
coreData(1).DepthData = table([1;3;5], [0.45;0.62;0.78], 'VariableNames', {'Depth_m', 'Porosity'});

coreData(2).SiteID = 'Site_Alpha';
coreData(2).CoreName = 'South_Core';
coreData(2).CoreYear = 2020;
coreData(2).DepthData = table([2;4;6], [0.51;0.68;0.82], 'VariableNames', {'Depth_m', 'Porosity'});

If your data is currently scattered across separate arrays, take 5 minutes to bundle it into this struct format—it'll save you hours of headache later.

The tricky part is combining your site ID, core name, and year into a filename that works for Excel. Avoid spaces/special characters (they cause errors!) and use underscores instead. You have two solid options in MATLAB:

% Option 1: Classic sprintf (works for all MATLAB versions)
filename = sprintf('%s_%s_%d.xlsx', coreData(i).SiteID, coreData(i).CoreName, coreData(i).CoreYear);

% Option 2: Modern string concatenation (R2016b+)
filename = string(coreData(i).SiteID) + "_" + string(coreData(i).CoreName) + "_" + string(coreData(i).CoreYear) + ".xlsx";

Pro tip: If your site/core names have spaces, clean them up first with strrep(coreName, ' ', '_') to avoid Excel file path issues.

Now put it all together in a loop to export every core's depth data to a separate file. We'll use writetable (the recommended tool for table data) here:

for i = 1:length(coreData)
    % Extract core details and data
    site = coreData(i).SiteID;
    core = coreData(i).CoreName;
    year = coreData(i).CoreYear;
    depthTable = coreData(i).DepthData;
    
    % Clean and create filename
    cleanSite = strrep(site, ' ', '_');
    cleanCore = strrep(core, ' ', '_');
    filename = sprintf('%s_%s_%d.xlsx', cleanSite, cleanCore, year);
    
    % Export to Excel
    writetable(depthTable, filename);
    fprintf('Exported successfully: %s\n', filename); % Optional progress update
end

If all your data lives in one big table with columns like SiteID, CoreName, CoreYear, Depth_m, Porosity, you can group by core identifiers and export each group:

% Sample combined table
dataTable = table(...
    repmat({'Site_Alpha'}, 6,1), ...
    [repmat({'North_Core'},3,1); repmat({'South_Core'},3,1)], ...
    [repmat(2019,3,1); repmat(2020,3,1)], ...
    repmat([1;3;5],2,1), ...
    [0.45;0.62;0.78;0.51;0.68;0.82], ...
    'VariableNames', {'SiteID', 'CoreName', 'CoreYear', 'Depth_m', 'Porosity'});

% Get unique core groups
[uniqueCores, ~, groupIdx] = unique(dataTable(:, {'SiteID', 'CoreName', 'CoreYear'}), 'rows');

% Loop through each core group
for i = 1:height(uniqueCores)
    groupData = dataTable(groupIdx == i, :);
    site = uniqueCores.SiteID(i);
    core = uniqueCores.CoreName(i);
    year = uniqueCores.CoreYear(i);
    
    filename = sprintf('%s_%s_%d.xlsx', strrep(site,' ','_'), strrep(core,' ','_'), year);
    writetable(groupData, filename);
end

• String/Char Mix-Ups: MATLAB has two string types (classic char arrays 'like this' and modern string objects "like this"). If you get errors, convert between them with string() or char().
• Invalid Filenames: Check for forbidden characters (:, /, *, etc.)—use strrep to replace them with underscores.
• Nested Data: If your data is nested (site structs containing core structs), add an outer loop to iterate over sites first, then cores within each site.

内容的提问来源于stack exchange，提问作者user1968084