Can Excel add-in read tables as inputs?

1 Ansicht (letzte 30 Tage)
Ji Li
Ji Li am 25 Sep. 2018
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?

Antworten (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by