dat2xls

バージョン 1.0.0.0 (3.95 KB) 作成者: Fahad Al Mahmood
Copying (ASCII) data file (including headers & column names) to XLS.

ダウンロード 4.4K 件

更新 2004/10/13

ライセンスの表示

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 (2022). dat2xls (https://www.mathworks.com/matlabcentral/fileexchange/4517-dat2xls), MATLAB Central File Exchange. 取得済み .

MATLAB リリースの互換性
作成: R14
すべてのリリースと互換性あり
プラットフォームの互換性
Windows macOS Linux
謝辞

ヒントを得たファイル: xlswrite - legacy

ヒントを与えたファイル: Example of how to save or read data to an Excel archive.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!