我需要完整的可直接执行的源代码。和Excel表格示例

好的，以下是一个可直接执行的源代码和 Excel 表格示例。

Code:

% 读取 Excel 文件
filename = 'DataBase.xlsx';
sheetnames = {'Signal', 'Parameter', 'Enum'};

% 读取 Signal 数据
[~,~,raw] = xlsread(filename, sheetnames{1});
Signal.Name = raw(2:end,1);
Signal.DataType = raw(2:end,2);
Signal.SampleTime = raw(2:end,3);
Signal.Description = raw(2:end,4);

% 读取 Parameter 数据
[~,~,raw] = xlsread(filename, sheetnames{2});
Parameter.Name = raw(2:end,1);
Parameter.DataType = raw(2:end,2);
Parameter.Value = raw(2:end,3);
Parameter.Description = raw(2:end,4);

% 读取 Enum 数据
EnumSheetNames = raw(:,1);
EnumSheetNames(cellfun(@isempty,EnumSheetNames)) = [];
EnumSheetNames(1) = []; % 去掉 Signal、Parameter 表格的名称
EnumSheetNames(1) = [];
for i = 1:length(EnumSheetNames)
    [~,~,raw] = xlsread(filename, EnumSheetNames{i});
    Enum(i).Name = EnumSheetNames{i};
    Enum(i).Members = strsplit(raw{2},',');
end

% 生成 .m 文件
mfilename = 'MyDataDictionary.m';
fid = fopen(mfilename,'w');

% 生成 Signal 代码
fprintf(fid,'%% Signal\n');
for i = 1:length(Signal.Name)
    fprintf(fid,'Simulink.Signal {\n');
    fprintf(fid,'    Name: ''%s'';\n', Signal.Name{i});
    fprintf(fid,'    DataType: ''%s'';\n', Signal.DataType{i});
    fprintf(fid,'    SampleTime: %s;\n', Signal.SampleTime{i});
    fprintf(fid,'    Description: ''%s'';\n', Signal.Description{i});
    fprintf(fid,'}\n\n');
end

% 生成 Parameter 代码
fprintf(fid,'%% Parameter\n');
for i = 1:length(Parameter.Name)
    fprintf(fid,'Simulink.Parameter {\n');
    fprintf(fid,'    Name: ''%s'';\n', Parameter.Name{i});
    fprintf(fid,'    DataType: ''%s'';\n', Parameter.DataType{i});
    fprintf(fid,'    Value: %s;\n', Parameter.Value{i});
    fprintf(fid,'    Description: ''%s'';\n', Parameter.Description{i});
    fprintf(fid,'}\n\n');
end

% 生成 Enum 代码
fprintf(fid,'%% Enum\n');
for i = 1:length(Enum)
    fprintf(fid,'Simulink.EnumType {\n');
    fprintf(fid,'    Name: ''%s'';\n', Enum(i).Name);
    fprintf(fid,'    Members: {');
    for j = 1:length(Enum(i).Members)
        fprintf(fid,'''%s''', Enum(i).Members{j});
        if j < length(Enum(i).Members)
            fprintf(fid,', ');
        else
            fprintf(fid,'};\n');
        end
    end
    fprintf(fid,'}\n\n');
end

fclose(fid);

% 导入 Simulink 数据字典
if exist('MyDataDictionary.sldd','file')
    delete('MyDataDictionary.sldd');
end
datadictionary('MyDataDictionary.sldd');

Excel 表格示例：

| | A | B | C | D |
|-|---|---|---|---|
| 1 | 注释 | 注释 | 注释 | 注释 |
| 2 | Signal1 | double | 1 | This is signal 1 |
| 3 | Signal2 | int8 | 2 | This is signal 2 |
| 4 | Signal3 | single | 3 | This is signal 3 |
| 5 | Signal4 | int32 | 4 | This is signal 4 |
| 6 | Signal5 | int16 | 5 | This is signal 5 |
| 7 | Signal6 | uint8 | 6 | This is signal 6 |
| 8 | Signal7 | uint16 | 7 | This is signal 7 |
| 9 | Signal8 | uint32 | 8 | This is signal 8 |
| 10 | Signal9 | boolean | 9 | This is signal 9 |
| 11 | Signal10 | single | 1 | This is signal 10 |
| | | | | |
| 1 | 注释 | 注释 | 注释 | 注释 |
| 2 | Parameter1 | double | 3.14 | This is parameter 1 |
| 3 | Parameter2 | int8 | -10 | This is parameter 2 |
| 4 | Parameter3 | single | 2.718 | This is parameter 3 |
| 5 | Parameter4 | int32 | 100 | This is parameter 4 |
| 6 | Parameter5 | int16 | 12345 | This is parameter 5 |
| 7 | Parameter6 | uint8 | 255 | This is parameter 6 |
| 8 | Parameter7 | uint16 | 65535 | This is parameter 7 |
| 9 | Parameter8 | uint32 | 4294967295 | This is parameter 8 |
| 10 | Parameter9 | boolean | true | This is parameter 9 |
| 11 | Parameter10 | single | 3.1415 | This is parameter 10 |
| | | | | |
| 1 | Enum1 | | | |
| 2 | VALUE1, VALUE2, VALUE3 | | | |
| 3 | Enum2 | | | |
| 4 | VALUE4, VALUE5, VALUE6 | | | |
| 5 | Enum3 | | | |
| 6 | VALUE7, VALUE8, VALUE9 | | | |
| 7 | Enum4 | | | |
| 8 | VALUE10, VALUE11, VALUE12 | | | |
| 9 | Enum5 | | | |
| 10 | VALUE13, VALUE14, VALUE15 | | | |
| 11 | Enum6 | | | |
| 12 | VALUE16, VALUE17, VALUE18 | | | |
| 13 | Enum7 | | | |
| 14 | VALUE19, VALUE20, VALUE21 | | | |
| 15 | Enum8 | | | |
| 16 | VALUE22, VALUE23, VALUE24 | | | |
| 17 | Enum9 | | | |
| 18 | VALUE25, VALUE26, VALUE27 | | | |
| 19 | Enum10 | | | |
| 20 | VALUE28, VALUE29, VALUE30 | | | |

请注意，Excel 表格中 Signal、Parameter、Enum 表格的第一行是注释，有效数据从第二行开始。在 Enum 表格中，每个枚举的枚举成员必须全部在一个单元格内使用半角逗号隔开。

希望这个代码和 Excel 表格示例对你有所帮助。