Remote data transfer to excel

I would like to transfer data from one computer to another and write it in Excel. The computers are connected through a network. Computer 1 will be running Matlab and computer 2 will be running Excel. It is desired that computer 2 will not be running Matlab. Is it possible to do this?

Answer 1

[Rahul]

Hi @Emil,

I understand that you wish to transfer data from MATLAB to Excel on different desktops.

You can make use of functions like 'writetable' or 'xlswrite' to write the data avilable in MATLAB to Excel formats like '.XLS' or '.XLSX'. Here is an example:

% Considering 'Table' to be the variable containing table data.
writetable(Table, 'Table.xlsx')

You can also refer to the following MATLAB Answer:

https://www.mathworks.com/matlabcentral/answers/77807-how-to-export-data-from-matlab-to-excel

These files can be opened in Excel on the other desktop by transferring them over your local network or you can also make use of the MATLAB Drive which offers cloud services to manage your files across devices.

https://www.mathworks.com/products/matlab-drive.html

If required to read the Excel file in MATLAB, you can make use of the functions like 'readtable' or 'xlsread'. Here is an example:

Table = readtable("Table.xlsx")

You can refer to the following MathWorks documentations to know more about these functions:

'Write Data To Excel Spreadsheets': https://www.mathworks.com/help/releases/R2022a/matlab/import_export/exporting-to-excel-spreadsheets.html

'readtable': https://www.mathworks.com/help/releases/R2022a/matlab/ref/readtable.html

'xlsread': https://www.mathworks.com/help/releases/R2022a/matlab/ref/xlsread.html

Hope this helps! Thanks.