Softpedia >Windows >Office tools >Other Office Tools >Excel Converter >  Changelog

Excel Converter Changelog

What's new in Excel Converter 2.0.9.0

Jul 13, 2018
  • Fixed the worksheet filters making them fully case-insensitive.

New in Excel Converter 2.0.8.0 (Aug 21, 2017)

  • New features:
  • Added option to unmerge merged cells.
  • Enhancements:
  • Updated NPOI to version 2.3.0.0.
  • Updated update manager.

New in Excel Converter 1.5.2.5004 (Feb 11, 2014)

  • ENH: Added option to skip empty rows from being converted
  • ENH: Improved engine to be able to process cells with more than 255 characters (no longer truncated).

New in Excel Converter 1.5.1.5002 (Feb 11, 2014)

  • Maintenance release, updated links to internet resources.

New in Excel Converter 1.5.0.5001 (Nov 25, 2013)

  • NEW: Add option to DSV ruleset to escape single and double quotes
  • NEW: Added option to find the first row and/or column based on the cell value
  • NEW: Added (more obvious) option to output the log as html or text
  • NEW: Added option to append data to a file if it already exists
  • ENH: Improved conversion strategy combining text and value modes for each type of cell (currency, number, text, boolean, date) and ensuring actual values are maintained in the output
  • ENH: Removed restriction to run command-line only from the command-prompt (cmd) process
  • ENH: Numerous profile manager improvements
  • ENH: Added option to remove special characters from a field value
  • ENH: Text input fields are now mandatory
  • ENH: Filename correction option removed, invalid filename characters will now be stripped automatically
  • ENH: DSV related options are now more restrictive to ensure better DSV compliancy
  • ENH: Changed how the escape, newline and delimiter characters are C-style escaped
  • ENH: Accidentally pressing the Escape button on the keyboard no longer closes XLS2CSV Converter
  • ENH: Additional checks on required components/dependencies to avoid certain types of OLEDB exceptions that still occurred
  • ENH: Performance improvements when navigating the application
  • ENH: Rare situation where the main window would move to the background when closing the profile manager or log window has been fixed
  • FIX: Fixed an issue where error 'The requested action with this object has failed (line 5021)' is shown when starting the application
  • ENH: The option to export the first sheet of every workbook has been removed as this has been replaced with inclusion/exclusion filters and caused confusion
  • ENH: Included latest version of the AccessDatabaseEngine
  • FIX: Fixed issue where using spaces as character replacement is discarded when reloading the profile
  • FIX: Option to rename files when they already existed did not always create all files, has been resolved
  • FIX: Cancel an ongoing conversion is now immediate and shows more accurate result statistics.
  • NOTE: Existing profiles are migrated automatically to be compatible with this version of the application. After migration, they are no longer compatible with older versions of XLS2CSV Converter.

New in Excel Converter 1.4.1.4009 (Jul 23, 2013)

  • FIX: Solved an issue where the combination of a ruleset and multiple conditions would not process all of the requirements correctly.

New in Excel Converter 1.4.0.4007 (Jul 23, 2013)

  • NEW: Updated statistical engine to work with Google Analytics (updated license)
  • NEW: Ability to save log to *.html file (formatted table)
  • ENH: Console prompts (without options) no longer require manual input / interaction
  • FIX: Console prompts in Windows 8 did not register the user response correctly
  • FIX: Added error message when ADB components are not installed
  • FIX: Fixed an error where the main window would not appear after start
  • FIX: Question to erase destination folder is no longer asked when the folder is already empty
  • FIX: Application crash (stopped responding) when XLSX, XLSM or XLSB files were opened by Excel.
  • FIX: Files that are in use are now detected and no longer converted
  • FIX: Opening destination folder from a QuickLaunch run did not work.

New in Excel Converter 1.3.3.3755 (Jul 23, 2013)

  • FIX: Issue where source- and destination location was limited to 75 characters causing 'file not found' during conversion.

New in Excel Converter 1.3.2.3754 (Jul 23, 2013)

  • NEW: For following settings related to the CSV ruleset:
  • Added option to replace/remove the delimiter value in a cell
  • Added option to replace/remove the quote value in a cell
  • Added option to replace/remove the newline value in a cell
  • Added option to trim leading and trailing spaces in a cell
  • NEW: For following settings related to the DSV ruleset:
  • Added option to replace/remove the delimiter value in a cell
  • Added option to replace/remove the escape value in a cell
  • Added option to replace/remove the newline value in a cell
  • Added option to replace/remove the tab value in a cell
  • NEW: Added option to define a custom logfile path & name with variables
  • ENH: Improved loggging now shows the user the inclusion/exclusion filter is not activated when left empty
  • FIX: Corrected tooltip for 'save' function in profile manager
  • FIX: Some small errors in the manual.

