openxml_excel 1.1.1
See the version list below for details.
dotnet add package openxml_excel --version 1.1.1
NuGet\Install-Package openxml_excel -Version 1.1.1
<PackageReference Include="openxml_excel" Version="1.1.1" />
paket add openxml_excel --version 1.1.1
#r "nuget: openxml_excel, 1.1.1"
// Install openxml_excel as a Cake Addin #addin nuget:?package=openxml_excel&version=1.1.1 // Install openxml_excel as a Cake Tool #tool nuget:?package=openxml_excel&version=1.1.1
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.");
}
}
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net6.0 is compatible. 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. |
-
net6.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