Hi all, I want to write a matlab code that takes a CSV file, transforms it into an excel file under the same name and pulls only the three columns I want. It does that for all the files in a folder, then it throws them into a new folder. I have one that works great, but unfortunately Matlab renames the columns "Var4" Var5" Var6." Does anyone know how to keep the original headers? In theory, the headers should be the same for all the files but its a good back-check to keep the original when the data is visualized (and the headers become axes) later.
Below is my current code with commented out explanations.
% Specify the directory containing CSV files
csvDirectory = 'C:\\Users\\Myname\\Documents\\MATLAB\\playground';
% Create a subfolder for the Excel files
outputFolder = fullfile(csvDirectory, 'ExcelOutput');
mkdir(outputFolder);
% Get a list of CSV files in the directory
csvFiles = dir(fullfile(csvDirectory, '*.csv'));
% Iterate over each CSV file
for i = 1:length(csvFiles)
% Get the current CSV file name
csvFileName = fullfile(csvDirectory, csvFiles(i).name);
% Read the CSV file
data = readtable(csvFileName);
% Extract the specified columns (4, 5, 6) along with headers
selectedData = data(:, [4, 5, 6]);
% Specify the new Excel file name
% excelFileName = strrep(csvFileName, '.csv', '.xlsx');
% Specify the new Excel file name in the subfolder
excelFileName = fullfile(outputFolder, [strrep(csvFiles(i).name, '.csv', '_modified.xlsx')]);
% Write the selected data to an Excel file with headers
writetable(selectedData, excelFileName, 'WriteVariableNames', true);
disp(['Excel file "', excelFileName, '" created successfully.']);
end
*update*: the above code was working and now I get an "Error using mkdir. Access is denied." error...
