ExcelExport v1.0.0.0 - Latest build 2006-may-12 ExcelExport is a command-line utility which will export individual worksheets from a .XLS file into individual .CSV files. All cells are wrapped in double-quotes and separated by commas. Double-quotes within cells are repeated. Example: "cell","a4","has","embedded ""quote"" marks","see?" This program is provided by Nebula Research and Development as binary freeware. It is not open source and no guarantees are made regarding fitness or quality. Please report any issues to freeware@Nebula-RnD.com and we might fix them as time permits. Support is not officially provided. Support and Enhancements will be made on a contract basis only and as time permits. An estimate for specific changes will be provided and counter-offers will be considered. This program was written in C# with .NET v2.0 and requires .NET 2.0 and Excel 2003 to be installed on the user's system. To execute: excelexport from-file.xls to-file-prefix The from-file.xls must be quoted if it contains spaces. The to-file-prefix is applied to all sheets within the workbook. Example: excelexport "c:\my docs\this.xls" "c:\another path\new_" If the workbook has 3 spreadsheets the results will be: c:\another path\new_Sheet1.csv c:\another path\new_Sheet2.csv c:\another path\new_Sheet3.csv If no path is specified in the to-file-prefix, results will be placed in the current directory, not the from-file directory. If a worksheet within a workbook is empty it will be skipped. Possible enhancements that will be considered: - Optionally change delimiter and quoting characters. - Export as XML using Row 1 for tags. - Export data to remote MV environment. - Allow process to be called from remote MV environment, even *nix. - Process data conditionally. - Process multiple documents based on a file pattern: june*.xls - Consolidating multiple documents or worksheets - Enabling the code as a callable web service - Allow the from-file to be a URL or FTP location. - Feel free to make other suggestions... Possible bugs: - Does not distinguish between a data worksheet and a chart and may return an error. (Not tested) If you like this software, please send a note to freeware@nebula-rnd.com. If changes are made to the software you will receive a note. You will not be contacted for any other reason and your contact address will not be used for any other purpose.