openxml_excel 1.1.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 openxml_excel --version 1.1.0
NuGet\Install-Package openxml_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="openxml_excel" Version="1.1.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add openxml_excel --version 1.1.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: openxml_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 openxml_excel as a Cake Addin #addin nuget:?package=openxml_excel&version=1.1.0 // Install openxml_excel as a Cake Tool #tool nuget:?package=openxml_excel&version=1.1.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Usage:
<code>
using openxml_excel_test;
ExcelDocColumns colDef = new()
{
columns = new List<ExcelDocColumn>()
{
new ExcelDocColumn() { colNumber=1, width=30} ,
new ExcelDocColumn() { colNumber=2, width=30} ,
new ExcelDocColumn() { colNumber=3, width=30}
}
};
Console.Write("Test (c)creation or (o)open:");
var option = Console.ReadLine()??"".ToLower();
if (option == "c")
{
Console.WriteLine($"Creando xlsx... ");
ExcelDoc xls = new ExcelDoc("pepe3.xlsx", "Hoja1", colDef);
//ExcelDoc.CreateSpreadsheetWorkbook("pepe.xlsx");
xls.InsertText("Val 1 =", 1, 1);
xls.InsertText("23.98", 2, 1, "number");
xls.InsertText("Val 2 =", 1, 2);
xls.InsertText("2367849", 2, 2, "number");
//xls.InsertText( "Val 1", "A", 1);
//xls.InsertText( "Val 2", "A", 2);
xls.Close();
Console.WriteLine("Creado!");
}
if (option == "o")
{
Console.Write("Name of xisting xls:");
var filename = Console.ReadLine() ?? "";
ExcelDoc xls = new ExcelDoc();
xls.OpenSpreadsheetWorkbook(filename, false);
if (xls.spreadsheetDocument != null)
{
var list = xls.ToList();
if (list != null)
{
int counter = 0;
foreach (var row in list)
{
Console.Write($"{++counter:0000} ");
foreach (var value in row)
{
Console.Write($"{value} |");
}
Console.WriteLine();
}
}
else
{ Console.WriteLine("Empty xls"); }
}
else
{
Console.WriteLine("Could not open xls file.");
}
}
</code>
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
- DocumentFormat.OpenXml (>= 2.19.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Just description