Remote data transfer to excel

Question

Emil 2022-6-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1741175-remote-data-transfer-to-excel

回答： Rahul 2024-10-16

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?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Rahul 2024-10-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1741175-remote-data-transfer-to-excel#answer_1532640

在 MATLAB Online 中打开

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.