BufferExcelWriter 0.0.5
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.5
NuGet\Install-Package BufferExcelWriter -Version 0.0.5
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.5" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add BufferExcelWriter --version 0.0.5
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: BufferExcelWriter, 0.0.5"
#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.5
// Install BufferExcelWriter as a Cake Tool
#tool nuget:?package=BufferExcelWriter&version=0.0.5
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
BufferExcelWriter
Samples Project ⇒ BufferExcelWriter.Sample
public static async Task WriteTestDataAsync1()
{
var header = new RowDfn
{
Cells = new List<CellDfn>
{
new CellDfn("Nam®e"),
new CellDfn("Index"),
new CellDfn("noVal")
}
};
var oddSheet = new WorkSheetDfn("Odd", header); //add headers
var evenSheet = new WorkSheetDfn("Even", header);
var wb = new WorkBookDfn("tempFolder");
wb.Sheets.Add(oddSheet);
wb.Sheets.Add(evenSheet);
await wb.OpenWriteExcelAsync(); //open write
var sw = new Stopwatch();
foreach (var outerIndex in Enumerable.Range(0, 10))
{
sw.Reset();
var size = 1000;
foreach (var index in Enumerable.Range(outerIndex * size, size))
if (index % 2 == 0)
evenSheet.BufferedRows.Add(new RowDfn
{
Cells = new List<CellDfn>
{
new CellDfn("Name", $"fo&o{index}"),
new CellDfn("Index", index.ToString())
}
});
else
oddSheet.BufferedRows.Add(new RowDfn
{
Cells = new List<CellDfn>
{
new CellDfn("Nam®e", $"f¥¥¥©$ \"oo{index}"),
new CellDfn("Index", index.ToString())
}
});
sw.Start();
await wb.FlushBufferedRowsAsync(true); //flushDataAndClean
sw.Stop();
Console.WriteLine(sw.Elapsed);
}
using (var fs = File.Create($"{DateTime.Now.Ticks}.xlsx"))
{
using (var stream = wb.CloseExcelAndGetStreamAsync().Result)
{
stream.Position = 0;
stream.CopyTo(fs);
}
}
sw.Reset();
sw.Start();
wb.Dispose();
sw.Stop();
Console.WriteLine($"clean cost : {sw.Elapsed}");
Console.WriteLine("Over");
Console.ReadLine();
}
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 | 800 | 7/13/2020 |
0.1.4 | 554 | 9/14/2019 |
0.1.3 | 533 | 8/2/2019 |
0.1.2 | 528 | 8/2/2019 |
0.1.1 | 583 | 7/29/2019 |
0.1.0 | 543 | 7/29/2019 |
0.0.8 | 556 | 7/2/2019 |
0.0.7 | 565 | 6/13/2019 |
0.0.6 | 571 | 6/13/2019 |
0.0.5 | 721 | 12/6/2018 |
0.0.4 | 794 | 8/31/2018 |
0.0.3 | 780 | 8/31/2018 |
0.0.2 | 773 | 8/31/2018 |
0.0.1 | 809 | 8/3/2018 |
1.BufferExcelWriter
2.Wrap Data with CDATA
3.Make sheet's Header public
4.fix null reference exceptions;add custom temp folder support;clean temp folder when workbook's dispose