MATLAB: Precision in writetable()

MATLABwritetable

Is there a way to use writetable() to export using only 2 decimals? To be able to directly export it to an excel file.

Best Answer

Sadly, no. A OutputFormat formatting string or NumericPrecision option is not available.

I presume since a table can contain any data type including cells too many possibilities are opened up that TMW hasn't wanted to venture down that road.

Does seem like worthy of some design consideration for the normal cases, though, granted...

For text files, the numeric format is long g.

Related Solutions

MATLAB: How to import numerical entries from an excel sheet as strings

opt=detectImportOptions('testmatlabpartnumberreadin.xlsx');  % see what Matlab thinks
opt.DataRange='A1';                                          % start data w/ no header
opt.VariableNamesRange='';                                   % no variable names to read
opt.VariableNames={'ID'};                                    % set a useful name
opt=setvartype(opt,'ID','categorical');                      % make it a categorical variable type
dat=readtable('testmatlabpartnumberreadin.xlsx',opt);        % and read the spreadsheet to table

Show what we got...

>> dat
dat =
  11×1 table
       ID    
    _________
    3.624.256
    3.624.257
    3.624.258
    3.624.259
    3.624.260
    3.624.261
    3.624.262
    3.624.263
    3.624.264
    3.624.265
    3.624.266
>>

Treating the ID/Part Number as categorical variable retains all text but is much easier for lookup or other operations than string-matching. It's exactly what they're there for... :)

And, the table is almost certainly going to be a much easier storage format for whatever your needs are than general cell array of combinations of various types of variables.

MATLAB: Exporting strings to Excel using writetable

In R2018a for Mac, it is not possible to write xlswrite() that to .xls or .xlsx because doing so requires ActiveX which is not supported except on Windows. For Mac and Linux, xlswrite() would try to write as .csv but that fails because of the non-numeric values.

In R2018a for Mac, writetable() to either .xls or .xlsx uses internal routines to do the writing, since ActiveX is not supported. For both .xls and .xlsx the result is something that has the leading quote show up in the normal display in MS Word, and when you click on the individual cell, the fx that shows up only has the single leading quote.

I do confirm that the .xls you provided shows up in MS Word (for Mac) with a single leading quote on the display, but when you click on the individual cell, the fx that shows up has two leading quotes.

So... this has something to do with the ActiveX interface to Excel.

Best Answer

Related Solutions

MATLAB: How to import numerical entries from an excel sheet as strings

MATLAB: Exporting strings to Excel using writetable

Related Question