New in Excel Converter 1.3.1.3722 (Jul 23, 2013)

  • NEW: 'QuickLaunch' XLS2CSV Converter GUI with arguments
  • NEW: Easy creation of XLS2CSV Converter QuickLaunch shortcuts
  • NEW: Locations and profiles recent history
  • ENH: Filter in source file selection dialog box now contains all supported filetypes that are enabled in the active profile
  • ENH: Changed updatecheck to be more discrete
  • ENH: Update now integrated in main window
  • ENH: Application setup options now integrated in main window
  • ENH: Ability to open location of source/destination/profile directly from XLS2CSV Converter
  • ENH: Profile 'save as' function now available through profile window
  • ENH: No longer working with 'BETA notifications'
  • ENH: Refactor GUI creation (more efficient processing)
  • ENH: New set of icons
  • ENH: Application now remembers window positions and size of the most important windows (log, main window, profile window)
  • FIX: Fixed an issue where loading certain invalid profile settings would generate an AutoIt error
  • FIX: Fixed a situation where the default profile would be overwritten if it already existed in the profile folder.

New in Excel Converter 1.3.0.2900 Beta (Jul 23, 2013)

  • NEW: Added support for macro-enabled workbooks (*.xlsm)
  • NEW: Added support for binary workbooks (*.xlsb)
  • NEW: Added customizable RowStart and RowCount parameters
  • NEW: Added customizable ColumnStart and ColumnCount parameters
  • NEW: Added option to automatically create a log file after conversion
  • NEW: Required components now included in installer (.NET Framework 4.0 and AccessDatabase Engine 2010)
  • ENH: Data connectivity components requirements updated (version 2010 instead of 2007 required)
  • ENH: Improved database engine options and engine support checks (XLS2CSV Converter used to throw the error that a file was invalid or could not be opened in certain situations)
  • ENH: In case the option 'Cleanup' in the profile is set to 'Prompt' the application will ask to clean the output folder ONLY in case it exists. It used to ALWAYS ask the question regardless whether or not the folder existed.
  • ENH: Consistency of items in the conversion log has been improved
  • FIX: Fixed 'export as text' strategy to better support cells with more than 255 characters (values are no longer truncated)
  • FIX: Fixed an issue where starting the application would throw

New in Excel Converter 1.2.0.2701 (Oct 31, 2011)

  • ENH: Sheetnames inclusion and exclusion filters are no longer case-sensitive.
  • FIX: Fixed an issue where certain valid workbooks would trigger the error "Unsupported file extension".

New in Excel Converter 1.2.0.2700 Beta (Oct 31, 2011)

  • ENH: DLL errors no longer show a dialog box that needs to be confirmed. Only an error is logged in the conversion log.
  • ENH: BETA confirmation in Command-Prompt utility no longer requires a confirmation from the user. A timer is used instead.
  • FIX: Fixed an error that prevented the Command-Prompt to run from any location except the installation folder.

New in Excel Converter 1.2.0.2694 Beta (Oct 31, 2011)

  • NEW: CSV standard compliancy options.
  • NEW: DSV standard compliancy options.
  • NEW: Excel-only compliancy options.
  • NEW: Added customizable quote character.
  • NEW: Added customizable newline character to better support different types of systems (MAC OS, Linux, Windows,...).
  • NEW: Added default/example conversion profiles (optionally installable).
  • NEW: New sheet selection options: Inclusion and exclusion filter supporting wildcards (? and *).
  • ENH: Prefix and suffix are no longer available, replaced by automated compliancy checking + quote character.
  • ENH: Profile management - support for easily selecting and maintaining specific conversion profiles.
  • ENH: Updated profile (x2c file) sections so that settings are grouped under the relevant section as shown in the settings window.
  • ENH: Updated profile (x2c file) content so that it only contains relevant settings (e.g. in case of CSV ruleset, no DSV settings are present in the file).
  • ENH: Customizable profile folder path.
  • ENH: Customizable filename output supporting the use of filename variables.
  • ENH: Updated internet links (moved away from co.cc).
  • ENH: User now gets feedback on input of invalid code page.
  • ENH: Overview of settings is now available for Export, Conversion and Output profile setting groups.
  • ENH: Splash screen is shown to show application startup tasks.
  • ENH: Automatically check for updates at application startup.
  • ENH: Separated commandline support entirely from GUI and replaced by fully native DOS application.
  • ENH: Improved error handler for COM exceptions that generate AutoIT errors with message : 'operation with this object has failed'.
  • ENH: Text input in certain profile settings (e.g. delimiter) is replaced by a dropdown box with suggestions + free input.
  • ENH: Context sensitive help >> helpfile will now open on the correct page depending on where it is triggered.
  • FIX: Fixed certain cases where the output file could not be created due to invalid filename characters.
  • FIX: Fixed a textual error in case a conversion profile was imported, dialog box showed 'export' instead of 'import'.
  • FIX: Fixed a situation where an OLEDB exception is thrown in case a filter is active on a worksheet.
  • FIX: Fixed situations where OLEDB exceptions were thrown in case of sheet containing 'special' characters (we assume this fixes most of the OLEDB exceptions people were getting).
  • FIX: Fixed an issue where paths containing single quotes would cause AutoIt errors.
  • FIX: Fixed issue where special characters such as the "" were no longer converted to the actual character to be used in the conversion output.
  • FIX: Checkbox value 'false' was incorrectly set in conversion profile.

