BufferExcelWriter 0.0.3
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 BufferExcelWriter --version 0.0.3
NuGet\Install-Package BufferExcelWriter -Version 0.0.3
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="BufferExcelWriter" Version="0.0.3" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add BufferExcelWriter --version 0.0.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: BufferExcelWriter, 0.0.3"
#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 BufferExcelWriter as a Cake Addin #addin nuget:?package=BufferExcelWriter&version=0.0.3 // Install BufferExcelWriter as a Cake Tool #tool nuget:?package=BufferExcelWriter&version=0.0.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
BufferExcelWriter
Samples in BufferExcelWriter.Sample
var wb = new WorkBookDfn(); //new workbook
try
{
var header = new RowDfn //create header
{
Cells = new List<CellDfn>
{
new CellDfn("Name"),
new CellDfn("Index"),
new CellDfn("noVal")
}
};
var sheet = new WorkSheetDfn("sheetName", header); //new sheet
wb.Sheets.Add(sheet); //add sheet to workbook
await wb.OpenWriteExcelAsync(); //init write;
/*
balabala generate data like: */
var size = 10000;
foreach (var outerIndex in Enumerable.Range(0, 100))
{
foreach (var index in Enumerable.Range(outerIndex * size, size))
sheet.BufferedRows.Add(new RowDfn
{
Cells = new List<CellDfn>
{
new CellDfn("Name", $"foo{index}"),
new CellDfn("Index", index.ToString())
}
});
await wb.FlushBufferedRowsAsync(true); //flush buffered row and clean buffered row
}
using (var fs = File.Create($"{DateTime.Now.Ticks}.xlsx"))
{
using (var stream = await wb.CloseExcelAndGetStreamAsync()) //close write and get stream from finished job
{
stream.Position = 0;
stream.CopyTo(fs);
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
finally
{
wb.Dispose(); //clean stream、files and something else;
}
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. 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. |
.NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
.NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen40 was computed. tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
.NETStandard 2.0
- No dependencies.
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
0.1.5 | 857 | 7/13/2020 |
0.1.4 | 561 | 9/14/2019 |
0.1.3 | 539 | 8/2/2019 |
0.1.2 | 533 | 8/2/2019 |
0.1.1 | 589 | 7/29/2019 |
0.1.0 | 547 | 7/29/2019 |
0.0.8 | 563 | 7/2/2019 |
0.0.7 | 572 | 6/13/2019 |
0.0.6 | 578 | 6/13/2019 |
0.0.5 | 727 | 12/6/2018 |
0.0.4 | 802 | 8/31/2018 |
0.0.3 | 789 | 8/31/2018 |
0.0.2 | 781 | 8/31/2018 |
0.0.1 | 815 | 8/3/2018 |
1.BufferExcelWriter
2.Wrap Data with CDATA
3.Make sheet's Header public