Can Excel add-in read tables as inputs?
2 ビュー (過去 30 日間)
古いコメントを表示
I would like to use Matlab compiler to convert a function into Excel add-in. My function inputs contain several tables with both strings and numeric values. Before I considered Excel add-in, I read these tables in Matlab using 'readtable' function and also defined the first column as row names. It works well for later use. However, if I consider using Excel add-in, I have to remove all these codes. When I call the function in Excel, I just import inputs by highlighting certain ranges in Excel. My question is, without those definitions, how will Excel import the highlighted range (if my range is a table defined in Excel) into Matlab? Will it import the table as a Matlab table, recognizing its column headers? Or will it import the range as cell arrays? Or it just couldn't recognize the text fields, but import the range as a simple array?
0 件のコメント
回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Data Import from MATLAB についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!