 |
'Convert XLS' Revision History
(MS Excel
Conversion and Sheet Manipulation Utility)
|
Have a suggestion for an improvement?
日本語
RECENT HIGHLIGHTS
-
Vista Compatibility
enhancements. Program may now run
faster on Vista.
See Versions (3.67, 3.80)
-
Conversion to/from Fixed
Width Text Files: A fixed width profile
editor and manager has has been added. Easily create, edit, and view
multiple profiles. (3.890)
3.895 to 3.896 (7/25/2008)
3.894 to 3.895 (6/12/2008)
-
Use of "?" and "*"
within Original and Target (input and output) file specification
has now been greatly enhanced. Before only *.ext was allowed.
Now you may specify any combination such as
c:\myfiles\apple*.TXT or c:\myfiles\ap???*.TXT for
example.
-
Conversion: "_)"
would appear when converting from XLS to TXT or CSV.
3.893 to 3.894 (6/9/2008)
3.892 to 3.893 (5/12/2008)
3.891 to 3.892 (5/12/2008)
3.890 to 3.891 (4/17/2008)
-
Conversion of Fixed
Width Text Files: TXT to XLS, the profile was not being used.
-
Conversion of XLS to
TXT, or CSV, the retention of the line feed character <LF> ASCII
10 is now allowed.
3.882 to 3.890 (3/20/2008)
3.88 to 3.882 (3/9/2008)
3.87 to 3.88 (3/5/2008)
3.86 to 3.87 (2/28/2008)
-
Conversion:
Conversion to PDF and XPS now supported for any file MS Excel
can open. To be able to convert to PDF or XPS, you will have to
install a licensed version of MS Office 2007 (or greater) and
the “Microsoft Save as PDF or XPS” add in. Go to Microsoft’s web
site and search for “Microsoft Save as PDF or XPS Add in”.
3.853 to 3.86 (2/6/2008)
-
Special Process 109
Search and Replace Cell Contents: A specific range may now be
specified, such as A:A for column A only.
-
Scheduler: Greek
regional settings caused an issue.
3.84 to 3.853 (2/1/2008)
-
Special Process:
Adding while 'Save to original folder' was selected would place
an incorrect file extension on the target file.
-
Conversion XML: When
using the 'Convert XLS' conversion method, you can now
optionally specify the ROOT and ROW node by clicking on the
Options button.
3.83 to 3.84 (12/29/2007)
-
Conversion: XLSM (51)
Excel Macro-Enabled Workbook file type added to the 'Convert
XLS' conversion method
-
Numerous Excel 2007
file types added to the Target File Type list.
-
Help file enhanced.
Numerous command line examples are given for Office 2007 file
types.
3.82 to 3.83 (11/20/2007)
3.81 to 3.82 (11/20/2007)
-
Conversion: 'Convert
XLS' conversion method. Convert XLSX, sometimes it would
not recognize the sheet specified, even all sheets specified.
-
Conversion: 'Convert
XLS' conversion method. When going from a VERY large XLSX to
XML, CSV etc it would take a VERY long time.
-
Conversion: 'Convert
XLS' conversion method. Some XLS files were not being converted.
-
XLSX, XLSM, XLSB file
types added to file selection when appropriate
3.80 to 3.81 (11/11/2007)
3.78 to 3.80 (10/28/2007)
-
Conversion: XLSX
(Office 2007 XML Document format) now supported!
-
Scheduler: When using international operating
system, then restarting program sometimes caused an issue due to
international dates.
3.77 to 3.78 (10/9/2007)
3.76 to 3.77 (9/28/2007)
3.75 to 3.76 (9/4/2007)
-
Conversion CSV to
XLS. A new ini file parameter has been added to adapt for huge
csv files. Within the "C:\WINDOWS\CX_SearchHistory.INI"
file see the [frmMain] section, and add
MaxRowsInOneFileSet=40000. When you have a massive CSV
file, a proper valid XLS file is not always possible since Excel
has a limitation of 65535 rows. Even if you don't have
that many rows, if you have a large number of columns and rows
combined, Excel may have limitations, or our tool may not be
able to handle it. Therefore, this newly added ini
paramter can resolve this issue by creating several XLS files
from a single csv file. The number of rows it uses per
file is determined by MaxRowsInOneFileSet.
3.74 to 3.75 (8/23/2007)
3.73 to 3.74 (8/14/2007)
3.72 to 3.73 (7/19/2007)
-
Converting from xls to a fixed width text file: Now Left, Right
and Center horizontal alignments are detected within the XLS
file and appropriately shown in the output file.
-
Converting from xls to csv, sometimes fractional values were
reset to 0's.
-
Converting from xls to a fixed width text file. Sometimes the
column widths were off
3.71 to 3.72 (7/16/2007)
3.69 to 3.71 (6/27/2007)
-
Special Process 101: When range specified contained unused rows,
and doing multiple workbooks, and specifying to place the data
BELOW the last used data, the process would simply copy over the
previous workbooks data. It appeared as if only one xls file was
being processed.
3.68 to 3.69 (6/27/2007)
3.67 to 3.68 (6/20/2007)
3.66 to 3.67 (6/20/2007)
3.65 to
3.66 (6/14/2007)
3.64 to
3.65 (5/29/2007)
3.63 to
3.64 (5/23/2007)
3.62 to
3.63 (5/3/2007)
-
Special Process 204 (CSV Remove empty lines) no longer puts a
CR+LF character set at the end of the resulting file. This was
producing an un-needed line that was itself empty
-
Conversion: XLS to TXT/CSV etc. Round off of fractional values
was not handled properly
-
Conversion: CSV to XLS. When converting from CSV to XLS, and
there is nothing between a set of comma's, a space character
exists in the resulting XLS file
3.61 to
3.62 (5/2/2007)
-
Converting from CSV->XLS, if double quotes are used, and an item
within the double quotes contains a delimiter (comma for
example) then the delimiter is not ignored
-
Converting from tab delimited csv to a XLS file, the 2nd row
appears shifted when it should not be
3.60 to
3.61 (4/9/2007)
-
Conversion: CSV to XLS/TXT etc. When a comma was present,
and not being used as the delimiter, it was being used for the
delimiter in addition to the other character specified for the
delimiter.
-
Scheduler: Timing was off when approaching midnight. Date is now
taken into consideration.
-
Japanese Language File updated
3.59 to
3.60 (4/2/2007)
3.58 to
3.59 (3/28/2007)
3.57 to
3.58 (3/12/2007)
3.56 to
3.57 (2/15/2007)
-
Command Line: Special process 108, if double quotes are used
around the RANGE variable it was not working.
-
Conversions are now more efficient.
-
Special Process 101: When going from many files to a single one,
the FILE selection button was hidden.
-
Conversion: Double quotes can now be chosen in 3 ways,
sometimes, always, or never.
3.55 to
3.56 (2/13/2007)
-
Conversion: From XLS to TXT, or CSV etc, Some spreadsheets
caused errors for no known reason.
-
Command Line: Special process 108, if double quotes are used
around the RANGE variable it was not working.
3.54 to
3.55 (2/9/2007)
3.53 to
3.54 (2/5/2007)
3.52 to
3.53 (1/30/2007)
-
Conversion: 'Convert XLS' Conversion method. Converting from CSV
to a fixed width text file: Whenever 2 commas appear next to
each other, the program only appears to treat it as 1 comma
-
Converting: 'Convert XLS" Conversion method. Large CSV files
with very big fields resulted in an unknown error.
3.51 to
3.52 (1/9/2007)
3.50 to
3.51 (12/24/2006)
3.49 to
3.50 (12/20/2006)
3.48 to
3.49 (12/12/2006)
3.47 to
3.48 (12/4/2006)
3.46 to
3.47 (11/24/2006)
-
Special Process 115\To Single Sheet, Now you can do multiple
files to a single sheet, without overwriting data.
-
Conversion XLS\ A new conversion option has been added to
included or remove the double quote character.
3.45 to
3.46 (11/24/2006)
-
Usability: When users double click on a conversion item, the
options for that item now come up. This is now true for
both Conversion and Special Processing items.
-
Special Process 115 Added: Ability to import tables from a Word
Document to an Excel file in a flexible manner
3.44 to
3.45 (11/16/2006)
-
Special Process 101: When specifying a whole column (i.e. "G:G")
for the range to copy from it would have a problem.
-
Conversion: If target folder does not exist, we create it
automatically
-
Conversion: Fixed Width Text to/from ASCII and UNICODE now works
great.
3.43 to
3.44 (11/14/2006)
-
Special Process "[60] Launch (Run) a program" now works with BAT
files
-
Conversion\Convert XLS conversion method: HUGE files can now be
processed, even those with more than 65565 rows.
Conversion to and from the following file types is now much
faster (CSV, CSV Unicode, TEXT, TEXT Unicode, HTML, and XLS).
3.42 to
3.43 (10/17/2006)
3.41 to
3.42 (10/5/2006)
-
Special Process 60, Launch (run) a program: The target file had
to be a file. This is no longer the case
-
Special Process 56, Search and Replace. Passing a search
parameter which contained special characters (e.g. /1 #N©47©A )
were not working properly.
3.40 to
3.41 (10/2/2006)
3.39 to
3.40 (9/28/2006)
3.38 to
3.39 (9/22/2006)
-
Command Line: If a conversion job was not rewound, the command
line would report a successful conversion, even though it did
nothing. Now, if doing the command line, the complete conversion
job is done from beginning to end, regardless of whether or not
the conversion job was rewound last time it was edited.
-
Max number of files during trial changed from 250 to 100
3.37 to
3.38 (9/1/2006)
-
Documentation\Command
Line Examples for Conversion have been completely filled in.
Now it should be a simple matter of finding an example that fits
your specific need and modifying it slightly.
-
Command Line\'Convert
XLS' conversion method\ If target folder did not exist, it would
report a successful conversion, even though nothing was
converted.
-
Command Line\ /N
switch would not work if only a single item was in the argument.
-
Command Line /G when
specifying whole folders, was malfunctioning in certain
conversions such as TXT to HTML,CSV, CSV to TXT,HTML etc.
3.36 to
3.37 (8/18/2006)
3.35 to
3.36 (7/1/2006)
-
Special Process 114:
Run A MACRO is now implemented. Run an Excel Macro from
the command line, or the 'Convert XLS' user interface!
-
Japanese Language file
updated
3.34 to
3.35 (6/28/2006)
3.33 to
3.34 (5/11/2006)
-
'Convert XLS'
conversion method: Target file could not be renamed after
conversion.
-
'Convert XLS'
conversion method: Original input files that were text, and did
not have a Carraige Return + Line Feed for each end of line
(Windows) but instead only a Line Feed (Unix/Linux) would not be
processed properly.
3.32 to
3.33 (3/6/2006)
3.30 to
3.32 (2/28/2006)
-
Special process 113,
now updates user interface more effecitively.
-
Special process 113,
now if a range is empty or not specified the used range is
printed, as it should be.
3.29 to
3.30 (2/2/2006)
3.28 to
3.29 (2/2/2006)
3.27 to
3.28 (1/19/2006)
3.26 to
3.27 (1/10/2006)
3.25 to
3.26 (12/27/2005)
3.24 to
3.25 (12/2/2005)
-
Special Process 101,
108, 112 : Range can now be specified to start a cell and end at
the last used cell. For example to begin the range at B2
and get all the data to the right and bottom of B2 you would
specify "B2:*".
3.23 to
3.24 (11/28/2005)
3.22 to
3.23 (11/24/2005)
-
Conversion Options:
Moved Optimization file menu items to the 'Converison Options'
dialog.
-
Conversion Options:
Moved the Excel Passwords option from the File\Options menu item
to the 'Conversion Options button\Excel Tab' area.
-
Conversion Options:
Moved "Skip Empty Worksheets" from the "Conversion" menu item to
the 'Conversion Options button\Excel Tab' area.
-
Enhanced documentation
for both Program and Conversion Options.
3.21 to
3.22 (11/23/2005)
3.20 to
3.21 (11/21/2005)
-
Special Processes for
Excel: "[112] Clear Cel lContents" added
-
Special Processes for
Excel: "[108] Change Cell Number Format", "[101] Copy Sheet
Data", and "[112] Clear Cel lContents", all now can have a
range with commas. For example you can now specify
"A10:B20,Z10,J10:K11". Before comma's seperating each
sub-range was not allowed.
-
Documentation Updated
3.19 to
3.20 (11/8/2005)
3.18 to
3.19 (10/27/2005)
3.17 to
3.18 (10/25/2005)
3.160 to 3.17
(10/4/2005)
3.150 to 3.160
(8/31/2005)
3.140 to 3.150
(8/29/2005)
-
Convert XLS conversion
method: Converting a fixed width text file with columns of width
greather than 256 characters would not be imported completely.
-
MS Excel Conversion
method: The MHT file type for single html file has been added as a
possible file type to convert to.
3.130 to 3.140
(8/26/2005)
-
When converting to a
fixed width text file, and specifying the width of each column, it
is now possible to do multipe conversion items, each with a unique
set of column widths
-
A new command line
argument /I{iniFile} has been added. The switch allows you to
override the default initialization file which contains all the
program settings which persist between runs.
3.120 to 3.130
(8/15/2005)
3.110 to 3.120
(8/15/2005)
3.100 to 3.110
(8/7/2005)
-
Cells that have more
than 255 characters of textual data were getting truncated when
being converted. This is no longer an issue
-
Files being converted to
a fixed width text file where the width of each column was
specified, an extra space between fields was being inserted. This
is no longer the case, allowing users to fully specify the output.
3.099 to 3.100
(8/2/2005)
3.098 to 3.099
(8/1/2005)
3.096 to 3.098
(7/29/2005)
3.095 to 3.096
(7/14/2005)
3.094 to 3.095
(7/7/2005)
-
'Convert XLS' conversion
method only, Conversion to a fixed width text file is now able to
specify each and every column width.
-
/A switch removed, /N
switch updated now to include 3 possible methods for
importing/exporting fixed width text files.
3.093 to 3.094
(6/29/2005)
3.092 to 3.093
(6/24/2005)
3.091 to 3.092
(6/21/2005)
3.09 to 3.091
(6/10/2005)
-
Converting from CSV to
XLS using the command line use to require the /N switch. This has
been removed and by default the delimitation character will be a
comma.
-
Documentation enhanced
in the Command line arena.
3.08 to 3.09
(5/16/2005)
-
NT4.0 installation
should now work properly
-
'Convert XLS' conversion
method: Loading of complex
Japanese Excel workbooks should now work properly
-
'Convert XLS' conversion
method: Certain files were not converting properly in Windows 98
3.071 to 3.08
(5/6/2005)
-
Special
Process 101, The "-" character can now be used in sheet names.
Also, you can select multiple sheets in the Sheet selection
dialog box
-
Conversion from a fixed width text file to a CSV file now
supported. Each columns width of the text file can be
specified
-
'Convert XLS' conversion method now supports going from TXT to
CSV, TXT to HTML, TXT to XML, CSV to TXT, CSV to HTML, CSV to XML etc.
-
Conversion of textual files (CSV, TXT): If UNICODE or ANSII were
improperly specified, the alternate will be tried before giving
up.
3.07 to 3.071
(4/19/2005)
-
Documentation updated for new command line switches
-
The /N
switch now works properly but also now requires that double
quotes be placed around the parameter. Like so:
/N”Apples,Oranges^A2:B20^9”
3.06 to 3.07
(4/13/2005)
-
New
option added for converting from XLS to TXT, autosizing of
columns before conversion is now optional, thereby retaining the
data. A new switch has been added /A to turn this feature
off.
-
New
switch /H added to allow for the exporting of both data and
formula.
3.05 to 3.06
(4/13/2005)
3.04 to 3.05
(4/6/2005)
3.03 to 3.04
(4/5/2005)
3.02 to 3.03
(3/29/2005)
-
When
using the 'Convert XLS' conversion method, you can now
specifically export only formulas, formulas and values, or only
values.
-
Conversion\'Convert XLS' conversion method. Now currency symbols
are handled properly.
-
Conversion\'Convert XLS' conversion method. You can now specify
Ranges when converting from a character separated file (e.g. CSV,
TSV etc.) to an Excel (XLS) file.
-
Conversion\'Convert XLS' conversion method. Any character can now
be specified when converting from a character separated file to
an XLS file.
3.01 to 3.02
(3/23/2005)
-
Search
and replaced enhanced. Now 'Don't match if end of line' and
'Don't match if Beginnning of Liine' are working. Report
created when doing a search and replace now is showing the 'what
was replaced', not 'what with'. Output file now is
terminated properly.
-
'Convert XLS' Conversion method: HTML, UNICODE CSV, ASCII CSV,
UNICODE TEXT, and ASCII TEXT target file types are now
available in addition to the already existing XLS, and XML.
3.0 to 3.01
(3/16/2005)
-
An
annoying message box would pop up every time upon execution for
those who did not have MS Excel installed.
-
Warnings now added for those who attempt to do things that
require MS Excel, and don't have it installed.
2.6 to 3.0
(3/16/2005)
-
ENTERPRISE EDITION introduce, XLS to CSV, XML, TXT and CSV to XLS
conversion now possible WITHOUT the need for MS Excel on the
target PC.
2.51 to 2.6
(2/20/2005)
2.50 to
2.51 (2/4/2005)
-
Delete Original Files after
processing feature added to the File\Options menu item
-
Specifying Passwords to open
both Original and Target files now available in the File\Options
menu item
-
Ability to specify Passwords
through the command line now possible via the /W-/Z switches
-
New Special process 111 added
to allow for users to change or remove passwords on XLS files.
2.47 to
2.50 (2/3/2005)
2.40 to
2.47 (1/10/2005)
2.37 to
2.40 (12/1/2004)
2.36 to
2.37 (11/22/2004)
-
Copy whole sheets can now
rename the copied sheet, however only when copying a single
sheet.
-
Copy whole sheets can now
copy within the same workbook file
2.35 to
2.36 (11/18/2004)
2.34 to
2.35 (11/17/2004)
-
New menu item added 'Skip
Empty Worksheets' located under the 'Conversion' menu item. Used when doing conversions from XLS to
any other file type. If sheet is empty, no conversion will
be done. This is useful if you specify all sheets with "*"
and only 1 of 3 sheets had information.
2.33 to
2.34 (11/15/2004)
2.33 to
2.34 (10/12/2004)
2.32 to
2.33 (9/24/2004)
2.31 to
2.32 (9/24/2004)
-
A new special process has been
added specifically for TXT or CSV files. Special process 75
"Replace character, ignore within quotation marks". Basically
allows you to do a search and replace for a single character with the
added benefit of ignoring anything within double quotes. This is
especially useful for those trying to create a CSV file from a text
file, that only needs a delimitation character (comma or otherwise)
swapped out.
2.30 to
2.31 (9/21/2004)
-
Special process, selection of TXT
files now includes CSV files.
-
A warning no longer pops up when
select CSV files, and TXT is the file type chosen.
2.225 to
2.30 (7/2/2004)
2.22 to
2.225 (7/2/2004)
2.21 to
2.22 (7/2/2004)
-
Enhanced special process 209
for making fixed width CSV files. You can now specify a
single, all columns or a range to pad.
2.199 to
2.21 (7/2/2004)
-
Added ability to convert to
XML, provided users have MS Office 2003 and above.
2.198 to
2.199 (7/26/2004)
2.197 to
2.198 (6/15/2004)
2.196 to
2.197 (6/15/2004)
2.195 to
2.196 (5/18/2004)
2.194 to
2.195 (5/12/2004)
-
Sheets
can now have spaces in the name, both before and after. For
example " My Sheet " or " " are now valid
sheet names.
-
Convert
Button is now initially enabled, allowing users to be informed
that they must first click the add button
2.193 to
2.194 (5/4/2004)
2.192 to
2.193 (5/4/2004)
2.191 to
2.192 (4/26/2004)
-
Special Process 108, Change Cell formatting, has been enhanced for
command line purposes. Now you must use a "\" in place of a
"/" to specify date formats. This is to assist in parsing of
the command line parameters.
2.19 to
2.191 (4/20/2004)
-
Add the end of the conversion job, the last 'Conversion Item' is
highlighted, and now the user interface on top is updated to
reflect the chosen conversion item.
-
The
help file has been updated to include Special Process 108, Excel
change Cell Number Formatting.
2.189 to
2.19 (4/16/2004)
-
Additional Sample Conversion Job files added for demonstration
purposes.
-
When
user loads a 'Conversion Job' file, the user interface now updates
according to the first task in the loaded list.
2.188 to
2.189 (4/11/2004)
2.187 to
2.188 (3/19/2004)
2.186 to
2.187 (3/18/2004)
CopySheet() now can handle when duplicate sheet names exist in
both the original and target workbook (which can be the same
workbook). 4 possible actions can be taken when duplicate sheet
names are found:
A) Copy with similar but slightly modified name
B) Overwrite duplicates
C) Skip any duplicates
D) Stop copying and report an error
2.185 to
2.186 (3/15/2004)
2.1.8 to 2.1.85 (2/6/2004)
2.172 to 2.18 (1/29/2004)
-
/O switch added to allow for the loading of a 'Conversion Job'
file without actually running it when launched in the command line
-
*.SII
files now have an application association. When double
clicking on it, it will run the conversion job invisibly.
-
A new
demo 'Conversion Job' file has been added illustrating how to copy
multiple worksheets from multiple workbooks to a target Workbook
and retain the formatting
-
Help
file updated to compliment and explain the newly added demo.
2.15 to 2.16 (12/29/2003)
-
When users
clicked on special processes, sometimes the GUI would leave unneeded
items.
-
File types for special process were being incorrectly updated in
the user interface.
2.12 to 2.15 (12/28/2003)
2.10 to 2.11 (11/30/2003)
2.09 to 2.10 (10/10/2003)
2.08 to 2.09 (10/9/2003)
2.07 to 2.08 (9/30/2003)
2.06 to 2.07 (9/15/2003)
2.05 to 2.06 (9/15/2003)
2.04 to 2.05 (8/19/2003)
-
Optimize
For Speed now added to File Menu allowing for faster operations when
doing Excel manipulations and conversions.
-
Excel
Sheets with MACRO's are no longer an issue. Many times XLS files
had a Workbook_Open() event which would cause havoc in 'Convert XLS'.
-
Ranges of
sheets are now capable of being specified, before only the first sheet.
2.03 to 2.04 (8/15/2003)
2.02 to 2.03 (7/29/2003)
2.01 to 2.02 (6/22/2003)
1.19 to 2.01 (6/9/2003)
1.18 to 1.19 (5/04/2003)
-
Unlimited
number of 'Conversion Items' can now be loaded via Conversion Job file
(*.SII) or through the command line. Use to be limited to 32,000
-
Faster load
times for the Conversion Job file
1.17 to 1.18 (4/22/2003)
1.16 to 1.17 (4/9/2003)
1.15 to 1.16 (4/1/2003)
1.14 to 1.15 (3/25/2003)
1.13 to 1.14 (3/14/2003)
1.12 to 1.13 (3/7/2003)
1.08 to 1.12 (1/31/2003)
1.07 to 1.08 (1/07/2003)
-
Added
ability to save log as a 'Conversion Job'
-
Added /J
switch to allow for specifying a 'Conversion Job' in the command line
-
Added /B
switch to allow for saving the log as a 'Conversion Job' in the command
line
1.06 to 1.07 (12/30/2002)
-
Add entry
in GUI now works properly
-
Both the
task and log grids are resizable
-
File list
building now shows progress.
-
Folder
selection now working properly when a root drive folder is selected
1.05 to 1.06 (12/23/2002)
1.03 to 1.05 (12/18/2002)
-
File export
now retains margins for PDF and other file formats
-
Now you can
specify an 'Original' file that doesn't exist. This may be helpful
in cases where you want to perform multiple conversions on the same
file.
1.02 to 1.03 (11/20/2002)
1.01 to 1.02 (11/19/2002)
-
Specify
save to original folder added
-
User
interface enhanced greatly
-
Now allowed
for all possible file formats supported by MS Word
-
Saving to a
target folder now creates the sub-folders which mirror the originals
1.00 to 1.01 (5/1/2002)
|
