how to write a struct to a .xls or txt file

station = struct(...
      'name', {'CD2',  'GYA',   'GOM',  'XAN', 'LZH','KMI',  'LSA','MDJ','WMQ','CNS',  'GUL',   'GZH',   'HEF',  'QZH',   'WHN','WZH'},...
      'Jingdu',{103.76 ,106.66,103.84,94.81,108.92,102.74,91.10,129.59,87.69,112.59,110.12,113.65,117.17,118.60,114.35,120.40},...
      'Weidu',{30.91,  26.46,  36.09, 36.20, 34.03,25.12,29.73,44.62,43.65,28.12,25.12,23.65,31.52,24.94,30.54,27.55});

1.how can i save it into a xls file , and then load it from the xls file?

Answer 1

[Image Analyst]

Use struct2table() and writetable():

t = struct2table(station)
writetable(t, 'station.xlsx');

[Image Analyst]

Wait...what do you mean "from" xls or txt ? Once you have it in your structure, who cares where it came from . What matters is what format you want to write it to. What is that ?

[Roger]

i mean that i can change the data from station.xlsx file ,then i load sation.xlsx ,the structure is also changed

[Image Analyst]

Roger, I don't understand. Just how are you reading in "sation.xlsx"? If you use xlsread() you get a cell array or double array , and if you use readtable() you get a table . Just how are you reading it in and getting a structure ? Regardless, so you read it in -- if it had some prior values, then they're changed when you read in this workbook. And after that, if you want to change the structure fields again, what's to prevent you from changing the value of the fields you want to other values? Just go ahead and do it.

[Roger]

in my code , i need a struct type variable,so i creat a xls file which saves datas i need,but creat a structure in my code , when i need to use it , i just load it ; sometimes data saved in xls file should be changed ,like appending some data, i just changed the xls file . I just want somebody can change data for his needs from xls file and not need to read my code ,or change from code.

[Image Analyst]

OK, so you read it in with some unspecified function (probably xlsread) and then you convert the array or cell array into a structure for convenience elsewhere in your program. OK fine. If you then change that structure and want to save it back out in the original form back to your Excel workbook file, you're going to have to either change your original cell array that you read in, or else use struct2table. Then you're going to have to write back that changed variable to the workbook file with xlswrite() or writetable().