MATLAB: Create an excel file in a specific folder

foldersavexlswrite

I need to know how to create an excel file and save it in a specific folder. This is the code I am using:

filename = 'diagramm.xlsx';
xlswrite(filename,vector_1,'Fluid');
xlswrite(filename,vector_2,'Power');

I don't find anything working in the older answers.

Best Answer

Try this:

folder = 'c:/whatever';
if ~exist(folder, 'dir')
    mkdir(folder);
end
baseFileName = 'diagramm.xlsx';
fullFileName = fullfile(folder, baseFileName);
xlswrite(fullFileName ,vector_1,'Fluid');
xlswrite(fullFileName ,vector_2,'Power');

Related Solutions

MATLAB: How to read an excel file and plot graphs

'test.xls' is not in your current folder. Perhaps it's really called 'test.xlsx' or perhaps it's in a different folder. You can specify the folder it lives in and then use fullfile() to create the full file name.

folder = 'c:/whatever'
fullFileName = fullfile(folder, 'test.xls');
a = xlsread(fullFilename);

OR use the following to have the user manually locate it:

% Have user browse for a file, from a specified "starting folder."
% For convenience in browsing, set a starting folder from which to browse.
startingFolder = 'C:\Program Files\MATLAB';
if ~exist(startingFolder, 'dir')
  % If that folder doesn't exist, just start in the current folder.
  startingFolder = pwd;
end
% Get the name of the file that the user wants to use.
defaultFileName = fullfile(startingFolder, '*.xl*');
[baseFileName, folder] = uigetfile(defaultFileName, 'Select a file');
if baseFileName == 0
  % User clicked the Cancel button.
  return;
end
fullFileName = fullfile(folder, baseFileName)
a = xlsread(fullFilename);

MATLAB: How to use uigetdir to make a folder at certain directory and save some excel data inside the folder

The dialog box itself has a "new folder" menu item so the user can do that. You don't need to do anything.

Best Answer

Related Solutions

MATLAB: How to read an excel file and plot graphs

MATLAB: How to use uigetdir to make a folder at certain directory and save some excel data inside the folder

Related Question