MATLAB: Does “readtable” fail to read a file from OneDrive

existsfileMATLABonedriveopenreadtabletounable

Best Answer

The issue is likely to be with OneDrive locking the file for editing purposes, although our development team is aware of the issue and investigating.

For now, the workaround is to close the application which uses the file in OneDrive, and then use MATLAB to load the file. Alternatively, the file can be moved or copied to a local directory, ensuring OneDrive does not lock it.

Related Solutions

MATLAB: How to take input as excel file from user in matlab?

[filename, pathname] = uigetfile({'*.xls', '*.xlsx'}, 'Pick an excel file');
fullname = fullfile(pathname, filename);
[num, txt, raw] = xlsread(fullname);

MATLAB: Does the datatype automatically change to categorical while importing a spreadsheet

In the Import Tool, a column of data is interpreted as categorical if it:

is detected as text by the detectImportOptions function, and
the uniqueness of the text in that column is below a threshold, in which case, using a categorical value may be a better option for the user.

If the spreadsheet contains dashes or any such characters in cells as a placeholder for empty cell, it causes the data type detection to treat the column as text. You can observe this at the command line by executing the following commands to the attached spreadsheet "Book1.xlsx":

>> opts = detectImportOptions("Book1.xlsx");

>> opts.VariableTypes

ans =

1×10 cell array

{'char'} {'char'} {'char'} {'char'} {'char'} {'char'} {'char'} {'char'} {'char'} {'char'}

A workaround for this is to force these columns to be numeric. For example:

>> opts = detectImportOptions("Book1.xlsx");

>> opts = setvartype(opts, "double");

>> t = readtable("Book1.xlsx", opts);

Best Answer

Related Solutions

MATLAB: How to take input as excel file from user in matlab?

MATLAB: Does the datatype automatically change to categorical while importing a spreadsheet

Related Question