dat2xls

Copying (ASCII) data file (including headers & column names) to XLS.

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'