Help regarding exporting the data to excel file

Forum|Forum|10 years ago
May 31, 2016
7 replies
3723 views

Hello,

Can someone please help me with an issue, in the attached file, i would like to write the complete range of data outputs Re(Zpq(f)) and Im(Zpq(f) to an excel file, in column A and B. How can i achieve it?

Thank you

1_f-mcdx.zip

Statistics_Analysis

Best answer by LucMeekes

Look up the help info on excel component, starting with "To Insert an Excel Component" and follow the steps. Make sure your installation complies with the requirements.

Unfortunately I cannot help you step by step, because I'm limited to Prime Express.

Presently your list of complex values is a range, rather than a vector.

You may need to convert that to a vector by doing, e.g.

See also the attchment.

Success!
Luc

L

LucMeekes

Answer

23-Emerald IV

Look up the help info on excel component, starting with "To Insert an Excel Component" and follow the steps. Make sure your installation complies with the requirements.

Unfortunately I cannot help you step by step, because I'm limited to Prime Express.

Presently your list of complex values is a range, rather than a vector.

You may need to convert that to a vector by doing, e.g.

See also the attchment.

Success!
Luc

1_f-(2)-mcdx.zip

S

ssam-2

Author

1-Visitor

Thank you very much. I was able to acheive the task.

F

Fred_Kohlhepp

23-Emerald I

If it works like Prime 3.0, Then

From the Input/output Ribbon, Insert an EXCEL component. The component has three regions, input (at the top), a window into the spreadsheet, and an output below. Put your cursor in the input section and "insert input expression" (from the ribbon again.) Define what you want and where in the sheet it should go.
Double-click on the sheet display, the entire sheet will open in EXCEL with your values displayed.
Save your sheet from EXCEL with the name/location of your choice.