- Ability to manipulate and save spreadsheets containing special characters (UTF-8)
- The temporary directory "SheetHelper" is automatically deleted upon completion
- Ability to select rows in reverse order (e.g., "3:1")
- Columns can be selected in reverse order (e.g., "-1:-5")
- Dictionary of forbidden cell terms that will be replaced
- Semicolons (";") in cells are retained within the cell instead of creating a new column
- Possible to obtain the DataSet from a file
- Cells that have line breaks will now be correctly converted
- The
NormalizeText
method allows removing all accents and spaces from a text - Possible to convert all tabs of the spreadsheet considering all rows and columns
- Use
GetRowArray
to obtain a row from a DataTable - The
GetSheets
method allows obtaining all sheets from the spreadsheet in DataTable - Fixed selection of first line that is not the header
- Now it's possible to perform the conversion of tabs that have only one row
- Allowed to specify the name of the sheet disregarding sensitive case
- Allowed to save dataTable in different formats and with restriction of columns and rows
- Added possibility to get the first row of a DataTable
- Added handling for end user when file not found or in use, with MessageBox for NetFramework
- Fixed conversion considering header format
- Dealing with unnecessary conversion between .CSV and .TXT
- Added possibility to convert ranges of rows. Eg: "1:23, -34:56, 70, 75, -1"
- Possible to convert column ranges. Eg: "A:H, 4:9, 4:-9, B, 75, -2"
- Integrated ExcelDataReader library
- Compatible with net462, netstandard 2.0 and netstandard 2.1
- Several bugs fixed
- Performance improvement
- Added option to perform continuous column (A:AB) conversion and choose sheet by name or index
- Added option to convert RPT files
- Added option to choose rows, progressBar and unzip files
- Adding XSLB, XSL, HTML and CSV file conversion possibility and header size choice
- Allowing visualization of the summary of the methods
- Icon, readme and naming update
- Bugs fixed
- Release