将 Excel 数据导出到 Matlab 的最简单方法是什么?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/198568/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-13 16:40:06  来源:igfitidea点击:

What is the simplest way to export Excel data to Matlab?

excelmatlabexport

提问by Degvik

What is the simplest way to programmatically export Excel data to Matlab?

以编程方式将 Excel 数据导出到 Matlab 的最简单方法是什么?

采纳答案by Jouni K. Sepp?nen

If you are running Matlab on Windows with Excel installed, try XLSREAD.

如果您在安装了 Excel 的 Windows 上运行 Matlab,请尝试XLSREAD

回答by Scottie T

If there's not much text annotation in the Excel file, save it as a csv, then use the MATLAB function csvread.

如果 Excel 文件中文本注释不多,则将其另存为 csv,然后使用 MATLAB 函数 csvread。

回答by Scottie T

In more recent Matlab releases there are also csvread()and writetable()that work with csv which can easily be opened in Excel.

在最近发布Matlab的也有csvread(),并writetable()以CSV的工作,可以很容易地在Excel中打开。

回答by Scottie T

For a bit of $$$, you can get the MATLAB add-on Excel Link, which provides a nice clean interface for transferring data back and forth between the two programs.

花一点钱,您可以获得 MATLAB 附加组件 Excel Link,它提供了一个漂亮干净的界面,用于在两个程序之间来回传输数据。

回答by bastibe

As has been said, XLSREAD is the right function for the job. On a non-Windows system it will also work without Excel installed. However, it supposedly lacks some of Excels advanced features.

如前所述,XLSREAD 是这项工作的正确功能。在非 Windows 系统上,它也可以在不安装 Excel 的情况下工作。但是,据说它缺少一些 Excels 高级功能。