Azzera filtri
Azzera filtri

Can Excel add-in read tables as inputs?

2 visualizzazioni (ultimi 30 giorni)
Ji Li
Ji Li il 25 Set 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?

Risposte (0)

Categorie

Scopri di più su Data Import from MATLAB in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by