downloading table data to a file in GUI

I am trying to get the data from the table in GUI and I am getting the same error as mentioned above "Undefined function 'write' for input arguments of type 'double'."

My code goes here:

T = get(handles.uitable1, 'Data');

fullpathAndFilename = '/home/mytable.txt';

writetable(T, fullpathAndFilename);

The items in the table is shown below:

Please Help me. Thanks.

Answer 1

[Walter Roberson]

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);

[Vinayak Appasaheb Bhatte]

Thank you for the answer. It works pretty fine. I get the column names and the values of the table separated by commas.

What if I just need the numeric data(excluding column names) of the table separated by space instead of commas as shown below:

exclude the line numbers.

I tried to edit your code:

 fullpathAndFilename = '/home/mytable.txt';
data = get(handles.uitable1, 'Data');
if ~iscell(data); data = num2cell(data); end
T = cell2table(data);
writetable(T, fullpathAndFilename);

But I still get the default column name as data1,Ddta2 and the numeric values separated by commas.

[Walter Roberson]

writetable(T, fullpathAndFilename, 'Delimiter', 'space');

You are getting data1 and data2 as the column names because you are not supplying the variable names when you do the cell2table() call.

I suspect you could use

fullpathAndFilename = '/home/mytable.txt';
data = get(handles.uitable1, 'Data');
T = array2table(data, 'VariableNames', {'Depth', 'Speed'});
writetable(T, fullpathAndFilename, 'Delimiter', 'space');

[Vinayak Appasaheb Bhatte]

Yes this works absolutely fine.Thanks! But what I need is just the numbers (NO column names) starting from line 1 as show in the FIRST figure above(comments). Is it possible?

[Walter Roberson]

If you want a text file with no headers, then there is no point in using a table() object.

fullpathAndFilename = '/home/mytable.txt';
data = get(handles.uitable1, 'Data');
save(fullpathAndFilename, 'data', '-ascii')

[Vinayak Appasaheb Bhatte]

Thank you so much for your patience and answers. It worked finally the way I wanted it to be.