Excellent 1.0.0
There is a newer version of this package available.
See the version list below for details.
See the version list below for details.
dotnet add package Excellent --version 1.0.0
NuGet\Install-Package Excellent -Version 1.0.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="Excellent" Version="1.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Excellent --version 1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Excellent, 1.0.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 Excellent as a Cake Addin
#addin nuget:?package=Excellent&version=1.0.0
// Install Excellent as a Cake Tool
#tool nuget:?package=Excellent&version=1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
excellent
UTILS TO TRANSFORM / MERGE / DIFF EXCEL FILES
SAMPLE USAGE:
excellent -transform -i "TestData\Localizations_1.xlsx" [-o "Localizations_1.sql"] [-f "EXEC [dbo].[usp_InsertLocalizationData] @ResourceId = '{ResourceId}', @English = '{English}'"]
excellent -merge -i "TestData\Localizations_1.xlsx" ["TestData\Localizations_2.xlsx"] [-o Localizations_Merged.xlsx] [-d]
excellent -diff -i "TestData\Localizations_1.xlsx" "TestData\Localizations_2.xlsx" [-c]
excellent -diff -i "TestData\Localizations_1.xlsx" "SELECT * FROM [dbo].[Localizations]" -s "Data Source=server.database.windows.net;Initial Catalog=master;Persist Security Info=True;User ID=userid;Password=pwd"
CONFIG:
<add key="PrimaryKey" value="{ResourceId}_{ResourceSet}" />
<add key="TransformFormat" value="EXEC [dbo].[usp_InsertLocalizations] @ResourceId = '{ResourceId}', @English = '{English}', @French = '{French}', @Spanish = '{Spanish}', @ResourceSet = '{ResourceSet}'" />
<add key="DiffSqlCommand" value="SELECT * FROM [dbo].[Localizations]" />
<escapeChars>
<add key="'" value="''" />
</escapeChars>
excellent.exe.config
HELP:
general
-v, --verbose Prints all messages to standard output.
--help Display this help screen.
--version Display version information.
transform
-i, --input Required. Input file to be transformed.
-f, --format Transformation format (using Smart-Format).
-o, --output Output file.
-d, --remove-dups (Default: true) Remove duplicates rows based on PK
-c, --ignore-case (Default: true) Ignore casing while performing comparisons
merge
-i, --input Required. Input files to be merged.
-l, --keep-left Retain the values from Left file when a duplicate exists.
-r, --keep-right Retain the values from Right file when a duplicate exists.
-o, --output Output file.
-d, --remove-dups (Default: true) Remove duplicates rows based on PK
-c, --ignore-case (Default: true) Ignore casing while performing comparisons
diff
-i, --input Required. Input files to be diff'd.
-s, --sqlconn Sql Server Connection-string).
-o, --output Output file.
-d, --remove-dups (Default: true) Remove duplicates rows based on PK
-c, --ignore-case (Default: true) Ignore casing while performing comparisons
VS EXCEL-DIFF EXTERNAL GUI TOOL (USING BEYOND-COMPARE)
.git\config
# 'Program Files' OR 'Program Files (x86)' based on the installation
[diff]
tool = bc4
[difftool "bc4"]
cmd = \"C:\\Program Files\\Beyond Compare 4\\BComp.exe\" \"$LOCAL\" \"$REMOTE\"
[merge]
tool = bc4
[mergetool "bc4"]
cmd = \"C:\\Program Files\\Beyond Compare 4\\BComp.exe\" \"$REMOTE\" \"$LOCAL\" \"$BASE\" \"$MERGED\"
There are no supported framework assets in this package.
Learn more about Target Frameworks and .NET Standard.
-
.NETFramework 4.6.2
- ClosedXML (>= 0.93.1)
- CommandLineParser (>= 2.3.0)
- ExcelDataReader (>= 3.4.2)
- ExcelDataReader.DataSet (>= 3.4.2)
- Serilog (>= 2.7.1)
- Serilog.Sinks.Console (>= 3.1.1)
- Serilog.Sinks.RollingFile (>= 3.3.0)
- SmartFormat.NET (>= 2.3.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.