Help regarding exporting the data to excel file

[ssam-2]

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

[LucMeekes · Accepted solution]

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

[ssam-2]

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

[Fred_Kohlhepp]

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.

[ssam-2]

Thank you very much for the guideline.

[VladimirN]

Next video tutorial "Using the Excel Component" will be useful for you: Tutorial: Using the Excel Component

[ssam-2]

Thank you for the link, it was really helpful.

[VladimirN]

You're welcome.