MATLAB: Changing data copy mode

coloncommadatadotexcelimportMATLAB

Right now I´m importing data to Matlab using the command importdata(-pastespecial) which allowed me to copy columns from excel to arrays in Matlab. However when I try it in another computer instead of transforming it to arrays, Matlab creates a structure out of it…. The data in excel is separated with commas (as given by the machine in the lab). Is there a way to change how Matlab copies it?. In the other computer it was doing it perfectly.

Best Answer

Nevermind, it was actually the new computer changing the notation on the excel file... friking microsoft. Long life Matlab :D

Related Solutions

MATLAB: Copying data

X = randn(2,2,2000);
Y = X(:,:,1:1000);

Y copies the first 1000 elements of X along the 3rd dimension.

MATLAB: Spreadsheet import tool in 2011b

I raised this issue directly with Mathworks support. Here is the reply I received:

The ability to read XLSX files is not available on the Mac OS. On the Mac OS, MATLAB does support a 'BASIC' mode that works with XLS files that are saved in the "Excel 97-2003" format. Since the connection to Excel is based on the Microsoft specific COM technology, all functionalilites of Excel are not available on the Mac OS.

In order to work around this issue, please use the following steps: [1] Copy the data into a new Excel Workbook and saved it as a 'Excel 97-2003' with a '.xls' file extension (I named this file 'test.xls'). [2] Using XLSREAD on Mac OS, read the data from the XLS file mentioned in step 1.

Alternatively, you could save the data as a Comma Separated Values (CSV) file and read it using CSVREAD. Please note that CSVREAD works only for numeric values. For more documentation on CSVREAD, please use the following command at the MATLAB command line.

Best Answer

Related Solutions

MATLAB: Copying data

MATLAB: Spreadsheet import tool in 2011b

Related Question