Save Parameter values in workspace from Export Target in excel file

조회 수: 2 (최근 30일)
joms
joms 2019년 8월 28일
편집: joms 2019년 8월 28일
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개)

카테고리

Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기

태그

제품


릴리스

R2013b

Community Treasure Hunt

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

Start Hunting!

Translated by