frends-community - Frends.Community.ConvertExcelFile 1.7.1
Tasks for converting Excel files to JSON, XML or CSV.
PM> Install-Package Frends.Community.ConvertExcelFile -Version 1.7.1 -Source https://www.myget.org/F/frends-community/api/v3/index.json
> nuget.exe install Frends.Community.ConvertExcelFile -Version 1.7.1 -Source https://www.myget.org/F/frends-community/api/v3/index.json
> dotnet add package Frends.Community.ConvertExcelFile --version 1.7.1 --source https://www.myget.org/F/frends-community/api/v3/index.json
source https://www.myget.org/F/frends-community/api/v3/index.json
nuget Frends.Community.ConvertExcelFile ~> 1.7.1> choco install Frends.Community.ConvertExcelFile --version 1.7.1 --source https://www.myget.org/F/frends-community/api/v2
Import-Module PowerShellGet
Register-PSRepository -Name "frends-community" -SourceLocation "https://www.myget.org/F/frends-community/api/v2"
Install-Module -Name "Frends.Community.ConvertExcelFile" -RequiredVersion "1.7.1" -Repository "frends-community"
Browse the sources in this package using Visual Studio or WinDbg by configuring the following legacy symbol server URL: https://www.myget.org/F/frends-community/symbols/
Frends.Community.ConvertExcelFile
FRENDS Community Task for ConvertExcelFile.
Installing
You can install the task via FRENDS UI Task View or you can find the NuGet package from the following NuGet feed https://www.myget.org/F/frends-community/api/v3/index.json and in Gallery view in MyGet https://www.myget.org/feed/frends-community/package/nuget/Frends.Community.ConvertExcelFile
Tasks
ConvertExcelFile
Reads Excel file and converts it to XML, CSV and JSON according to the task input parameters.
Properties
| Property | Type | Description | Example |
|---|---|---|---|
| Message | string |
Some string that will be repeated. | foo |
Options
| Property | Type | Description | Example |
|---|---|---|---|
| ReadOnlyWorkSheetWithName | string | Excel work sheet name to be read. If empty, all work sheets are read. | Sheet1 |
| CsvSeparator | string | Csv Separator | ; |
| UseNumbersAsColumnHeaders | bool | If set to true, numbers will be used as column headers instead of letters (A = 1, B = 2...) | true |
| ThrowErrorOnfailure | bool | Throws an exception if conversion fails. | true |
| DateFormat | DateFormat | Selection for date format | Possible values: DDMMYYYY, MMDDYYYY, YYYYMMDD |
| ShortDatePattern | bool | Excludes timestamps from dates | false |
Returns
| Property | Type | Description | Example |
|---|---|---|---|
| ResultData | DataSet | Conversion result as a DataSet | |
| Success | bool | Task execution result. | true |
| Message | string | Exception message | "File not found" |
| ToXml() | string | Converts result to XML | XML-string |
| ToCsv() | string | Converts result to CSV | CSV-string |
| ToJToken() | JToken | Converts result to Json |
License
This project is licensed under the MIT License - see the LICENSE file for details
Building
Clone a copy of the repository.
git clone https://github.com/CommunityHiQ/Frends.Community.ConvertExcelFile.git
Build the project.
dotnet build
Run tests.
dotnet test
Create a NuGet package.
dotnet pack --configuration Release
Contributing
When contributing to this repository, please first discuss the change you wish to make via issue, email, or any other method with the owners of this repository before making a change.
- Fork the repo on GitHub
- Clone the project to your own machine
- Commit changes to your own branch
- Push your work back up to your fork
- Submit a Pull request so that we can review your changes
NOTE: Be sure to merge the latest from "upstream" before making a pull request!
Change Log
| Version | Changes |
|---|---|
| 1.6.0 | Input filename is now case sensitive. Updated libraries. |
| 1.7.0 | Converted to support .Net Framework 4.7.1 and .Net Standard 2.0. |
| 1.7.1 | Fixed issue #7: ToJson() should return json in usable format |
| 1.7.2 | Fixed issue #8: Date times are conversion depends computer settings |
| 1.7.3 | Fixed issue #16: Changed FileStream class to use FileAccess.Read |
| 2.0.0 | Updated frameworks to include .NET 6.0 and .NET 8.0. Updated package dependencies: Excel DataReader from 3.6.0 to 3.7.0 and System.Text.Encoding.CodePages from 5.0.0 to 8.0.0. Breaking change due to framework additions and major version updates on package dependencies |
-
.NETFramework 4.7.1
- ExcelDataReader (>= 3.6.0)
- ExcelDataReader.DataSet (>= 3.6.0)
- Microsoft.CSharp (>= 4.7.0)
- Newtonsoft.Json (>= 12.0.1)
- System.ComponentModel.Annotations (>= 5.0.0)
- System.Text.Encoding.CodePages (>= 5.0.0)
-
.NETStandard 2.0
- ExcelDataReader (>= 3.6.0)
- ExcelDataReader.DataSet (>= 3.6.0)
- Microsoft.CSharp (>= 4.7.0)
- Newtonsoft.Json (>= 12.0.1)
- System.ComponentModel.Annotations (>= 5.0.0)
- System.Text.Encoding.CodePages (>= 5.0.0)
- .NETFramework 4.7.1: 4.7.1.0
- .NETStandard 2.0: 2.0.0.0
| Assembly | Assembly hash | Match |
|---|---|---|
| /lib/netstandard2.0/frends.community.convertexcelfile.dll | 4873a6db067f420eb16e82167927b779FFFFFFFF | |
| /lib/net471/frends.community.convertexcelfile.dll | fcd7f0a2e6d74246979e8935a6ca4612FFFFFFFF |
OwnersFRENDS Community Feed User |
AuthorsHiQ Finland |
Project URLhttps://github.com/CommunityHiQ/Frends.Community.ConvertExcelFile |
LicenseUnknown |
TagsFrends |
Info496 total downloads |
| 14 downloads for version 1.7.1 |
| Download (15.52 KB) |
| Download legacy symbols (29.26 KB) |
| Found on the current feed only |
Package history
| Version | Size | Last updated | Downloads | Mirrored? | |||
|---|---|---|---|---|---|---|---|
|
2.0.0 | 33.89 KB | Mon, 10 Feb 2025 09:07:08 GMT | 47 |
|
||
|
|
1.7.3 | 17.88 KB | Tue, 13 Aug 2024 09:15:39 GMT | 53 |
|
||
|
|
1.7.2 | 17.3 KB | Fri, 31 Dec 2021 07:52:58 GMT | 182 |
|
||
|
|
1.7.1 | 15.52 KB | Wed, 15 Dec 2021 13:18:58 GMT | 14 |
|
||
|
|
1.7.0 | 14.4 KB | Thu, 04 Feb 2021 12:54:00 GMT | 72 |
|
||
|
|
1.6.0 | 7.83 KB | Fri, 07 Jun 2019 07:25:16 GMT | 84 |
|
||
|
|
1.5.0 | 7.82 KB | Mon, 17 Sep 2018 12:10:35 GMT | 44 |
|