How To Write An Array To Excel Matlab

Hi All

ane. With Micrsoft Excel

You can consign data of a graph in the PSCAD to Micrsoft Excel as beneath. Righ cliclk on the garph and select "Re-create Data to Clipboard". Then you can see iii options.
i.due east. All, Visible area and Between Markers. If you select "All", all the data in the graph (for the complete simulation run) is copied to clipboard. If y'all select "Visible Area" or "Betwixt Markers", just the information points in the visible surface area or between markers is copied to the clipboard.

Then go to the Excel, and Select "Paste Special". In the "Paste Special" dialog box, yous have 3 options as "Unicode Text", "Text" and "Csv". Please select "Csv" and click "OK". Now yous tin can see that your information is visible every bit a table with the headings that you gave to your output channels.
Kickoff column is the time range.
At present y'all can do the analysis in Excel.

ii. With MATLAB

If you want to use MATLAB instead of Microsoft Excel, then yous accept to follow the below procedure.
Offset select the data equally same equally under one. Then open the MATLAB editor file and type the variable proper noun for the information. Say Volt. Then paste the data as beneath and use save command as in the line ii. Save the MATLAB file every bit the same proper name that you have given under the "Relieve" command.

Volt = [ "Paste the information here"]
salve Voltage_data %Voltage_data is the name of the grand file

Now you have a MATLAB m file with all the data that you copied to the clipboard. Again the first cavalcade in this variable is the fourth dimension. Yous can use these data to do plotting and other analysis same as you are normally doing.

George Wai,

Software Support & Evolution Specialist

Manitoba HVDC Research Centre

a segmentation of Manitoba Hydro International Ltd.

211 Commerce Drive | Winnipeg, Manitoba, Canada R3P 1A3

T +ane 204 989 1241 | F+ ane 204 989 1277

support@pscad.com | www.hvdc.ca | www.pscad.com