XLExport It loads a delimited ASCII file from disk or memory stream and exports the cells to Excel
Download

XLExport Ranking & Summary

XLExport Tags

export stream delimited file ASCII ascii converter stream file export ASCII file stream create new delimited file Memory Stream ASCII to Excel exports

XLExport Description

This application was developed to be a small tool that loads and exports an ASCII disk file. It can be executed from within your application, or directly from the commandline. XLExport will take a TAB, PIPE (|), or SEMICOLON (;) delimited text file and export it to Microsoft Excel (Excel97 or better) if it's installed on the user's machine. All the cells are set as Text unless prepended with a tilde (~) so end-users would have to convert them back to numeric, if they want to do any calculations. It's annoying, but Excel will drop leading Zeroes on NIINs, Serial Numbers, etc., otherwise. Adding a tilde to the beginning of a field turns off the Text format, and Excel will format the cell in whatever way it thinks best (usually General format). Excel has a limit of 64K rows per sheet, and this exporter will create continuation sheets as needed. Just save the delimited data file to disk and execute XLExport. Usage: XLExport.exe The parameter is required and must contain the full path to the data file. If there is ANY chance the Path might contain spaces (C:\Program Files\SomeDirectory\temp.dat for instance), send a quoted string, i.e. "C:\Program Files\SomeDirectory\temp.dat") The parameter is optional. If left off or unrecognized, TAB is the default. Valid parameters are TAB, PIPE, and SEMICOLON (case doesn't matter). If the row in the data file does not end with a delimiter, one will be added, but it is better (faster) if it is supplied. Example: Column1;Column2;Column3; data;more data;even more data; Data;More Data;Even More Data; The first row of the data file is assumed to be the Column headers. It will appear in BOLD text, and be repeated on each worksheet. The first row of data also determines the initial width of the column in Excel.

XLExport Related Software