MATLAB: How to write data to an excel file

excelMATLABtable

In the process of learning how to write data to an excel file, I learnt that I should first write it as a table. So I gave it a try but what my code does is write two row vectors as one long row vector. I wanted to write two variables as two separate rows. Here is my attempt:

(My final goal is to save my workspace data to an excel file.)

data1 = 1:1:10;
data2 = 10:10:100;
data =[data1; data2];
T1 = table(data);
writetable(T1)

Best Answer

The table function prefers column vectors. I would save them as columns:

data1 = 1:1:10;
data2 = 10:10:100;
data =[data1(:), data2(:)];
T1 = table(data);

You can convert them back to row vectors later, if necessary, when you read the file. It is best to provide the path name as well as the file name to writetable. This way, you know where it is and what its name is. If you want to save it as an Excel file, be sure that you designate the '.xlsx' extension.

Related Solutions

MATLAB: How to put ‘(xlsread) variable’ in { }

Like this:

d = {data1, data2, data3};

If it's in a for loop, then do it like this

for k = 1 : 10
    filename = whatever......
    d{k} = xlsread(filename);
end

MATLAB: Downloading table data to a file in GUI

uitable() do not store table() objects.

The following code looks at the column names to create variables for the table objects. It does not assume that names are already present ('ColumnName' 'numbered' is valid). It does not assume that there are enough column names provided, and does not assume that any entries provided are valid unique variable names. If more headers are present than data columns then it extends the data columns.

Most of the work below is to ensure that valid headers of the right size are put in place. The actual work of creating the table and writing it is pretty short, so if you already know that your headers are valid and the right size then potentially you could make this code significantly shorter.

fullpathAndFilename = '/home/mytable.txt';
data = get(handles.uitable1, 'Data');
if ~iscell(data); data = num2cell(data); end
nc = size(data, 2);
%caution: orientation of ColumnName cell vector might not be what last set,
%MATLAB might have changed it
cn = get(handles.uitable1, 'ColumnName');
if isempty(cn) || ~iscell(cn)
  cn = cell(1, nc);
end
nch = length(cn);
if nc < nch
  data{end, nch} = [];  %and all intermediate items also get []

  nc = nch;
elseif nch < nc
  cn{nc} = [];    %and all intermediate items also get []
  nch = nc;
end
mask = cellfun(@isempty, cn);
cn(mask) = sprintfc('var%d', find(mask));   %fill empty column names
cn = matlab.lang.makeUniqueStrings( matlab.lang.makeValidName(cn, 'ReplacementStyle', 'hex') );
T = cell2table(data, 'VariableNames', cn);
writetable(T, fullpathAndFilename);

Best Answer

Related Solutions

MATLAB: How to put ‘(xlsread) variable’ in { }

MATLAB: Downloading table data to a file in GUI

Related Question