当前位置：网站首页>MATLAB data writing file common functions

MATLAB data writing file common functions

2022-07-20 18:59:00 【A-Chin】

List of articles

1 xlswrite write in excel file
2 csvwrite write in csv file
3 dlmwrite write in ASCII file
4 writetable Write table to file

1 xlswrite write in excel file

grammar	describe
xlswrite(filename,A)	The matrix A write in Excel In the first table of the workbook .
xlswrite(filename,A,sheet)	Write to the specified table .
xlswrite(filename,A,xlRange)	Write to the first table in the workbook xlRange Specified rectangular area , Such as “A1:C3”.
xlswrite(filename,A,sheet,xlRange)	Write to the specified table in the workbook xlRange Specified rectangular area .
status = xlswrite(___)	Use any input parameter in the above syntax to return the status of the write operation . When the operation is successful , Status as 1. otherwise , Status as 0.
[status,message] = xlswrite(___)	Any warning or error messages generated by the write operation in the extra return structure message .

2 csvwrite write in csv file

grammar	describe
csvwrite(filename,M)	The matrix M Write comma separated values to the file .
csvwrite(filename,M,row,col)	Start with the specified row and column offsets , The matrix M write file .

csvwrite Up to... Can be written 5 Significant digits . If higher accuracy is required , You can use dlmwrite.
csvwrite Do not accept input cell Array . To export an array of cells containing only numeric data , Please call csvwrite Before using cell2mat take cell The array is converted into a numerical matrix .

3 dlmwrite write in ASCII file

grammar	describe
dlmwrite(filename,M)	Will array M Write the numerical data in ASCII Format file , Use the default separator (,) Separate array elements . If the file name file already exists , Then the file is overwritten .
dlmwrite(filename,M,’-append’)	Append data to the end of the existing file .
dlmwrite(___,Name,Value)	Use one or more names - Value specifies another separator for the parameter 、 A newline 、 Offset and precision options .
dlmwrite(filename,M,delimiter)	Will array M write file , Use the specified separator .
dlmwrite(filename,M,delimiter,row,col)	Rows and columns specified from the target file row and col Start writing array , Empty elements separated by delimiters fill leading rows and columns .

4 writetable Write table to file

grammar	describe
writetable(T)	Will table T Write to a comma separated text file . The file name is the workspace variable name of the table , Add extension .txt. T Each column of each variable in will become a column in the output file .T The variable name of becomes the column header in the first line of the file .
writetable(T,filename)	Write to the file with the specified name and extension . .txt、.dat or .csv text file . .xls、.xlsm or .xlsx file . .xlsb Spreadsheet files .
writetable(___,Name,Value)	Use one or more names 、 The additional option specified by the value on the parameter writes the table to the file , And it can include any input parameter in the above syntax .

原网站

版权声明
本文为[A-Chin]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/201/202207191631054055.html