BrowardHealth.EPPlusHelperCore
1.5.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 BrowardHealth.EPPlusHelperCore --version 1.5.0
NuGet\Install-Package BrowardHealth.EPPlusHelperCore -Version 1.5.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="BrowardHealth.EPPlusHelperCore" Version="1.5.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add BrowardHealth.EPPlusHelperCore --version 1.5.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: BrowardHealth.EPPlusHelperCore, 1.5.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 BrowardHealth.EPPlusHelperCore as a Cake Addin #addin nuget:?package=BrowardHealth.EPPlusHelperCore&version=1.5.0 // Install BrowardHealth.EPPlusHelperCore as a Cake Tool #tool nuget:?package=BrowardHealth.EPPlusHelperCore&version=1.5.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
static async Task Main(string[] args)
{
string execDir = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
string inputFileName = "Test.xlsx";
string inputFilePath = Path.Combine(execDir, inputFileName);
Console.WriteLine($"{inputFilePath} => DataTable...");
DataTable dataTable = inputFilePath.EPPlusReadFromExcel();
Console.WriteLine($"{inputFilePath} => Json...");
string json = inputFilePath.EPPlusReadJsonFromExcel();
File.WriteAllText(Path.Combine(execDir, Path.GetFileNameWithoutExtension(inputFileName)+".json"), json);
//Console.WriteLine($"{json}");
Console.WriteLine($"{inputFilePath} => html...");
var html = inputFilePath.EPPlusReadHtmlFromExcel();
File.WriteAllText(Path.Combine(execDir, Path.GetFileNameWithoutExtension(inputFileName) + ".html"), html.html);
//Console.WriteLine($"{html.html}");
File.WriteAllText(Path.Combine(execDir, Path.GetFileNameWithoutExtension(inputFileName) + ".css"), html.css);
//Console.WriteLine($"{html.css}");
var htmlTemplate = "<html>\r\n<head>\r\n<style type=\"text/css\">\r\n{0}</style></head>\r\n<body>\r\n{1}</body>\r\n</html>";
File.WriteAllText(Path.Combine(execDir, Path.GetFileNameWithoutExtension(inputFileName) + "Combined.html"),
string.Format(htmlTemplate, html.css, html.html));
string outputFileName = "TestOut.xlsx";
string outputFilePath = Path.Combine(execDir, outputFileName);
Console.WriteLine($"DataTable => {outputFilePath}...");
dataTable.EPPlusWriteExcelFile(outputFilePath);
Console.WriteLine($"{inputFilePath} => DataTable...");
List<dynamic> list = inputFilePath.EPPlusReadFromExcel<dynamic>();
string outputFileName1 = "TestOut1.xlsx";
string outputFilePath1 = Path.Combine(execDir, outputFileName1);
Console.WriteLine($"List => {outputFilePath1}...");
list.EPPlusWriteExcelFile(outputFilePath1);
string inputFileName2 = "Test.csv";
string outputFileName2 = "TestOut2.xlsx";
string inputFilePath2 = Path.Combine(execDir, inputFileName2);
string outputFilePath2 = Path.Combine(execDir, outputFileName2);
Console.WriteLine($"{inputFilePath2} => {outputFilePath2}...");
await inputFilePath2.EPPlusWriteExcelFileAsync(outputFilePath2
//, excelTextFormat: null
, excelTextFormat: new()
{
Delimiter = ',',
SkipLinesEnd = 1,
TextQualifier = '\"',
DataTypes = new eDataTypes[] {
eDataTypes.DateTime,
eDataTypes.Number,
eDataTypes.String }
}
);
string outputFileName3 = "TestOut3.csv";
string outputFilePath3 = Path.Combine(execDir, outputFileName3);
Console.WriteLine($"{outputFilePath} => {outputFilePath3}...");
await outputFilePath.EPPlusWriteCsvFileAsync(outputFilePath3
//, excelOutputTextFormat: null
, excelOutputTextFormat: new()
{
Delimiter = ',',
SkipLinesEnd = 1,
TextQualifier = '\"',
FirstRowIsHeader = true
}
);
string outputFileName4 = "TestOut4.json";
string outputFilePath4 = Path.Combine(execDir, outputFileName4);
Console.WriteLine($"{outputFilePath} => {outputFilePath4}...");
await outputFilePath.EPPlusWriteJsonFileAsync(outputFilePath4);
// option 1
Console.WriteLine($"{inputFilePath} => dynamic list...");
List<dynamic> list1 = inputFilePath.EPPlusReadFromExcel<dynamic>();
foreach (dynamic row in list1.Take(5))
{
Console.WriteLine($"{row.PT_Number}, {row.Admit_Date}");
}
// option 2
Console.WriteLine($"{inputFilePath} => ExpandoObject list...");
List<ExpandoObject> list2 = inputFilePath.EPPlusReadFromExcel<ExpandoObject>();
foreach (ExpandoObject eo in list2.Take(5))
{
var dict = (IDictionary<string, object>)eo;
foreach (string key in dict.Keys)
{
Console.Write($"{key}, {dict[key]}; ");
}
Console.WriteLine();
}
// option 3
Console.WriteLine($"{inputFilePath} => Dictionary list...");
List<Dictionary<string, object>> list3 = inputFilePath.EPPlusReadFromExcel<Dictionary<string, object>>();
foreach (var dict in list3.Take(5))
{
foreach (KeyValuePair<string, object> pair in dict.ToList())
{
Console.Write($"{pair.Key}, {pair.Value}; ");
}
Console.WriteLine();
}
Console.WriteLine("Enter any key to exit...");
Console.ReadKey();
}
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net7.0 is compatible. 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.
-
net7.0
- EPPlus (>= 6.2.8)
- Newtonsoft.Json (>= 13.0.3)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.