keyboard_return Version 2.0.7

New features

  • New conversion engine based on NPOI.
  • Added possibility to name profiles and added additional information to a profile such as creation/modified date.
  • Added recognition for more types of cells (numerical, percentage, currency, fraction, scientific, date, text, boolean and formula are now recognized and can be processed differently).
  • Ranges can now be defined using a separate start and stop strategy.
  • Added option to skip hidden sheets.
  • Added option to export the formula of a formula cell rather then its calculated output value or text.
  • Added additional system output format patterns for ‘Cells > Date’ (universal date/time, sortable date/time, long date, short date, full date/time).
  • Added ‘Cells > Time’ option in case only the time is present in a date cell, additional formats related to time can be chosen (text, value, long time, short time).

Enhancements

  • Improved reliability of conversion results in terms of exporting the visualized values:
  • Much better handling of numerical cells
  • Cell determination used to be column based. Now each column can have multiple types of cells
  • Added support for 1900 and the 1904 date system in Excel through NPOI.
  • Improved processing of merged cells (the data in merged cells will now be copied into each cell of the range in the export).
  • Improve detection of empty rows (e.g. for Google drive sheets) to be able to skip them if enabled in the profile.
  • It is now possible to convert a workbook that is open in Microsoft Excel.
  • Improved error handling when opening workbooks by informing the user with a user-friendly error messages.
  • In case of an unknown error, the user can see a suggestion to send the ‘invalid’ Excel file to us
  • Added option to drag & drop files/folders onto source and destination in the conversion setup.
  • Added shortcut to copy/paste file- and folder paths in source/destination through right-click context menu and CTRL+V.
  • Significantly improved the profile manager in terms of usability.
  • Refactored rulesets into separate profile types.
  • 3 profile types are available for conversion (CSV & Excel, DSV and Simple, more types will be added in the future).
  • Added more output options for the log such as the destination and encoding.
  • Added option to export only the first sheet in a workbook.
  • Added support for automatically backing up profiles during migration.
  • Changed ‘Cell > Date > Value’ option to return the Excel numerical value instead of long date pattern formatted text.
  • Improved usability by replacing inclusion/exclusion filters with list-capable control (no more need to enter separator string).
  • Removed profile option to rename the existing/old file if a new file is written with the same name.
  • Changed profile option to rename the new file if it already exists by adding a sequence number instead of a dateTime.
  • Profiles are now loaded and validated at startup and managed internally in memory. This improves performance when opening conversion setup page.
  • Profiles are now saved as XML-based files.
  • Online context-sensitive help for better and up-to-date information.
  • Removed dependency to AutoIt, the application is now fully developed in Microsoft .NET.
  • CLI now supports named arguments and made profile optional (default CSV profile will be used).
  • Moved away from storing settings in registry (preparation for making application portable).
  • Dynamic updates of online resources.
  • Added batched statistics transmission to Google Analytics.
  • Beta versions will now always check for BETA updates (and final updates).

Fixes

  • Fixed an issue where the main form would not always be displayed after startup.
  • Installer improvements.

Important notes

Profiles created in version 1 of the application are not compatible with this version of the application.

*.xlsb files and old Excel 95 files are no longer supported in 2.x.

By updating to Microsoft .NET framework 4.6 we decided to give up support for Windows XP (Windows Vista and higher are still supported).

The installation package now contains both the 32-bit and the 64-bit files and the correct one will be installed depending on the system.