Transfer formula and images from Excel to Matlab
9 views (last 30 days)
Show older comments
Hello everybody,
I have a folder full of images, which I have linked to an Excel file. The file consists of four columns and a sort by name of the images. I then ran the individual columns with a random generator, i.e. it gives a name for each column, which should represent the image.
Now I want to import the whole thing to Matlab, but I can't display the formulas and the linked images with "xlsread". It only shows me the names in the workspace, and not in order.
Does anyone have any idea what I could use to take the formulas with me to Matlab? So that I can use RUN to display the random image in Matlab?
Best regards
0 Comments
Answers (1)
dpb
on 5 Jul 2019
You'd have to use COM to drive Excel to read formulae from cells or, alternatively, for a couple cases where needed to get such data an expedient is to create a column in the workbook that references the formula of interest that you can read as text.
Not sure what you're intent after that is, though, ML can't interpret Excel syntax.
I'd just read the filename array and permute it and call the file in a loop...there's no real need for Excel here it would seem...in fact, it seems as though you could just use dir() on the files in the folder and work on it directly far more simply than some mishmash between ML and Excel.
0 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!