ExcelDataExtractor 1.0.3
dotnet add package ExcelDataExtractor --version 1.0.3
NuGet\Install-Package ExcelDataExtractor -Version 1.0.3
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="ExcelDataExtractor" Version="1.0.3" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add ExcelDataExtractor --version 1.0.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: ExcelDataExtractor, 1.0.3"
#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 ExcelDataExtractor as a Cake Addin
#addin nuget:?package=ExcelDataExtractor&version=1.0.3
// Install ExcelDataExtractor as a Cake Tool
#tool nuget:?package=ExcelDataExtractor&version=1.0.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
ExcelDataExtractor
A nuget package used for reading from and writing to excels.
Badges
stable release version:
Tech Stack
C#, .Net6.0, .NetStandard2.1,
How Do I Get Started
First, install NuGet. Then, install ExcelDataExtractor from the package manager console:
NuGet\Install-Package ExcelDataExtractor -Version 1.0.30
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.
Or from the .NET CLI as:
dotnet add package ExcelDataExtractor --version 1.0.30
Finally, import into the file:
using ExcelDataExtractor;
using ExcelDataExtractor.Dtos.Responses;
Features
- Write to excel
- Read from excel
Sample usage
Excel.WriteToExcel(collection: List<T>(), worksheetName: string, unlockedColumns: int[], hiddenColumns: int[]);
- Input
| Parameters | Type | Description |
|---|---|---|
collection, |
List<T>() |
Required. List of model to be converted to excel |
worksheetName |
string |
Required. Name of file after write is completed |
unlockedColumns |
int[] |
Required. Columns that should be unlocked |
hiddenColumns |
int[] |
Required. Columns that should be hidden |
- Output
| Type |
|---|
ExcelWriteResponse |
Excel.ReadFromExcel<T>(excelFile, requiredHeaders: string[], nullableColumns: string[], columnsToSkip: string[], columnToCheckForDuplicates: string, uniqueColumns: string[]);
- Input
| Parameters | Type | Description |
|---|---|---|
excelFile, |
IFormFile |
Required. Excel to be converted to object |
requiredHeaders |
string[]? |
nullable. Columns that cannot be empty |
nullableColumns |
string[]? |
nullable. Columns that can be empty |
columnsToSkip |
string[]? |
nullable. Columns that should be skipped |
columnToCheckForDuplicates |
string |
Required. Columns that duplicates are not allowed |
uniqueColumns |
string[]? |
nullable. Columns that must be unique |
- Output
| Type |
|---|
ExcelReadResponse<T> |
Thanks to all Contributors
Maintainers:
Contributing
Contributions are always welcome!
See contributing.md for ways to get started.
Please adhere to this project's code of conduct.
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. 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. |
| .NET Core | netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
| .NET Standard | netstandard2.1 is compatible. |
| MonoAndroid | monoandroid was computed. |
| MonoMac | monomac was computed. |
| MonoTouch | monotouch was computed. |
| Tizen | tizen60 was computed. |
| Xamarin.iOS | xamarinios was computed. |
| Xamarin.Mac | xamarinmac was computed. |
| Xamarin.TVOS | xamarintvos was computed. |
| Xamarin.WatchOS | xamarinwatchos was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
.NETStandard 2.1
- EPPlus (>= 6.0.4)
- Microsoft.AspNetCore.Http.Features (>= 5.0.17)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.