Save Parameter values in workspace from Export Target in excel file
2 ビュー (過去 30 日間)
古いコメントを表示
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 ]
0 件のコメント
回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!