Rob van der Woude's Scripting Pages

Help text for Excel2Any.cs

(view help text of Excel2Any.cs as plain text)

Excel2Any,  Version 1.00
Open a spreadsheet in Microsoft Excel and save it in "any" (known) format

Usage:     EXCEL2ANY    "workbook"  [ "outfile" ]  [ options ]

Where:     "workbook"  Excel document(s) to be converted (wildcard "*" allowed
                       in file name, e.g. "name*.xlsx")
           "outfile"   output file(s) to be created (wildcard "*" allowed for
                       file name, e.g. "*.ods" or "*.pdf")
Options:   /O          silently Overwrite existing output file(s)
                       (default: abort or skip if output file exists)
           /T          list available output file Types
           /T:type     set output file Type (required if "outfile" is not
                       specified; type may be number or string)

Notes: [1] This program requires a "regular" (MSI based) Microsoft Excel
           (2007 or later) installation, it will fail on an MS Office
           "click-to-run" installation
       [2] For Excel 2007, to save as PDF or XPS, this program requires the
           "Microsoft Save as PDF or XPS Add-in for 2007 Microsoft Office
           programs", available at:
           http://www.microsoft.com/en-us/download/details.aspx?id=7
       [3] If wildcards are used in the Excel file names, and the output file
           path is not specified, /T:type must be used, and the input file
           names should not contain dots.
       [4] If wildcards are used in the Excel file names, and the output file
           path is specified, the output file name must be "*".
       [5] If wildcards are used in the Excel file names, and the /O switch
           is not used, the program will display an error message in case an
           output file already exists, but it will then continue to convert
           the next file instead of aborting.
       [6] If Excel was already active when this program is started, any
           other opened spreadsheet(s) will be left alone, and only the
           spreadsheet(s) opened by this program will be closed.

Examples:  EXCEL2ANY "D:\folder\myfile.xls" *.pdf
           will save to "D:\folder\myfile.pdf"

           EXCEL2ANY "D:\folder\myfile.xlsx" "D:\otherfolder\*.ods"
           will save to "D:\otherfolder\myfile.ods"

           EXCEL2ANY "D:\folder\myfile.xlsx" "D:\elsewhere\newfile.xps"
           will save to "D:\elsewhere\newfile.xps"

           EXCEL2ANY "D:\folder\name*.xlsx" *.html
           will save all matching files as HTML to "D:\folder\"
           recognized extensions: csv, htm(l), ods, pdf, txt, xls(x), xlsm, xps

           EXCEL2ANY "D:\folder\*.xlsx" /T:8
           like previous example, but more file types available

           EXCEL2ANY /T
           will list all available file types

Written by Rob van der Woude
http://www.robvanderwoude.com

page last uploaded: 2017-03-25, 21:31