This program reads a (text data file) consisting of headers, column titles and column data (see attached data.txt). Then it opens or creates existing excel file and saves data into specified sheetname.
NOTE: The program will automatically identify the number of headerlines, columns and the column names using what so called "common sense"!
dat2xls(datfile,xlsfile,sheetname)
dat2xls(datfile,xlsfile)
datfile: Name of data file.
xlsfile: Name of excel file.
sheetname: sheet name (optional, default is 'Sheet1') if specified, a sheet with the specified name must be existing.
Example:
datfile = 'data.txt';
xlsfile = 'data.xls';
sheetname = 'Sheet2';
dat2xls(datfile,xlsfile,sheetname)
%dat2xls(datfile,xlsfile) % Will write to 'Sheet1'
引用格式
Fahad Al Mahmood (2026). dat2xls (https://ww2.mathworks.cn/matlabcentral/fileexchange/4517-dat2xls), MATLAB Central File Exchange. 检索时间: .
| 版本 | 已发布 | 发行说明 | Action |
|---|---|---|---|
| 1.0.0.0 | Attached (data.txt) |