New in Excel Converter 1.1.0.1741 Beta (Oct 31, 2011)

  • ENH: Added additional filename option (workbook filename)

New in Excel Converter 1.1.0.1740 Beta (Oct 31, 2011)

  • NEW: Support for conversion of 1 file or 1 directory.
  • NEW: Additional output filename options.
  • NEW: Customizable output file extension.
  • NEW: Additional overwrite options.
  • NEW: Added option to convert all sheets from every workbook.
  • NEW: Prefix and Suffix are now separate options instead of one 'Quote char' option.
  • NEW: Customizable codepage setting for encoding the output.
  • NEW: Import/Export conversion settings to a profile (x2c profile also usable for command-line support).
  • ENH: Improved lay-out of main window and settings window.
  • ENH: Progress and results are now only shown when useful.
  • ENH: Improved conversion log viewer with filter options.
  • ENH: Better handling of directory and file selection and recognition of 'invalid' items such as libraries/invalid links.
  • ENH: Free source/destination folder input (Manual input no longer blocked).
  • ENH: Xlsx files are no longer converted when required component not found on system.
  • ENH: User now has the option to convert only xls, only xlsx or both file types.
  • ENH: Improved application startup checks.
  • ENH: Changed commandline tool to require 4 parameters: source, destination, profile, interactivity level.
  • ENH: Overwrite option 'overwrite' now no longer deletes the file but actually overwrites it keeping the file attributes and other properties unchanged.
  • FIX: No longer creates empty files (in case of empty sheets).
  • FIX: Fixed case where the application would throw an AutoIt error.
  • FIX: Fixed an error where an invalid filename would result in an OLEDB error.
  • FIX: Fixed an error where insufficient rights would result in an OLEDB error.

New in Excel Converter 1.0.0.335 (Oct 31, 2011)

  • NEW: Added online update checker.
  • FIX: Typo "Threat all as text" should be "Treat all as text".

New in Excel Converter 1.0.0.325 Beta (Oct 31, 2011)

  • NEW: Added possibility to enter a TAB character as delimiter.
  • ENH: Export first sheet of every workbook is always the first alphabetically. Clarified the text in the settings window.
  • ENH: Command-line now supports relative paths.
  • ENH: Code optimizations.
  • FIX: Fixed an issue where the logfile could not be written to disk when the destination directory no longer existed (dialog box requesting to write log to system disk).

New in Excel Converter 1.0.0.292 Beta (Oct 31, 2011)

  • NEW: Optional command-line support.
  • ENH: No more online help (local help will always be installed).
  • ENH: Included additional information about conversion in log.

New in Excel Converter 1.0.0.222 (Oct 19, 2010)

  • NEW: We have turned to ‘Inno Setup’ for our installer needs and developed a brand new install wizard.
  • NEW: To further improve the application, anonymous statistics will now be transmitted on application closure.
  • FIX: Sheetnames containing single quote characters are now converted (this used to give an exception)
  • ENH: The setting 'Export mode' has been added that can improve output for certain types of *.xls(x) files (see help for more info)
  • ENH: Empty sheets no longer cause an OLEDB error during conversion but will be converted to empty *.csv files.
  • ENH: The application will now determine whether to show online or offline help (local help file included in the installer).

New in Excel Converter 1.0.0.156 (Oct 19, 2010)

  • NEW: Support for Microsoft® Excel® 2007,2010 documents (*.xlsx)
  • FIX: Moved settings file to appdata folder of the user currently logged on eliminating UAC limitations.
  • ENH: Removed the option to export all sheets from every workbook (for future release)
  • ENH: Help now refers to online help, local CHM file was removed.

New in Excel Converter 1.0.0.127 (Oct 19, 2010)

  • FIX: Encoding of the converted *.csv files has been changed to ANSI WINDOWS Codepage 1252 (West European Latin) so that it works identical to excel (save as *.csv feature).

New in Excel Converter 1.0.0.126 (Oct 19, 2010)

  • NEW: Settings screen added with preview feature
  • NEW: GUI prepared for supporting conversion of multiple sheets from each workbook (BETA NOTICE ADDED).
  • NEW: Delimiter character(s) are now customizable by the user.
  • FIX: Main window disappears behind other windows after setting input/output dir
  • FIX: XLS files in root directory were not processed, only the files from subfolders.

New in Excel Converter 1.0.0.113 (Oct 19, 2010)

  • NEW: Possibility to convert excel files with extension .xls to comma delimited files
  • NEW: User friendly interface with easy to understand statistics
  • NEW: Resultlog with export functionality