Is there a way in MATLAB coder to get a user to identify an Excel file, then read the contents of that Excel file?

Question

Joseph 2017-5-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/341630-is-there-a-way-in-matlab-coder-to-get-a-user-to-identify-an-excel-file-then-read-the-contents-of-th

回答： Walter Roberson 2017-5-23

I am trying to use MATLAB Coder to package a program that reads inputs from an excel file, does a calculation, plots results, and writes outputs to Excel. The problem I am running into is I can't use xlsread, xlswrite, or actxserver. The user also needs to identify which Excel file to read in and I can't use uigetfile either.

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2017-5-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/341630-is-there-a-way-in-matlab-coder-to-get-a-user-to-identify-an-excel-file-then-read-the-contents-of-th#answer_268149

You cannot use xlsread() or xlswrite() in MATLAB Coder.

You can place calls to third-party libraries that can read the kind of Excel worksheets that you need. .xlsx files are Open Standard so it is easier to get patent-free code if you only need to handle .xlsx and not .xls.

One of the available libraries is LibreOffice, which forked OpenOffice after Sun was purchased by Oracle.

"The user also needs to identify which Excel file to read in and I can't use uigetfile either."

fread() can be used directly, but not fscanf() or sscanf(). But you can use coder.ceval() to fscanf(); see https://www.mathworks.com/matlabcentral/answers/165502-stand-alone-c-file#answer_161338