When I am trying to import .csv file to Signal builder, I am getting error.

I get following error:

File '*******_SignalBuilder.xlsx' format does not comply with Signal Builder required format. Worksheet '2' contains non-numeric values

P.S.: I have checked,all the cells of Worksheet '2' are containing numeric values.

What could be the reason?

Answer 1

[Bhuvnesh Singh]

Hi Aasif,

The Signal Builder export utility exports the data to the workspace in a format that does not support its import back into Signal Builder.

Create a structure which conforms to the Signal Builder import structure, which is similar to one of the following:

1) http://www.mathworks.com/help/releases/R2011b/toolbox/simulink/ug/bsu_jkc-1.html#bsu_jkc-5

var.time = [0 1 1 5 5 8 8 10];
var.signals.values = [0 0 2 2 2 3 3 3]';
var.signals.dimensions = 1;
var.signals.label = 'var';
save var.mat var

2) http://www.mathworks.com/help/releases/R2011b/toolbox/simulink/ug/f15-109640.html#bsla6bh

time = {channels(:).xData}';
data = {channels(:).yData}';
sigNames = {channels(:).label};
save test.mat time data sigNames

Here 'channels' is the structure that is saved to the workspace from the Signal Builder. Now test.mat can be used to import the data to a Signal Builder block.

Answer 2

[Sankarshan Durgaprasad]

This video will help!

Plotting 24-Hour Solar Irradiance on Simulink using Signal Builder and CSV File. MATLAB - YouTube