TsadriuUtilities.Excel 1.1.0

.NET 5.0 This package targets .NET 5.0. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package TsadriuUtilities.Excel --version 1.1.0                

                    
                

            
NuGet\Install-Package TsadriuUtilities.Excel -Version 1.1.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="TsadriuUtilities.Excel" Version="1.1.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add TsadriuUtilities.Excel --version 1.1.0                

                    
                

            
#r "nuget: TsadriuUtilities.Excel, 1.1.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install TsadriuUtilities.Excel as a Cake Addin
#addin nuget:?package=TsadriuUtilities.Excel&version=1.1.0

// Install TsadriuUtilities.Excel as a Cake Tool
#tool nuget:?package=TsadriuUtilities.Excel&version=1.1.0

TsadriuUtilities

A small package that uses NPOI to read xlsx files.

TsadriuUtilities.Excel is a library that helps on dealing with XLSX files to hopefully make coding easier while also saving a bit of time.

> Features <

ExcelHelper:

  • ConvertXlsxToCsv(ISheet excelSheet, bool keepInOneLine, string separator):
    • Reads the xlsx sheet and converts it into a .csv file.
  • GetCellIndex(ISheet excelSheet, string cellName):
    • Checks through the entire xlsx file for the cellName (Not case-sensitive).
  • GetColumnData(ISheet excelSheet, string columnName, ColumnContentEnum directionOfData, bool includeColumnHeader, int columnLength):
  • GetColumnData(ISheet excelSheet, int rowIndex, int columnIndex, ColumnContentEnum directionOfData, bool includeColumnHeader, int columnLength):
    • Checks the xlsx file for the columnName (rowIndex, columnIndex) and returns all the content in a list of string.
  • GetCellAsString(ISheet excelSheet, int currentRow, int currentColumn):
    • Searches and returns the current xlsx cell as a string (Supported types: String and Numeric).
  • CompareXlsxContent(ISheet currentExcelSheet, ISheet excelToCompare):
    • Compares the overall content between two sheets by converting them into a csv and checking the text between them.
  • GetLastRowIndex(ISheet excelSheet):
    • Returns the last row of the excelSheet (0 based).
  • GetLastColumnIndex(ISheet excelSheet):
    • Returns the last column of the excelSheet (0 based).
Product Compatible and additional computed target framework versions.
.NET net5.0 is compatible.  net5.0-windows was computed.  net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

  • net5.0

  • net6.0

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
2.5.1 499 6/16/2023
2.5.0 543 2/17/2023
2.4.1 247 2/15/2023
2.4.0 254 2/15/2023
2.3.0 276 2/10/2023
2.2.1 247 2/9/2023
2.2.0 354 1/20/2023
2.1.2 359 12/14/2022
2.1.0 307 12/14/2022
2.0.0 299 12/14/2022
1.1.2 424 5/31/2022
1.1.1 399 5/31/2022
1.1.0 422 5/31/2022
1.0.2 424 5/30/2022

ExcelHelper:
- Updated description of method CompareXlsxContent().
- Implemented method GetCellIndex().
- Implemented method GetColumnData().
- Implemented method GetLastRowIndex().
- Implemented method GetLastColumnIndex().