How can I generate signal from microsoft excell dataset at Simulink ?

Hello everyone I have a problem about Simulink.Now I have Real Power Profile data.(time-dependent power chart) .This is in the excell file. I want to use this data as a signal at Simulink.So,I want to generate a signal from this data. How can I do it ? I need help. Thank you.

Answer 1

[Fangjun Jiang]

A few options depending on your situation:

1. Get the Simulink Tester toolbox. It can work with Excel spreadsheet directly.

2. Pre-process your Excel file. Write a script to import your Excel data into MATLAB workspace or save it to a .mat file. The primary function is xlsread().

3. If it is one-time, you can run uiimport to import the Excel data into MATLAB workspace.

4. You can record your interaction using uiimport in a script. This can help you develop the script.

[BERK GÖKMEN]

Hi thank you.I used from spreadsheet block. The time values must monotonically increase for this block.But my time values not incerase monotonically.How can i solve this problem ?

[Fangjun Jiang]

I would say you need to sort your Excel data first.

[BERK GÖKMEN]

I have this error '' First column for the specified range in sheet 'Real_Power' is treated as a time column and must increase monotonically.''

[Fangjun Jiang]

Yes. So sort your Excel file and make sure the data in first column (as time) is increasing monotonically.

[BERK GÖKMEN]

Thank you very much.

[Ill ch]

Dear Fangjun Jiang,

I have similar problem. Could you help me how i can set run time for simulation when i used spreadsheet block. My signal is not looking as its look in matlab .

Could you please help me? here are my data

[Fangjun Jiang]

Follow the dialog or look at the help of the "From Spreadsheet" block. It should be straightforward.

[Ill ch]

thnk you