MATLAB Answers

Save Parameter values in workspace from Export Target in excel file

1 view (last 30 days)
joms
joms on 28 Aug 2019
Edited: joms on 28 Aug 2019
In excel file, cell G374 contains the parameter name which has a string value of 'Parameter1'.
Value is linked to another cell B374 which has a formula value of "=SetExportTarget(ExportFlag,G374,J374:O375)" .
I want to import contents of excel under J374:O375 as array with G374 string value (Parameter1) as Array name. Excel file has many export flag and sheets with similar kind of formula and i want to import them all in workspace.
Desired Output
Parameter1=[ 0 1 2 3 4 5;2 4 6 8 10 12 ]

Answers (0)

Community Treasure Hunt

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

Start Hunting!

Translated by