Skip to main content
Get Started

Benchmarks

Autogenerated benchmark data from committed OfficeIMO benchmark artifacts.

OfficeIMO Benchmarks

Autogenerated benchmark matrix

Each row is a scenario group. Library cells show mean time, relative time versus the fastest library in that row, and allocation or package size when available.

Generated 2026-05-31T20:56:14.1994777Z quick local quick .NET 8.0.27 SDK 10.0.300 Source: .\Docs\benchmarks\comparison-current\officeimo.excel.comparison-summary.json
274scenario rows
1106measurements
8libraries
4row tiers: 2500, 10000, 25000, 300000
4artifact types
2focused profiles

Comparison Matrix

Ratios are relative to the fastest measured library in the same scenario row. Lower is better.

autofit-existing2500 rows - mutate - AutoFit and mutation - speed-comparisonOfficeIMO.Excel9.58 ms246.28 ms 25.7x 82.6 MB153.26 ms 16.0x 49.5 MB96.76 ms 10.1x 0 B---9.58 ms 1x 1.9 MB-
realworld-report-no-autofit2500 rows - mutate - AutoFit and mutation - speed-comparisonOfficeIMO.Excel15.80 ms-52.21 ms 3.30x 32.1 MB41.12 ms 2.60x 0 B---15.80 ms 1x 16.1 MB-
realworld-report-chart-first2500 rows - other - Anti-cheat report variants - speed-comparisonOfficeIMO.Excel12.31 ms-72.95 ms 5.93x 53.3 MB71.50 ms 5.81x 0 B---12.31 ms 1x 7.3 MB-
realworld-report-extra-column2500 rows - other - Anti-cheat report variants - speed-comparisonOfficeIMO.Excel18.17 ms-75.44 ms 4.15x 57.8 MB83.91 ms 4.62x 0 B---18.17 ms 1x 17.2 MB-
realworld-report-post-mutation2500 rows - other - Anti-cheat report variants - speed-comparisonOfficeIMO.Excel16.10 ms-77.29 ms 4.80x 53.3 MB69.99 ms 4.35x 0 B---16.10 ms 1x 16.1 MB-
realworld-report-shuffled-columns2500 rows - other - Anti-cheat report variants - speed-comparisonOfficeIMO.Excel22.37 ms-70.13 ms 3.13x 53.3 MB70.10 ms 3.13x 0 B---22.37 ms 1x 16.1 MB-
build-object-datatable-dictionaries2500 rows - other - Object projection - speed-comparisonOfficeIMO.Excel1.58 ms------1.58 ms 1x 564.2 KB-
build-object-datatable-typed2500 rows - other - Object projection - speed-comparisonOfficeIMO.Excel1.24 ms------1.24 ms 1x 856.9 KB-
enumerate-cells2500 rows - other - Range and table read - speed-comparisonOfficeIMO.Excel6.05 ms32.07 ms 5.30x 16.6 MB34.27 ms 5.67x 19.7 MB----6.05 ms 1x 2.5 MB-
enumerate-first-column-from-wide-sheet2500 rows - other - Range and table read - speed-comparisonOfficeIMO.Excel3.93 ms31.65 ms 8.06x 15.1 MB23.08 ms 5.88x 12.8 MB----3.93 ms 1x 526.1 KB-
enumerate-range2500 rows - other - Range and table read - speed-comparisonOfficeIMO.Excel5.77 ms36.64 ms 6.35x 16.6 MB34.80 ms 6.03x 19.7 MB----5.77 ms 1x 2.5 MB-
enumerate-top-range2500 rows - other - Range and table read - speed-comparisonOfficeIMO.Excel0.74 ms38.74 ms 52.7x 15.0 MB26.30 ms 35.7x 12.1 MB----0.74 ms 1x 285.5 KB-
realworld-autofilter2500 rows - other - Real-world feature mix - speed-comparisonOfficeIMO.Excel3.76 ms30.06 ms 7.99x 21.7 MB39.23 ms 10.4x 24.1 MB31.90 ms 8.48x 0 B---3.76 ms 1x 1.3 MB-
realworld-charts2500 rows - other - Real-world feature mix - speed-comparisonOfficeIMO.Excel5.08 ms-44.67 ms 8.80x 26.5 MB34.43 ms 6.78x 0 B---5.08 ms 1x 1.8 MB-
realworld-conditional-formatting2500 rows - other - Real-world feature mix - speed-comparisonOfficeIMO.Excel3.99 ms31.01 ms 7.77x 21.8 MB40.54 ms 10.2x 24.2 MB35.13 ms 8.80x 0 B---3.99 ms 1x 1.4 MB-
realworld-data-validation2500 rows - other - Real-world feature mix - speed-comparisonOfficeIMO.Excel3.79 ms31.48 ms 8.31x 21.7 MB47.86 ms 12.6x 24.1 MB31.43 ms 8.30x 0 B---3.79 ms 1x 1.3 MB-
realworld-freeze-panes2500 rows - other - Real-world feature mix - speed-comparisonOfficeIMO.Excel3.54 ms30.17 ms 8.52x 21.7 MB46.01 ms 13.0x 24.2 MB32.39 ms 9.15x 0 B---3.54 ms 1x 1.3 MB-
realworld-pivot-table2500 rows - other - Real-world feature mix - speed-comparisonOfficeIMO.Excel15.54 ms-50.67 ms 3.26x 28.8 MB35.76 ms 2.30x 0 B---15.54 ms 1x 15.3 MB-
realworld-report-all-in-one2500 rows - other - Real-world report - speed-comparisonOfficeIMO.Excel18.80 ms-78.40 ms 4.17x 53.3 MB81.58 ms 4.34x 0 B---18.80 ms 1x 16.1 MB-
realworld-report-core2500 rows - other - Real-world report - speed-comparisonOfficeIMO.Excel4.45 ms87.76 ms 19.7x 68.2 MB66.04 ms 14.8x 46.2 MB67.08 ms 15.1x 0 B---4.45 ms 1x 1.5 MB-
report-workbook2500 rows - other - Report workbook - speed-comparisonOfficeIMO.Excel31.04 ms-118.61 ms 3.82x 75.7 MB95.11 ms 3.06x 0 B---31.04 ms 1x 20.0 MB-
report-workbook-core2500 rows - other - Report workbook - speed-comparisonOfficeIMO.Excel7.25 ms119.32 ms 16.4x 94.9 MB117.98 ms 16.3x 70.3 MB82.84 ms 11.4x 0 B---7.25 ms 1x 2.6 MB-
report-workbook-datatable2500 rows - other - Report workbook - speed-comparisonOfficeIMO.Excel27.85 ms-109.46 ms 3.93x 64.4 MB84.67 ms 3.04x 0 B---27.85 ms 1x 20.3 MB-
report-workbook-datatable-core2500 rows - other - Report workbook - speed-comparisonOfficeIMO.Excel6.52 ms103.43 ms 15.9x 80.9 MB100.44 ms 15.4x 59.1 MB84.15 ms 12.9x 0 B---6.52 ms 1x 2.9 MB-
append-plain-rows2500 rows - package - Package size - package-profileLargeXlsx1.55 ms17.06 ms 11.0x 59.8 KB30.39 ms 19.6x 56.9 KB--1.55 ms 1x 63.1 KB5.08 ms 3.27x 68.1 KB2.04 ms 1.31x 63.0 KB-
autofit-existing2500 rows - package - Package size - package-profileOfficeIMO.Excel8.95 ms142.40 ms 15.9x 121.0 KB85.46 ms 9.55x 115.0 KB----8.95 ms 1x 143.2 KB-
large-shared-strings2500 rows - package - Package size - package-profileOfficeIMO.Excel2.13 ms13.59 ms 6.37x 50.3 KB33.29 ms 15.6x 48.1 KB---4.75 ms 2.23x 60.7 KB2.13 ms 1x 55.2 KB-
realworld-autofilter2500 rows - package - Package size - package-profileOfficeIMO.Excel3.93 ms31.75 ms 8.08x 120.2 KB45.17 ms 11.5x 114.2 KB----3.93 ms 1x 142.4 KB-
realworld-charts2500 rows - package - Package size - package-profileOfficeIMO.Excel5.01 ms-45.03 ms 8.98x 117.0 KB----5.01 ms 1x 147.6 KB-
realworld-conditional-formatting2500 rows - package - Package size - package-profileOfficeIMO.Excel3.98 ms32.06 ms 8.06x 120.3 KB41.71 ms 10.5x 114.3 KB----3.98 ms 1x 142.7 KB-
realworld-data-validation2500 rows - package - Package size - package-profileOfficeIMO.Excel4.66 ms39.65 ms 8.52x 120.3 KB43.46 ms 9.33x 114.2 KB----4.66 ms 1x 142.5 KB-
realworld-freeze-panes2500 rows - package - Package size - package-profileOfficeIMO.Excel4.21 ms51.06 ms 12.1x 120.2 KB51.43 ms 12.2x 114.3 KB----4.21 ms 1x 142.5 KB-
realworld-pivot-table2500 rows - package - Package size - package-profileOfficeIMO.Excel40.43 ms-75.85 ms 1.88x 117.4 KB----40.43 ms 1x 200.4 KB-
realworld-report-all-in-one2500 rows - package - Package size - package-profileOfficeIMO.Excel18.79 ms-109.93 ms 5.85x 121.8 KB----18.79 ms 1x 206.5 KB-
realworld-report-chart-first2500 rows - package - Package size - package-profileOfficeIMO.Excel17.90 ms-92.37 ms 5.16x 121.8 KB----17.90 ms 1x 206.5 KB-
realworld-report-core2500 rows - package - Package size - package-profileOfficeIMO.Excel6.40 ms125.19 ms 19.6x 121.5 KB95.81 ms 15.0x 115.6 KB----6.40 ms 1x 143.9 KB-
realworld-report-extra-column2500 rows - package - Package size - package-profileOfficeIMO.Excel24.24 ms-110.91 ms 4.58x 128.4 KB----24.24 ms 1x 219.1 KB-
realworld-report-no-autofit2500 rows - package - Package size - package-profileOfficeIMO.Excel18.99 ms-55.14 ms 2.90x 121.8 KB----18.99 ms 1x 206.4 KB-
realworld-report-post-mutation2500 rows - package - Package size - package-profileOfficeIMO.Excel19.99 ms-89.44 ms 4.47x 121.9 KB----19.99 ms 1x 206.6 KB-
realworld-report-shuffled-columns2500 rows - package - Package size - package-profileOfficeIMO.Excel18.80 ms-124.37 ms 6.62x 124.3 KB----18.80 ms 1x 211.2 KB-
report-workbook2500 rows - package - Package size - package-profileOfficeIMO.Excel24.52 ms-97.75 ms 3.99x 161.8 KB----24.52 ms 1x 275.6 KB-
report-workbook-core2500 rows - package - Package size - package-profileOfficeIMO.Excel6.63 ms108.22 ms 16.3x 165.1 KB102.38 ms 15.4x 157.2 KB----6.63 ms 1x 187.5 KB-
report-workbook-datatable2500 rows - package - Package size - package-profileOfficeIMO.Excel22.31 ms-108.48 ms 4.86x 161.8 KB----22.31 ms 1x 275.6 KB-
report-workbook-datatable-core2500 rows - package - Package size - package-profileOfficeIMO.Excel6.43 ms136.50 ms 21.2x 165.1 KB108.72 ms 16.9x 157.2 KB----6.43 ms 1x 187.5 KB-
write-blog-2023-20-string-columns2500 rows - package - Package size - package-profileLargeXlsx4.01 ms93.21 ms 23.3x 257.2 KB---4.01 ms 1x 237.7 KB17.78 ms 4.44x 235.3 KB4.71 ms 1.17x 216.7 KB-
write-bulk-report2500 rows - package - Package size - package-profileOfficeIMO.Excel4.71 ms74.63 ms 15.8x 121.0 KB74.44 ms 15.8x 115.0 KB---9.16 ms 1.94x 153.8 KB4.71 ms 1x 143.2 KB-
write-cellformula2500 rows - package - Package size - package-profileOfficeIMO.Excel2.60 ms22.39 ms 8.62x 70.6 KB46.10 ms 17.7x 62.1 KB----2.60 ms 1x 66.6 KB-
write-cellvalue-empty-strings2500 rows - package - Package size - package-profileOfficeIMO.Excel1.98 ms12.24 ms 6.17x 44.9 KB31.05 ms 15.7x 42.0 KB----1.98 ms 1x 44.2 KB-
write-cellvalue-numbers2500 rows - package - Package size - package-profileOfficeIMO.Excel2.19 ms12.28 ms 5.61x 45.9 KB28.87 ms 13.2x 43.7 KB----2.19 ms 1x 47.0 KB-
write-cellvalue-object-mixed2500 rows - package - Package size - package-profileOfficeIMO.Excel2.58 ms18.52 ms 7.19x 59.5 KB31.22 ms 12.1x 58.9 KB----2.58 ms 1x 61.2 KB-
write-cellvalue-object-sparse2500 rows - package - Package size - package-profileOfficeIMO.Excel3.03 ms16.95 ms 5.59x 52.5 KB31.93 ms 10.5x 54.2 KB----3.03 ms 1x 62.0 KB-
write-cellvalue-object-sparse-batch2500 rows - package - Package size - package-profileOfficeIMO.Excel3.09 ms17.17 ms 5.55x 52.5 KB32.60 ms 10.5x 54.2 KB----3.09 ms 1x 62.0 KB-
write-cellvalue-scalars2500 rows - package - Package size - package-profileOfficeIMO.Excel1.92 ms12.18 ms 6.33x 45.4 KB28.89 ms 15.0x 42.4 KB----1.92 ms 1x 46.3 KB-
write-cellvalue-strings2500 rows - package - Package size - package-profileOfficeIMO.Excel3.43 ms17.24 ms 5.02x 50.3 KB39.97 ms 11.6x 48.1 KB----3.43 ms 1x 55.1 KB-
write-cellvalue-strings-distinct2500 rows - package - Package size - package-profileOfficeIMO.Excel2.19 ms17.77 ms 8.10x 61.9 KB32.79 ms 14.9x 61.5 KB----2.19 ms 1x 51.8 KB-
write-cellvalue-strings-repeated2500 rows - package - Package size - package-profileOfficeIMO.Excel1.87 ms12.02 ms 6.42x 38.8 KB29.12 ms 15.5x 34.8 KB----1.87 ms 1x 40.0 KB-
write-cellvalue-temporal2500 rows - package - Package size - package-profileOfficeIMO.Excel3.23 ms17.84 ms 5.52x 54.5 KB33.32 ms 10.3x 53.1 KB----3.23 ms 1x 63.3 KB-
write-cellvalues-headerless-rectangle-direct2500 rows - package - Package size - package-profileLargeXlsx1.42 ms17.41 ms 12.2x 53.0 KB28.68 ms 20.1x 52.5 KB--1.42 ms 1x 47.3 KB-1.59 ms 1.12x 48.2 KB-
write-cellvalues-rectangle-direct2500 rows - package - Package size - package-profileLargeXlsx3.15 ms35.29 ms 11.2x 120.1 KB50.31 ms 16.0x 114.1 KB--3.15 ms 1x 138.4 KB9.36 ms 2.98x 153.7 KB4.32 ms 1.37x 138.0 KB-
write-datareader-plain2500 rows - package - Package size - package-profileSylvan.Data.Excel3.04 ms29.12 ms 9.58x 120.1 KB47.50 ms 15.6x 114.9 KB--4.54 ms 1.49x 138.4 KB10.24 ms 3.37x 153.6 KB4.51 ms 1.48x 138.0 KB3.04 ms 1x 78.5 KB
write-datareader-table2500 rows - package - Package size - package-profileOfficeIMO.Excel4.96 ms37.73 ms 7.60x 120.9 KB45.48 ms 9.17x 114.9 KB---9.06 ms 1.83x 153.6 KB4.96 ms 1x 138.8 KB-
write-datareader-table-autofit2500 rows - package - Package size - package-profileOfficeIMO.Excel4.81 ms80.64 ms 16.8x 121.0 KB58.63 ms 12.2x 115.1 KB---8.70 ms 1.81x 153.8 KB4.81 ms 1x 138.9 KB-
write-dataset-sparse-direct-export2500 rows - package - Package size - package-profileLargeXlsx4.35 ms53.63 ms 12.3x 159.4 KB57.77 ms 13.3x 144.5 KB--4.35 ms 1x 164.2 KB12.93 ms 2.97x 180.5 KB4.53 ms 1.04x 131.1 KB-
write-dataset-sparse-tables2500 rows - package - Package size - package-profileOfficeIMO.Excel4.57 ms53.58 ms 11.7x 159.4 KB56.04 ms 12.3x 144.5 KB---9.87 ms 2.16x 180.5 KB4.57 ms 1x 176.0 KB-
write-dataset-tables2500 rows - package - Package size - package-profileOfficeIMO.Excel3.97 ms35.17 ms 8.87x 123.4 KB40.60 ms 10.2x 116.6 KB---9.22 ms 2.32x 156.4 KB3.97 ms 1x 138.9 KB-
write-dataset-tables-autofit2500 rows - package - Package size - package-profileOfficeIMO.Excel4.42 ms77.37 ms 17.5x 123.7 KB60.89 ms 13.8x 116.9 KB---8.60 ms 1.95x 156.6 KB4.42 ms 1x 139.2 KB-
write-datatable-direct2500 rows - package - Package size - package-profileOfficeIMO.Excel4.44 ms30.59 ms 6.90x 120.1 KB52.17 ms 11.8x 114.9 KB--4.70 ms 1.06x 138.4 KB9.60 ms 2.16x 153.7 KB4.44 ms 1x 138.0 KB-
write-datatable-table-direct2500 rows - package - Package size - package-profileOfficeIMO.Excel3.95 ms38.19 ms 9.68x 120.9 KB49.41 ms 12.5x 114.9 KB---12.17 ms 3.08x 153.7 KB3.95 ms 1x 138.8 KB-
write-fluent-rowsfrom-direct2500 rows - package - Package size - package-profileLargeXlsx3.27 ms29.25 ms 8.94x 120.1 KB49.20 ms 15.0x 114.9 KB--3.27 ms 1x 138.4 KB8.66 ms 2.64x 153.7 KB4.06 ms 1.24x 138.0 KB-
write-insertobjects-autofitcolumnsfor-direct2500 rows - package - Package size - package-profileOfficeIMO.Excel5.08 ms78.42 ms 15.4x 120.2 KB74.15 ms 14.6x 115.1 KB----5.08 ms 1x 142.4 KB-
write-insertobjects-direct2500 rows - package - Package size - package-profileOfficeIMO.Excel4.15 ms37.29 ms 8.98x 120.1 KB50.65 ms 12.2x 114.9 KB--4.39 ms 1.06x 138.4 KB9.07 ms 2.18x 153.7 KB4.15 ms 1x 142.3 KB-
write-insertobjects-flat-dictionaries-autofitcolumnsfor-direct2500 rows - package - Package size - package-profileOfficeIMO.Excel5.56 ms68.76 ms 12.4x 120.2 KB62.64 ms 11.3x 115.1 KB----5.56 ms 1x 138.1 KB-
write-insertobjects-flat-dictionaries-direct2500 rows - package - Package size - package-profileLargeXlsx4.03 ms33.31 ms 8.26x 120.1 KB48.27 ms 12.0x 114.9 KB--4.03 ms 1x 138.4 KB10.09 ms 2.50x 153.7 KB5.07 ms 1.26x 138.0 KB-
write-insertobjects-legacy-dictionaries-direct2500 rows - package - Package size - package-profileLargeXlsx3.36 ms31.38 ms 9.33x 120.1 KB44.74 ms 13.3x 114.9 KB--3.36 ms 1x 138.4 KB10.49 ms 3.12x 153.7 KB5.12 ms 1.52x 142.3 KB-
write-insertobjects-partial-autofitcolumnsfor-direct2500 rows - package - Package size - package-profileOfficeIMO.Excel4.66 ms56.10 ms 12.0x 120.2 KB62.00 ms 13.3x 115.0 KB----4.66 ms 1x 142.4 KB-
write-powershell-mixed-objects-direct2500 rows - package - Package size - package-profileOfficeIMO.Excel5.92 ms39.28 ms 6.63x 161.0 KB56.36 ms 9.51x 152.1 KB--6.24 ms 1.05x 182.6 KB9.50 ms 1.60x 194.0 KB5.92 ms 1x 183.1 KB-
write-powershell-psobject-mixed-direct2500 rows - package - Package size - package-profileLargeXlsx4.41 ms37.90 ms 8.59x 161.0 KB54.63 ms 12.4x 152.1 KB--4.41 ms 1x 182.6 KB9.44 ms 2.14x 194.0 KB4.99 ms 1.13x 182.4 KB-
write-powershell-psobject-wide-direct2500 rows - package - Package size - package-profileOfficeIMO.Excel22.03 ms141.65 ms 6.43x 615.5 KB197.30 ms 8.96x 548.9 KB--25.70 ms 1.17x 644.6 KB46.09 ms 2.09x 674.4 KB22.03 ms 1x 651.0 KB-
formula-heavy-read2500 rows - read - Formula write/read - speed-comparisonOfficeIMO.Excel2.66 ms16.37 ms 6.16x 8.1 MB22.42 ms 8.43x 7.5 MB13.45 ms 5.06x 0 B---2.66 ms 1x 709.4 KB-
dense-helloworld-read-range2500 rows - read - Other - dense-helloworld-comparisonSylvan.Data.Excel4.44 ms---11.13 ms 2.51x 6.7 MB-16.89 ms 3.80x 21.0 MB5.98 ms 1.35x 2.4 MB4.44 ms 1x 362.3 KB
dense-helloworld-read-stream2500 rows - read - Other - dense-helloworld-comparisonOfficeIMO.Excel5.67 ms---10.82 ms 1.91x 6.7 MB-21.82 ms 3.85x 21.0 MB5.67 ms 1x 2.4 MB6.72 ms 1.19x 362.3 KB
large-sparse-column-read2500 rows - read - Other - speed-comparisonOfficeIMO.Excel1.20 ms5.24 ms 4.35x 4.3 MB43.15 ms 35.9x 42.1 MB10.55 ms 8.77x 0 B2.40 ms 2.00x 4.0 MB-16.38 ms 13.6x 45.1 MB1.20 ms 1x 177.4 KB1.47 ms 1.22x 316.6 KB
large-sparse-row-read2500 rows - read - Other - speed-comparisonSylvan.Data.Excel1.73 ms130.35 ms 75.4x 4.3 MB78.22 ms 45.2x 42.1 MB14.09 ms 8.14x 0 B2.88 ms 1.66x 4.0 MB-18.39 ms 10.6x 45.1 MB2.64 ms 1.52x 177.5 KB1.73 ms 1x 316.6 KB
shared-string-read2500 rows - read - Other - speed-comparisonSylvan.Data.Excel2.35 ms15.49 ms 6.59x 9.3 MB20.58 ms 8.76x 10.1 MB15.48 ms 6.59x 0 B5.47 ms 2.33x 2.6 MB-8.74 ms 3.72x 7.4 MB3.02 ms 1.29x 1.0 MB2.35 ms 1x 518.6 KB
read-bottom-range2500 rows - read - Range and table read - speed-comparisonOfficeIMO.Excel4.63 ms32.55 ms 7.04x 15.0 MB25.85 ms 5.59x 12.1 MB-10.92 ms 2.36x 5.9 MB-16.73 ms 3.62x 18.2 MB4.63 ms 1x 374.5 KB5.01 ms 1.08x 655.2 KB
read-datatable2500 rows - read - Range and table read - speed-comparisonSylvan.Data.Excel6.39 ms34.64 ms 5.42x 17.9 MB34.54 ms 5.41x 21.2 MB37.35 ms 5.84x 0 B13.74 ms 2.15x 7.5 MB-13.58 ms 2.12x 17.8 MB7.97 ms 1.25x 3.5 MB6.39 ms 1x 2.2 MB
read-first-column-from-wide-sheet2500 rows - read - Range and table read - speed-comparisonSylvan.Data.Excel4.62 ms40.08 ms 8.68x 15.1 MB25.44 ms 5.51x 12.8 MB-10.20 ms 2.21x 5.9 MB-10.02 ms 2.17x 15.5 MB4.69 ms 1.02x 551.0 KB4.62 ms 1x 733.5 KB
read-range2500 rows - read - Range and table read - speed-comparisonOfficeIMO.Excel9.55 ms79.44 ms 8.32x 16.5 MB40.39 ms 4.23x 19.7 MB34.03 ms 3.56x 0 B21.67 ms 2.27x 5.9 MB-20.15 ms 2.11x 18.2 MB9.55 ms 1x 2.6 MB12.29 ms 1.29x 655.0 KB
read-range-decimal2500 rows - read - Range and table read - speed-comparisonOfficeIMO.Excel6.14 ms30.94 ms 5.04x 16.3 MB33.17 ms 5.40x 19.7 MB-13.25 ms 2.16x 5.9 MB-14.05 ms 2.29x 18.2 MB6.14 ms 1x 2.7 MB6.26 ms 1.02x 750.3 KB
read-top-range2500 rows - read - Range and table read - speed-comparisonSylvan.Data.Excel0.53 ms34.56 ms 65.0x 15.0 MB27.47 ms 51.7x 12.1 MB30.54 ms 57.4x 0 B4.70 ms 8.84x 1.9 MB-0.84 ms 1.59x 869.0 KB0.61 ms 1.14x 296.0 KB0.53 ms 1x 348.5 KB
read-used-range2500 rows - read - Range and table read - speed-comparisonSylvan.Data.Excel4.67 ms52.00 ms 11.1x 16.4 MB37.20 ms 7.97x 19.7 MB-10.48 ms 2.25x 5.9 MB-12.41 ms 2.66x 18.2 MB13.46 ms 2.88x 3.4 MB4.67 ms 1x 655.2 KB
read-bottom-range-stream2500 rows - read - Streaming read - speed-comparisonOfficeIMO.Excel3.53 ms28.47 ms 8.06x 15.0 MB24.50 ms 6.93x 12.1 MB-10.07 ms 2.85x 5.9 MB-12.40 ms 3.51x 18.2 MB3.53 ms 1x 377.8 KB4.00 ms 1.13x 655.2 KB
read-range-stream2500 rows - read - Streaming read - speed-comparisonSylvan.Data.Excel4.51 ms32.20 ms 7.14x 16.3 MB30.90 ms 6.86x 19.7 MB31.47 ms 6.98x 0 B12.22 ms 2.71x 5.9 MB-13.20 ms 2.93x 18.2 MB5.94 ms 1.32x 2.7 MB4.51 ms 1x 655.2 KB
read-top-range-stream2500 rows - read - Streaming read - speed-comparisonSylvan.Data.Excel0.42 ms29.86 ms 71.3x 15.0 MB24.44 ms 58.4x 12.1 MB28.84 ms 68.9x 0 B4.63 ms 11.1x 1.9 MB-0.74 ms 1.77x 869.0 KB0.53 ms 1.27x 299.4 KB0.42 ms 1x 348.5 KB
read-top-range-stream-small-chunks2500 rows - read - Streaming read - speed-comparisonSylvan.Data.Excel0.42 ms30.94 ms 74.1x 15.0 MB26.20 ms 62.7x 12.1 MB-5.22 ms 12.5x 1.9 MB-0.87 ms 2.09x 869.0 KB0.67 ms 1.62x 300.1 KB0.42 ms 1x 348.5 KB
read-objects2500 rows - read - Typed object read - speed-comparisonOfficeIMO.Excel13.24 ms67.44 ms 5.10x 16.5 MB49.69 ms 3.75x 20.9 MB31.66 ms 2.39x 0 B40.24 ms 3.04x 6.2 MB-44.25 ms 3.34x 18.0 MB13.24 ms 1x 2.4 MB18.49 ms 1.40x 895.3 KB
read-objects-stream2500 rows - read - Typed object read - speed-comparisonOfficeIMO.Excel7.59 ms50.37 ms 6.63x 16.5 MB43.60 ms 5.74x 20.8 MB28.45 ms 3.75x 0 B15.25 ms 2.01x 6.1 MB-19.76 ms 2.60x 18.0 MB7.59 ms 1x 2.4 MB8.39 ms 1.11x 831.0 KB
write-datareader-table-autofit2500 rows - write - AutoFit and mutation - speed-comparisonOfficeIMO.Excel7.58 ms165.11 ms 21.8x 57.0 MB59.00 ms 7.79x 37.4 MB78.02 ms 10.3x 0 B--9.51 ms 1.26x 26.0 MB7.58 ms 1x 1.7 MB-
write-dataset-tables-autofit2500 rows - write - AutoFit and mutation - speed-comparisonOfficeIMO.Excel5.97 ms182.55 ms 30.6x 55.4 MB151.95 ms 25.5x 42.4 MB---15.95 ms 2.67x 31.1 MB5.97 ms 1x 2.0 MB-
write-insertobjects-autofitcolumnsfor-direct2500 rows - write - AutoFit and mutation - speed-comparisonOfficeIMO.Excel15.06 ms118.60 ms 7.87x 49.7 MB85.75 ms 5.69x 37.4 MB----15.06 ms 1x 1.3 MB-
write-insertobjects-flat-dictionaries-autofitcolumnsfor-direct2500 rows - write - AutoFit and mutation - speed-comparisonOfficeIMO.Excel7.52 ms95.09 ms 12.6x 49.7 MB70.60 ms 9.39x 37.4 MB----7.52 ms 1x 1.5 MB-
write-insertobjects-partial-autofitcolumnsfor-direct2500 rows - write - AutoFit and mutation - speed-comparisonOfficeIMO.Excel7.62 ms71.20 ms 9.35x 27.9 MB78.97 ms 10.4x 26.7 MB----7.62 ms 1x 1.3 MB-
write-cellvalue-empty-strings2500 rows - write - Cell writer - speed-comparisonOfficeIMO.Excel2.63 ms15.57 ms 5.92x 9.7 MB22.53 ms 8.57x 11.5 MB----2.63 ms 1x 1.7 MB-
write-cellvalue-numbers2500 rows - write - Cell writer - speed-comparisonOfficeIMO.Excel3.20 ms12.05 ms 3.76x 9.0 MB25.62 ms 8.00x 12.6 MB17.22 ms 5.38x 0 B---3.20 ms 1x 1.1 MB-
write-cellvalue-object-mixed2500 rows - write - Cell writer - speed-comparisonOfficeIMO.Excel3.41 ms17.03 ms 5.00x 11.6 MB27.64 ms 8.12x 15.3 MB17.30 ms 5.08x 0 B---3.41 ms 1x 1.7 MB-
write-cellvalue-object-sparse2500 rows - write - Cell writer - speed-comparisonOfficeIMO.Excel3.72 ms15.37 ms 4.13x 11.0 MB28.52 ms 7.66x 14.6 MB----3.72 ms 1x 1.5 MB-
write-cellvalue-object-sparse-batch2500 rows - write - Cell writer - speed-comparisonOfficeIMO.Excel3.08 ms15.05 ms 4.89x 11.0 MB26.93 ms 8.75x 14.6 MB----3.08 ms 1x 1.5 MB-
write-cellvalue-scalars2500 rows - write - Cell writer - speed-comparisonOfficeIMO.Excel2.57 ms12.12 ms 4.71x 8.8 MB25.37 ms 9.87x 12.5 MB15.86 ms 6.17x 0 B---2.57 ms 1x 1.1 MB-
write-cellvalue-temporal2500 rows - write - Cell writer - speed-comparisonOfficeIMO.Excel3.64 ms17.89 ms 4.91x 9.5 MB29.04 ms 7.98x 14.4 MB17.59 ms 4.83x 0 B---3.64 ms 1x 1.4 MB-
write-dataset-headerless-tables2500 rows - write - DataSet table export - speed-comparisonOfficeIMO.Excel4.95 ms66.79 ms 13.5x 18.5 MB101.58 ms 20.5x 18.0 MB---14.88 ms 3.01x 28.5 MB4.95 ms 1x 2.0 MB-
write-dataset-sparse-tables2500 rows - write - DataSet table export - speed-comparisonOfficeIMO.Excel7.34 ms93.18 ms 12.7x 26.8 MB105.75 ms 14.4x 22.1 MB---19.25 ms 2.62x 29.8 MB7.34 ms 1x 2.8 MB-
write-dataset-tables2500 rows - write - DataSet table export - speed-comparisonOfficeIMO.Excel5.55 ms63.06 ms 11.4x 18.4 MB70.75 ms 12.8x 19.0 MB54.07 ms 9.75x 0 B--13.89 ms 2.50x 28.0 MB5.55 ms 1x 2.0 MB-
write-datareader-table2500 rows - write - DataTable table export - speed-comparisonOfficeIMO.Excel4.67 ms38.22 ms 8.18x 18.6 MB44.60 ms 9.55x 16.3 MB39.58 ms 8.47x 0 B--8.66 ms 1.85x 22.5 MB4.67 ms 1x 1.7 MB-
write-datatable-direct2500 rows - write - DataTable table export - speed-comparisonOfficeIMO.Excel7.70 ms37.21 ms 4.83x 11.3 MB43.91 ms 5.70x 16.3 MB45.86 ms 5.95x 0 B-7.97 ms 1.03x 1.1 MB10.21 ms 1.33x 22.5 MB7.70 ms 1x 1.7 MB-
write-datatable-object-table-direct2500 rows - write - DataTable table export - speed-comparisonOfficeIMO.Excel5.28 ms41.38 ms 7.83x 18.3 MB46.89 ms 8.88x 16.0 MB---11.52 ms 2.18x 22.3 MB5.28 ms 1x 1.5 MB-
write-datatable-table-direct2500 rows - write - DataTable table export - speed-comparisonOfficeIMO.Excel4.80 ms49.33 ms 10.3x 18.6 MB48.37 ms 10.1x 16.3 MB42.21 ms 8.80x 0 B--10.10 ms 2.11x 22.5 MB4.80 ms 1x 1.7 MB-
write-bulk-report2500 rows - write - Formatted report write - speed-comparisonOfficeIMO.Excel5.80 ms219.04 ms 37.7x 57.0 MB127.91 ms 22.0x 48.0 MB104.37 ms 18.0x 0 B--13.37 ms 2.30x 26.2 MB5.80 ms 1x 1.4 MB-
write-cellformula2500 rows - write - Formula write/read - speed-comparisonOfficeIMO.Excel4.36 ms26.18 ms 6.01x 11.8 MB51.94 ms 11.9x 17.7 MB19.69 ms 4.52x 0 B---4.36 ms 1x 1.6 MB-
write-dictionary-objects-table-direct2500 rows - write - Other - speed-comparisonOfficeIMO.Excel7.13 ms------7.13 ms 1x 2.0 MB-
write-powershell-mixed-objects-direct2500 rows - write - Other - speed-comparisonLargeXlsx4.54 ms49.04 ms 10.8x 16.6 MB59.34 ms 13.1x 19.6 MB--4.54 ms 1x 802.5 KB9.72 ms 2.14x 24.6 MB6.04 ms 1.33x 2.3 MB-
write-powershell-psobject-mixed-direct2500 rows - write - Other - speed-comparisonLargeXlsx4.85 ms66.92 ms 13.8x 16.6 MB71.05 ms 14.6x 19.6 MB--4.85 ms 1x 802.5 KB14.01 ms 2.89x 24.6 MB6.71 ms 1.38x 1.5 MB-
write-powershell-psobject-wide-direct2500 rows - write - Other - speed-comparisonOfficeIMO.Excel22.25 ms128.12 ms 5.76x 50.4 MB176.60 ms 7.94x 67.5 MB--41.84 ms 1.88x 2.7 MB55.69 ms 2.50x 47.3 MB22.25 ms 1x 4.4 MB-
append-plain-rows2500 rows - write - Plain cell export - speed-comparisonLargeXlsx1.66 ms15.74 ms 9.46x 10.9 MB28.16 ms 16.9x 14.0 MB16.50 ms 9.92x 0 B-1.66 ms 1x 296.4 KB4.91 ms 2.95x 19.2 MB2.71 ms 1.63x 1.5 MB-
write-cellvalues-headerless-rectangle-direct2500 rows - write - Plain cell export - speed-comparisonLargeXlsx1.43 ms17.27 ms 12.1x 10.0 MB24.65 ms 17.2x 12.7 MB--1.43 ms 1x 447.0 KB-1.72 ms 1.20x 1.1 MB-
write-cellvalues-rectangle-direct2500 rows - write - Plain cell export - speed-comparisonOfficeIMO.Excel4.25 ms33.28 ms 7.84x 21.7 MB43.02 ms 10.1x 24.1 MB35.40 ms 8.33x 0 B-4.67 ms 1.10x 758.3 KB9.25 ms 2.18x 22.7 MB4.25 ms 1x 2.0 MB-
write-cellvalues-sparse-rectangle-direct2500 rows - write - Plain cell export - speed-comparisonOfficeIMO.Excel2.46 ms15.15 ms 6.17x 11.0 MB26.15 ms 10.6x 14.6 MB----2.46 ms 1x 1.5 MB-
write-datareader-plain2500 rows - write - Plain streaming export - speed-comparisonSylvan.Data.Excel4.70 ms28.01 ms 5.96x 11.3 MB37.06 ms 7.88x 16.3 MB32.76 ms 6.97x 0 B-8.72 ms 1.85x 1.0 MB9.95 ms 2.11x 22.5 MB4.84 ms 1.03x 1.7 MB4.70 ms 1x 758.6 KB
write-dataset-sparse-direct-export2500 rows - write - Plain streaming export - speed-comparisonOfficeIMO.Excel7.33 ms89.91 ms 12.3x 26.8 MB70.09 ms 9.57x 21.8 MB--13.53 ms 1.85x 1.1 MB18.08 ms 2.47x 29.7 MB7.33 ms 1x 2.1 MB-
write-blog-2023-20-string-columns2500 rows - write - Plain string export - speed-comparisonLargeXlsx4.31 ms88.92 ms 20.6x 69.8 MB---4.31 ms 1x 857.6 KB16.45 ms 3.82x 35.1 MB4.45 ms 1.03x 1.6 MB-
large-shared-strings2500 rows - write - Shared string write - speed-comparisonOfficeIMO.Excel2.05 ms12.83 ms 6.27x 11.0 MB25.40 ms 12.4x 12.5 MB14.14 ms 6.91x 0 B--3.97 ms 1.94x 20.6 MB2.05 ms 1x 2.4 MB-
write-cellvalue-strings2500 rows - write - Shared string write - speed-comparisonOfficeIMO.Excel2.85 ms11.80 ms 4.14x 11.0 MB23.73 ms 8.32x 12.5 MB17.38 ms 6.10x 0 B---2.85 ms 1x 2.6 MB-
write-cellvalue-strings-distinct2500 rows - write - Shared string write - speed-comparisonOfficeIMO.Excel2.50 ms14.40 ms 5.75x 12.8 MB23.43 ms 9.36x 13.6 MB----2.50 ms 1x 2.3 MB-
write-cellvalue-strings-repeated2500 rows - write - Shared string write - speed-comparisonOfficeIMO.Excel2.06 ms12.47 ms 6.04x 9.0 MB23.44 ms 11.4x 11.1 MB----2.06 ms 1x 1.5 MB-
write-fluent-rowsfrom-direct2500 rows - write - Typed object export - speed-comparisonLargeXlsx3.38 ms30.22 ms 8.94x 11.3 MB39.29 ms 11.6x 16.3 MB37.16 ms 11.0x 0 B-3.38 ms 1x 758.3 KB8.36 ms 2.47x 22.7 MB4.14 ms 1.23x 1.7 MB-
write-insertobjects-direct2500 rows - write - Typed object export - speed-comparisonLargeXlsx4.09 ms59.53 ms 14.5x 11.3 MB64.43 ms 15.7x 16.3 MB35.44 ms 8.65x 0 B-4.09 ms 1x 758.3 KB11.66 ms 2.85x 22.7 MB5.91 ms 1.44x 1.3 MB-
write-insertobjects-flat-dictionaries-direct2500 rows - write - Typed object export - speed-comparisonLargeXlsx4.94 ms40.65 ms 8.23x 11.3 MB58.71 ms 11.9x 16.3 MB--4.94 ms 1x 758.3 KB16.89 ms 3.42x 22.7 MB7.23 ms 1.46x 1.5 MB-
write-blog-2023-20-string-columns10000 rows - package - Package size - focused-package-profileOfficeIMO.Excel33.01 ms725.30 ms 22.0x 1,015.4 KB---88.91 ms 2.69x 970.2 KB142.47 ms 4.32x 957.6 KB33.01 ms 1x 880.4 KB-
autofit-existing25000 rows - mutate - AutoFit and mutation - speed-comparisonOfficeIMO.Excel85.60 ms1.46 s 17.1x 810.3 MB460.13 ms 5.38x 245.1 MB779.69 ms 9.11x 0 B---85.60 ms 1x 15.3 MB-
realworld-report-no-autofit25000 rows - mutate - AutoFit and mutation - speed-comparisonOfficeIMO.Excel234.38 ms-405.18 ms 1.73x 229.3 MB307.49 ms 1.31x 0 B---234.38 ms 1x 141.7 MB-
realworld-report-chart-first25000 rows - other - Anti-cheat report variants - speed-comparisonOfficeIMO.Excel93.06 ms-434.66 ms 4.67x 270.6 MB595.63 ms 6.40x 0 B---93.06 ms 1x 54.0 MB-
realworld-report-extra-column25000 rows - other - Anti-cheat report variants - speed-comparisonOfficeIMO.Excel356.27 ms-528.93 ms 1.48x 295.7 MB1.02 s 2.85x 0 B---356.27 ms 1x 153.2 MB-
realworld-report-post-mutation25000 rows - other - Anti-cheat report variants - speed-comparisonOfficeIMO.Excel320.89 ms-515.92 ms 1.61x 270.6 MB804.51 ms 2.51x 0 B---320.89 ms 1x 141.7 MB-
realworld-report-shuffled-columns25000 rows - other - Anti-cheat report variants - speed-comparisonOfficeIMO.Excel253.35 ms-463.37 ms 1.83x 270.6 MB622.17 ms 2.46x 0 B---253.35 ms 1x 141.8 MB-
build-object-datatable-dictionaries25000 rows - other - Object projection - speed-comparisonOfficeIMO.Excel8.95 ms------8.95 ms 1x 5.0 MB-
build-object-datatable-typed25000 rows - other - Object projection - speed-comparisonOfficeIMO.Excel8.15 ms------8.15 ms 1x 7.9 MB-
enumerate-cells25000 rows - other - Range and table read - speed-comparisonOfficeIMO.Excel52.17 ms348.65 ms 6.68x 162.6 MB267.12 ms 5.12x 183.0 MB----52.17 ms 1x 24.0 MB-
enumerate-first-column-from-wide-sheet25000 rows - other - Range and table read - speed-comparisonOfficeIMO.Excel35.19 ms309.41 ms 8.79x 147.4 MB227.30 ms 6.46x 112.8 MB----35.19 ms 1x 3.8 MB-
enumerate-range25000 rows - other - Range and table read - speed-comparisonOfficeIMO.Excel49.51 ms359.43 ms 7.26x 162.6 MB279.89 ms 5.65x 183.0 MB----49.51 ms 1x 24.0 MB-
enumerate-top-range25000 rows - other - Range and table read - speed-comparisonOfficeIMO.Excel0.61 ms331.90 ms 546x 145.9 MB226.94 ms 373x 103.1 MB----0.61 ms 1x 285.3 KB-
realworld-autofilter25000 rows - other - Real-world feature mix - speed-comparisonOfficeIMO.Excel43.12 ms394.06 ms 9.14x 205.7 MB433.24 ms 10.0x 206.9 MB336.57 ms 7.81x 0 B---43.12 ms 1x 11.2 MB-
realworld-charts25000 rows - other - Real-world feature mix - speed-comparisonOfficeIMO.Excel44.45 ms-452.20 ms 10.2x 209.9 MB288.53 ms 6.49x 0 B---44.45 ms 1x 12.3 MB-
realworld-conditional-formatting25000 rows - other - Real-world feature mix - speed-comparisonOfficeIMO.Excel42.96 ms373.78 ms 8.70x 205.8 MB430.02 ms 10.0x 206.9 MB305.31 ms 7.11x 0 B---42.96 ms 1x 11.3 MB-
realworld-data-validation25000 rows - other - Real-world feature mix - speed-comparisonOfficeIMO.Excel43.52 ms367.24 ms 8.44x 205.7 MB428.36 ms 9.84x 206.9 MB291.80 ms 6.71x 0 B---43.52 ms 1x 11.2 MB-
realworld-freeze-panes25000 rows - other - Real-world feature mix - speed-comparisonOfficeIMO.Excel41.39 ms382.25 ms 9.24x 205.7 MB458.18 ms 11.1x 206.9 MB317.32 ms 7.67x 0 B---41.39 ms 1x 11.2 MB-
realworld-pivot-table25000 rows - other - Real-world feature mix - speed-comparisonEPPlus 4.5.3.3295.79 ms-464.34 ms 1.57x 225.4 MB295.79 ms 1x 0 B---299.58 ms 1.01x 140.3 MB-
realworld-report-all-in-one25000 rows - other - Real-world report - speed-comparisonOfficeIMO.Excel226.59 ms-435.10 ms 1.92x 270.6 MB644.05 ms 2.84x 0 B---226.59 ms 1x 141.7 MB-
realworld-report-core25000 rows - other - Real-world report - speed-comparisonOfficeIMO.Excel46.34 ms1.04 s 22.5x 664.2 MB471.30 ms 10.2x 249.1 MB736.59 ms 15.9x 0 B---46.34 ms 1x 11.4 MB-
report-workbook25000 rows - other - Report workbook - speed-comparisonOfficeIMO.Excel342.77 ms-571.24 ms 1.67x 356.2 MB841.42 ms 2.45x 0 B---342.77 ms 1x 191.7 MB-
report-workbook-core25000 rows - other - Report workbook - speed-comparisonOfficeIMO.Excel51.45 ms1.19 s 23.0x 952.9 MB563.86 ms 11.0x 334.8 MB857.15 ms 16.7x 0 B---51.45 ms 1x 10.7 MB-
report-workbook-datatable25000 rows - other - Report workbook - speed-comparisonOfficeIMO.Excel334.91 ms-560.46 ms 1.67x 242.0 MB854.84 ms 2.55x 0 B---334.91 ms 1x 194.4 MB-
report-workbook-datatable-core25000 rows - other - Report workbook - speed-comparisonOfficeIMO.Excel50.73 ms1.06 s 20.8x 812.7 MB527.51 ms 10.4x 220.7 MB872.50 ms 17.2x 0 B---50.73 ms 1x 13.4 MB-
append-plain-rows25000 rows - package - Package size - package-profileLargeXlsx14.33 ms163.87 ms 11.4x 540.6 KB244.50 ms 17.1x 525.6 KB--14.33 ms 1x 605.0 KB36.40 ms 2.54x 642.3 KB20.45 ms 1.43x 610.4 KB-
autofit-existing25000 rows - package - Package size - package-profileOfficeIMO.Excel92.81 ms1.78 s 19.2x 1.1 MB594.57 ms 6.41x 1.1 MB----92.81 ms 1x 1.4 MB-
large-shared-strings25000 rows - package - Package size - package-profileOfficeIMO.Excel20.06 ms160.95 ms 8.02x 460.1 KB283.73 ms 14.1x 444.7 KB---39.29 ms 1.96x 581.0 KB20.06 ms 1x 529.7 KB-
realworld-autofilter25000 rows - package - Package size - package-profileOfficeIMO.Excel43.84 ms398.52 ms 9.09x 1.1 MB477.44 ms 10.9x 1.1 MB----43.84 ms 1x 1.4 MB-
realworld-charts25000 rows - package - Package size - package-profileOfficeIMO.Excel45.87 ms-513.82 ms 11.2x 1.1 MB----45.87 ms 1x 1.4 MB-
realworld-conditional-formatting25000 rows - package - Package size - package-profileOfficeIMO.Excel42.72 ms401.24 ms 9.39x 1.1 MB522.13 ms 12.2x 1.1 MB----42.72 ms 1x 1.4 MB-
realworld-data-validation25000 rows - package - Package size - package-profileOfficeIMO.Excel42.86 ms383.78 ms 8.95x 1.1 MB527.65 ms 12.3x 1.1 MB----42.86 ms 1x 1.4 MB-
realworld-freeze-panes25000 rows - package - Package size - package-profileOfficeIMO.Excel42.53 ms395.05 ms 9.29x 1.1 MB463.69 ms 10.9x 1.1 MB----42.53 ms 1x 1.4 MB-
realworld-pivot-table25000 rows - package - Package size - package-profileOfficeIMO.Excel411.32 ms-602.49 ms 1.46x 1.1 MB----411.32 ms 1x 1.9 MB-
realworld-report-all-in-one25000 rows - package - Package size - package-profileOfficeIMO.Excel307.01 ms-527.21 ms 1.72x 1.1 MB----307.01 ms 1x 1.9 MB-
realworld-report-chart-first25000 rows - package - Package size - package-profileOfficeIMO.Excel119.04 ms-535.98 ms 4.50x 1.1 MB----119.04 ms 1x 1.9 MB-
realworld-report-core25000 rows - package - Package size - package-profileOfficeIMO.Excel46.76 ms1.09 s 23.3x 1.1 MB516.28 ms 11.0x 1.1 MB----46.76 ms 1x 1.4 MB-
realworld-report-extra-column25000 rows - package - Package size - package-profileOfficeIMO.Excel325.78 ms-572.39 ms 1.76x 1.1 MB----325.78 ms 1x 2.1 MB-
realworld-report-no-autofit25000 rows - package - Package size - package-profileOfficeIMO.Excel320.07 ms-498.50 ms 1.56x 1.1 MB----320.07 ms 1x 1.9 MB-
realworld-report-post-mutation25000 rows - package - Package size - package-profileOfficeIMO.Excel336.55 ms-564.93 ms 1.68x 1.1 MB----336.55 ms 1x 1.9 MB-
realworld-report-shuffled-columns25000 rows - package - Package size - package-profileOfficeIMO.Excel325.90 ms-537.19 ms 1.65x 1.1 MB----325.90 ms 1x 2.0 MB-
report-workbook25000 rows - package - Package size - package-profileOfficeIMO.Excel443.58 ms-711.76 ms 1.60x 1.5 MB----443.58 ms 1x 2.6 MB-
report-workbook-core25000 rows - package - Package size - package-profileOfficeIMO.Excel63.24 ms1.45 s 22.9x 1.5 MB673.99 ms 10.7x 1.5 MB----63.24 ms 1x 1.8 MB-
report-workbook-datatable25000 rows - package - Package size - package-profileOfficeIMO.Excel467.76 ms-710.89 ms 1.52x 1.5 MB----467.76 ms 1x 2.6 MB-
report-workbook-datatable-core25000 rows - package - Package size - package-profileOfficeIMO.Excel76.78 ms1.42 s 18.5x 1.5 MB678.16 ms 8.83x 1.5 MB----76.78 ms 1x 1.8 MB-
write-blog-2023-20-string-columns25000 rows - package - Package size - package-profileLargeXlsx55.09 ms1.19 s 21.5x 2.5 MB---55.09 ms 1x 2.4 MB199.36 ms 3.62x 2.4 MB62.30 ms 1.13x 2.2 MB-
write-bulk-report25000 rows - package - Package size - package-profileOfficeIMO.Excel41.76 ms1.02 s 24.5x 1.1 MB507.40 ms 12.2x 1.1 MB---100.58 ms 2.41x 1.5 MB41.76 ms 1x 1.4 MB-
write-cellformula25000 rows - package - Package size - package-profileOfficeIMO.Excel31.55 ms266.92 ms 8.46x 643.2 KB443.25 ms 14.1x 593.9 KB----31.55 ms 1x 670.3 KB-
write-cellvalue-empty-strings25000 rows - package - Package size - package-profileOfficeIMO.Excel16.17 ms154.30 ms 9.54x 398.1 KB205.95 ms 12.7x 390.6 KB----16.17 ms 1x 451.4 KB-
write-cellvalue-numbers25000 rows - package - Package size - package-profileOfficeIMO.Excel17.61 ms143.04 ms 8.12x 411.4 KB231.65 ms 13.2x 406.5 KB----17.61 ms 1x 462.6 KB-
write-cellvalue-object-mixed25000 rows - package - Package size - package-profileOfficeIMO.Excel22.69 ms206.68 ms 9.11x 532.9 KB267.33 ms 11.8x 544.3 KB----22.69 ms 1x 585.1 KB-
write-cellvalue-object-sparse25000 rows - package - Package size - package-profileOfficeIMO.Excel25.91 ms181.20 ms 6.99x 468.0 KB258.58 ms 9.98x 494.4 KB----25.91 ms 1x 607.1 KB-
write-cellvalue-object-sparse-batch25000 rows - package - Package size - package-profileOfficeIMO.Excel24.04 ms204.65 ms 8.51x 468.0 KB291.04 ms 12.1x 494.4 KB----24.04 ms 1x 607.1 KB-
write-cellvalue-scalars25000 rows - package - Package size - package-profileOfficeIMO.Excel15.41 ms126.06 ms 8.18x 394.9 KB226.89 ms 14.7x 379.3 KB----15.41 ms 1x 441.9 KB-
write-cellvalue-strings25000 rows - package - Package size - package-profileOfficeIMO.Excel21.93 ms149.89 ms 6.84x 460.1 KB227.21 ms 10.4x 444.7 KB----21.93 ms 1x 527.8 KB-
write-cellvalue-strings-distinct25000 rows - package - Package size - package-profileOfficeIMO.Excel17.75 ms202.70 ms 11.4x 555.3 KB264.92 ms 14.9x 565.1 KB----17.75 ms 1x 499.0 KB-
write-cellvalue-strings-repeated25000 rows - package - Package size - package-profileOfficeIMO.Excel16.46 ms132.97 ms 8.08x 331.8 KB192.12 ms 11.7x 300.8 KB----16.46 ms 1x 376.0 KB-
write-cellvalue-temporal25000 rows - package - Package size - package-profileOfficeIMO.Excel28.28 ms193.06 ms 6.83x 483.0 KB248.15 ms 8.78x 495.1 KB----28.28 ms 1x 620.5 KB-
write-cellvalues-headerless-rectangle-direct25000 rows - package - Package size - package-profileLargeXlsx12.59 ms163.44 ms 13.0x 467.5 KB236.59 ms 18.8x 484.1 KB--12.59 ms 1x 443.4 KB-14.67 ms 1.17x 455.5 KB-
write-cellvalues-rectangle-direct25000 rows - package - Package size - package-profileLargeXlsx38.15 ms417.65 ms 10.9x 1.1 MB502.29 ms 13.2x 1.1 MB--38.15 ms 1x 1.4 MB94.53 ms 2.48x 1.5 MB46.60 ms 1.22x 1.4 MB-
write-datareader-plain25000 rows - package - Package size - package-profileSylvan.Data.Excel40.07 ms466.33 ms 11.6x 1.1 MB512.75 ms 12.8x 1.1 MB--71.81 ms 1.79x 1.4 MB111.30 ms 2.78x 1.5 MB58.95 ms 1.47x 1.4 MB40.07 ms 1x 755.4 KB
write-datareader-table25000 rows - package - Package size - package-profileOfficeIMO.Excel46.01 ms492.09 ms 10.7x 1.1 MB468.99 ms 10.2x 1.1 MB---93.22 ms 2.03x 1.5 MB46.01 ms 1x 1.4 MB-
write-datareader-table-autofit25000 rows - package - Package size - package-profileOfficeIMO.Excel55.69 ms1.09 s 19.6x 1.1 MB466.75 ms 8.38x 1.1 MB---103.68 ms 1.86x 1.5 MB55.69 ms 1x 1.4 MB-
write-dataset-sparse-direct-export25000 rows - package - Package size - package-profileOfficeIMO.Excel42.31 ms679.04 ms 16.1x 1.5 MB590.56 ms 14.0x 1.4 MB--48.29 ms 1.14x 1.6 MB120.23 ms 2.84x 1.8 MB42.31 ms 1x 1.3 MB-
write-dataset-sparse-tables25000 rows - package - Package size - package-profileOfficeIMO.Excel49.85 ms712.67 ms 14.3x 1.5 MB592.86 ms 11.9x 1.4 MB---123.98 ms 2.49x 1.8 MB49.85 ms 1x 1.8 MB-
write-dataset-tables25000 rows - package - Package size - package-profileOfficeIMO.Excel49.25 ms478.62 ms 9.72x 1.1 MB416.33 ms 8.45x 1.1 MB---108.39 ms 2.20x 1.5 MB49.25 ms 1x 1.3 MB-
write-dataset-tables-autofit25000 rows - package - Package size - package-profileOfficeIMO.Excel69.82 ms1.23 s 17.7x 1.1 MB643.58 ms 9.22x 1.1 MB---131.66 ms 1.89x 1.5 MB69.82 ms 1x 1.3 MB-
write-datatable-direct25000 rows - package - Package size - package-profileLargeXlsx39.84 ms340.09 ms 8.54x 1.1 MB387.77 ms 9.73x 1.1 MB--39.84 ms 1x 1.4 MB97.14 ms 2.44x 1.5 MB43.62 ms 1.09x 1.4 MB-
write-datatable-table-direct25000 rows - package - Package size - package-profileOfficeIMO.Excel46.22 ms499.93 ms 10.8x 1.1 MB420.29 ms 9.09x 1.1 MB---113.39 ms 2.45x 1.5 MB46.22 ms 1x 1.4 MB-
write-fluent-rowsfrom-direct25000 rows - package - Package size - package-profileLargeXlsx32.53 ms339.85 ms 10.4x 1.1 MB390.85 ms 12.0x 1.1 MB--32.53 ms 1x 1.4 MB84.91 ms 2.61x 1.5 MB41.97 ms 1.29x 1.4 MB-
write-insertobjects-autofitcolumnsfor-direct25000 rows - package - Package size - package-profileOfficeIMO.Excel54.71 ms994.61 ms 18.2x 1.1 MB629.14 ms 11.5x 1.1 MB----54.71 ms 1x 1.4 MB-
write-insertobjects-direct25000 rows - package - Package size - package-profileLargeXlsx35.13 ms364.78 ms 10.4x 1.1 MB435.73 ms 12.4x 1.1 MB--35.13 ms 1x 1.4 MB89.61 ms 2.55x 1.5 MB42.85 ms 1.22x 1.4 MB-
write-insertobjects-flat-dictionaries-autofitcolumnsfor-direct25000 rows - package - Package size - package-profileOfficeIMO.Excel59.48 ms926.61 ms 15.6x 1.1 MB477.41 ms 8.03x 1.1 MB----59.48 ms 1x 1.4 MB-
write-insertobjects-flat-dictionaries-direct25000 rows - package - Package size - package-profileLargeXlsx36.21 ms345.72 ms 9.55x 1.1 MB424.55 ms 11.7x 1.1 MB--36.21 ms 1x 1.4 MB84.91 ms 2.34x 1.5 MB51.95 ms 1.43x 1.4 MB-
write-insertobjects-legacy-dictionaries-direct25000 rows - package - Package size - package-profileLargeXlsx38.66 ms348.79 ms 9.02x 1.1 MB422.81 ms 10.9x 1.1 MB--38.66 ms 1x 1.4 MB90.62 ms 2.34x 1.5 MB62.41 ms 1.61x 1.4 MB-
write-insertobjects-partial-autofitcolumnsfor-direct25000 rows - package - Package size - package-profileOfficeIMO.Excel46.77 ms545.26 ms 11.7x 1.1 MB424.52 ms 9.08x 1.1 MB----46.77 ms 1x 1.4 MB-
write-powershell-mixed-objects-direct25000 rows - package - Package size - package-profileLargeXlsx51.04 ms488.96 ms 9.58x 1.5 MB556.52 ms 10.9x 1.4 MB--51.04 ms 1x 1.8 MB109.78 ms 2.15x 1.9 MB57.93 ms 1.14x 1.8 MB-
write-powershell-psobject-mixed-direct25000 rows - package - Package size - package-profileLargeXlsx49.15 ms473.38 ms 9.63x 1.5 MB538.07 ms 10.9x 1.4 MB--49.15 ms 1x 1.8 MB108.65 ms 2.21x 1.9 MB54.45 ms 1.11x 1.8 MB-
write-powershell-psobject-wide-direct25000 rows - package - Package size - package-profileOfficeIMO.Excel271.73 ms1.45 s 5.35x 6.0 MB1.87 s 6.88x 5.3 MB--275.39 ms 1.01x 6.5 MB454.22 ms 1.67x 6.8 MB271.73 ms 1x 6.6 MB-
formula-heavy-read25000 rows - read - Formula write/read - speed-comparisonOfficeIMO.Excel28.98 ms235.57 ms 8.13x 77.6 MB193.07 ms 6.66x 69.2 MB97.60 ms 3.37x 0 B---28.98 ms 1x 6.1 MB-
dense-helloworld-read-range25000 rows - read - Other - dense-helloworld-comparisonSylvan.Data.Excel61.06 ms---162.93 ms 2.67x 67.9 MB-217.43 ms 3.56x 210.3 MB73.99 ms 1.21x 23.1 MB61.06 ms 1x 394.1 KB
dense-helloworld-read-stream25000 rows - read - Other - dense-helloworld-comparisonSylvan.Data.Excel66.62 ms---194.35 ms 2.92x 67.9 MB-244.62 ms 3.67x 210.3 MB68.98 ms 1.04x 23.8 MB66.62 ms 1x 394.1 KB
large-sparse-column-read25000 rows - read - Other - speed-comparisonOfficeIMO.Excel0.86 ms3.71 ms 4.31x 4.3 MB101.17 ms 117x 42.1 MB28.10 ms 32.6x 0 B1.45 ms 1.69x 4.0 MB-13.56 ms 15.7x 45.1 MB0.86 ms 1x 177.5 KB1.22 ms 1.42x 316.6 KB
large-sparse-row-read25000 rows - read - Other - speed-comparisonOfficeIMO.Excel0.86 ms4.16 ms 4.81x 4.3 MB95.81 ms 111x 42.1 MB27.99 ms 32.4x 0 B1.76 ms 2.04x 4.0 MB-13.58 ms 15.7x 45.1 MB0.86 ms 1x 177.6 KB1.04 ms 1.20x 316.6 KB
shared-string-read25000 rows - read - Other - speed-comparisonSylvan.Data.Excel26.16 ms219.18 ms 8.38x 88.3 MB183.69 ms 7.02x 87.3 MB111.48 ms 4.26x 0 B62.56 ms 2.39x 24.4 MB-64.67 ms 2.47x 72.7 MB31.30 ms 1.20x 9.0 MB26.16 ms 1x 1.9 MB
read-bottom-range25000 rows - read - Range and table read - speed-comparisonOfficeIMO.Excel32.46 ms317.74 ms 9.79x 145.9 MB227.00 ms 6.99x 103.1 MB-104.17 ms 3.21x 59.8 MB-118.85 ms 3.66x 182.1 MB32.46 ms 1x 1.1 MB38.21 ms 1.18x 3.5 MB
read-datatable25000 rows - read - Range and table read - speed-comparisonSylvan.Data.Excel58.59 ms357.61 ms 6.10x 174.3 MB278.70 ms 4.76x 197.5 MB256.28 ms 4.37x 0 B140.43 ms 2.40x 74.3 MB-156.96 ms 2.68x 177.0 MB62.47 ms 1.07x 33.8 MB58.59 ms 1x 18.0 MB
read-first-column-from-wide-sheet25000 rows - read - Range and table read - speed-comparisonOfficeIMO.Excel36.67 ms328.79 ms 8.97x 147.4 MB237.72 ms 6.48x 112.8 MB-115.78 ms 3.16x 59.8 MB-97.14 ms 2.65x 154.9 MB36.67 ms 1x 3.9 MB49.37 ms 1.35x 4.2 MB
read-range25000 rows - read - Range and table read - speed-comparisonSylvan.Data.Excel43.73 ms336.19 ms 7.69x 159.8 MB257.22 ms 5.88x 183.0 MB260.85 ms 5.97x 0 B112.35 ms 2.57x 59.8 MB-123.08 ms 2.81x 182.1 MB52.68 ms 1.20x 25.5 MB43.73 ms 1x 3.5 MB
read-range-decimal25000 rows - read - Range and table read - speed-comparisonSylvan.Data.Excel51.66 ms366.96 ms 7.10x 159.8 MB270.08 ms 5.23x 183.0 MB-118.38 ms 2.29x 59.8 MB-135.67 ms 2.63x 182.1 MB54.25 ms 1.05x 26.1 MB51.66 ms 1x 4.4 MB
read-top-range25000 rows - read - Range and table read - speed-comparisonSylvan.Data.Excel0.51 ms331.00 ms 654x 145.9 MB244.03 ms 482x 103.1 MB193.50 ms 382x 0 B40.72 ms 80.4x 16.7 MB-0.79 ms 1.57x 869.0 KB0.57 ms 1.13x 296.0 KB0.51 ms 1x 348.5 KB
read-used-range25000 rows - read - Range and table read - speed-comparisonSylvan.Data.Excel45.12 ms346.12 ms 7.67x 159.8 MB273.40 ms 6.06x 183.0 MB-114.29 ms 2.53x 59.8 MB-127.39 ms 2.82x 182.1 MB86.94 ms 1.93x 33.4 MB45.12 ms 1x 3.5 MB
read-bottom-range-stream25000 rows - read - Streaming read - speed-comparisonOfficeIMO.Excel36.09 ms381.75 ms 10.6x 145.9 MB333.00 ms 9.23x 103.1 MB-132.34 ms 3.67x 59.8 MB-136.78 ms 3.79x 182.1 MB36.09 ms 1x 1.1 MB48.42 ms 1.34x 3.5 MB
read-range-stream25000 rows - read - Streaming read - speed-comparisonSylvan.Data.Excel45.35 ms350.82 ms 7.74x 159.8 MB257.52 ms 5.68x 183.0 MB211.23 ms 4.66x 0 B115.16 ms 2.54x 59.8 MB-123.80 ms 2.73x 182.1 MB51.84 ms 1.14x 26.3 MB45.35 ms 1x 3.5 MB
read-top-range-stream25000 rows - read - Streaming read - speed-comparisonSylvan.Data.Excel0.45 ms345.53 ms 762x 145.9 MB226.60 ms 500x 103.1 MB192.82 ms 425x 0 B42.43 ms 93.6x 16.7 MB-1.18 ms 2.61x 869.0 KB0.54 ms 1.20x 299.3 KB0.45 ms 1x 348.5 KB
read-top-range-stream-small-chunks25000 rows - read - Streaming read - speed-comparisonSylvan.Data.Excel0.43 ms358.96 ms 825x 145.9 MB346.90 ms 798x 103.1 MB-40.17 ms 92.3x 16.7 MB-0.72 ms 1.65x 869.0 KB0.54 ms 1.24x 300.1 KB0.43 ms 1x 348.5 KB
read-objects25000 rows - read - Typed object read - speed-comparisonSylvan.Data.Excel47.14 ms330.96 ms 7.02x 161.7 MB258.29 ms 5.48x 194.9 MB239.53 ms 5.08x 0 B114.10 ms 2.42x 62.0 MB-138.95 ms 2.95x 179.4 MB56.11 ms 1.19x 23.0 MB47.14 ms 1x 5.7 MB
read-objects-stream25000 rows - read - Typed object read - speed-comparisonOfficeIMO.Excel45.62 ms322.58 ms 7.07x 161.5 MB248.56 ms 5.45x 194.7 MB233.78 ms 5.12x 0 B107.50 ms 2.36x 61.5 MB-119.80 ms 2.63x 178.9 MB45.62 ms 1x 22.8 MB46.80 ms 1.03x 5.2 MB
write-datareader-table-autofit25000 rows - write - AutoFit and mutation - speed-comparisonOfficeIMO.Excel42.59 ms775.61 ms 18.2x 552.9 MB370.44 ms 8.70x 156.0 MB610.52 ms 14.3x 0 B--71.88 ms 1.69x 121.6 MB42.59 ms 1x 12.7 MB-
write-dataset-tables-autofit25000 rows - write - AutoFit and mutation - speed-comparisonOfficeIMO.Excel43.41 ms809.32 ms 18.6x 537.2 MB522.87 ms 12.0x 190.8 MB---89.68 ms 2.07x 125.9 MB43.41 ms 1x 10.1 MB-
write-insertobjects-autofitcolumnsfor-direct25000 rows - write - AutoFit and mutation - speed-comparisonOfficeIMO.Excel39.51 ms680.91 ms 17.2x 485.3 MB369.72 ms 9.36x 156.0 MB----39.51 ms 1x 11.2 MB-
write-insertobjects-flat-dictionaries-autofitcolumnsfor-direct25000 rows - write - AutoFit and mutation - speed-comparisonOfficeIMO.Excel42.96 ms736.55 ms 17.1x 485.3 MB399.61 ms 9.30x 156.0 MB----42.96 ms 1x 9.9 MB-
write-insertobjects-partial-autofitcolumnsfor-direct25000 rows - write - AutoFit and mutation - speed-comparisonOfficeIMO.Excel37.23 ms427.09 ms 11.5x 269.0 MB359.10 ms 9.65x 135.1 MB----37.23 ms 1x 11.2 MB-
write-cellvalue-empty-strings25000 rows - write - Cell writer - speed-comparisonOfficeIMO.Excel12.34 ms115.57 ms 9.36x 90.7 MB168.93 ms 13.7x 72.7 MB----12.34 ms 1x 6.7 MB-
write-cellvalue-numbers25000 rows - write - Cell writer - speed-comparisonOfficeIMO.Excel14.87 ms106.97 ms 7.20x 82.2 MB185.49 ms 12.5x 84.4 MB123.82 ms 8.33x 0 B---14.87 ms 1x 5.8 MB-
write-cellvalue-object-mixed25000 rows - write - Cell writer - speed-comparisonOfficeIMO.Excel17.26 ms169.43 ms 9.81x 108.5 MB216.54 ms 12.5x 110.6 MB152.59 ms 8.84x 0 B---17.26 ms 1x 8.1 MB-
write-cellvalue-object-sparse25000 rows - write - Cell writer - speed-comparisonOfficeIMO.Excel19.43 ms146.59 ms 7.55x 102.8 MB221.18 ms 11.4x 103.8 MB----19.43 ms 1x 7.2 MB-
write-cellvalue-object-sparse-batch25000 rows - write - Cell writer - speed-comparisonOfficeIMO.Excel17.85 ms146.67 ms 8.22x 102.8 MB222.85 ms 12.5x 103.8 MB----17.85 ms 1x 7.2 MB-
write-cellvalue-scalars25000 rows - write - Cell writer - speed-comparisonOfficeIMO.Excel10.97 ms103.62 ms 9.45x 80.7 MB180.24 ms 16.4x 83.1 MB126.15 ms 11.5x 0 B---10.97 ms 1x 6.0 MB-
write-cellvalue-temporal25000 rows - write - Cell writer - speed-comparisonOfficeIMO.Excel26.79 ms146.06 ms 5.45x 87.2 MB198.90 ms 7.43x 101.4 MB137.39 ms 5.13x 0 B---26.79 ms 1x 7.3 MB-
write-dataset-headerless-tables25000 rows - write - DataSet table export - speed-comparisonOfficeIMO.Excel39.94 ms367.90 ms 9.21x 168.0 MB487.20 ms 12.2x 108.6 MB---86.38 ms 2.16x 94.8 MB39.94 ms 1x 12.7 MB-
write-dataset-sparse-tables25000 rows - write - DataSet table export - speed-comparisonOfficeIMO.Excel45.31 ms561.97 ms 12.4x 273.8 MB681.54 ms 15.0x 132.5 MB---122.85 ms 2.71x 105.6 MB45.31 ms 1x 13.1 MB-
write-dataset-tables25000 rows - write - DataSet table export - speed-comparisonOfficeIMO.Excel38.33 ms365.94 ms 9.55x 168.0 MB395.10 ms 10.3x 108.2 MB337.04 ms 8.79x 0 B--85.48 ms 2.23x 94.8 MB38.33 ms 1x 10.0 MB-
write-datareader-table25000 rows - write - DataTable table export - speed-comparisonOfficeIMO.Excel37.14 ms377.19 ms 10.2x 169.3 MB326.33 ms 8.79x 114.7 MB315.77 ms 8.50x 0 B--80.41 ms 2.17x 90.0 MB37.14 ms 1x 12.7 MB-
write-datatable-direct25000 rows - write - DataTable table export - speed-comparisonLargeXlsx36.05 ms295.14 ms 8.19x 101.8 MB419.23 ms 11.6x 114.7 MB404.09 ms 11.2x 0 B-36.05 ms 1x 9.3 MB85.97 ms 2.38x 90.2 MB36.47 ms 1.01x 12.4 MB-
write-datatable-object-table-direct25000 rows - write - DataTable table export - speed-comparisonOfficeIMO.Excel37.27 ms378.33 ms 10.1x 166.7 MB321.94 ms 8.64x 112.0 MB---83.85 ms 2.25x 87.6 MB37.27 ms 1x 9.8 MB-
write-datatable-table-direct25000 rows - write - DataTable table export - speed-comparisonOfficeIMO.Excel35.86 ms428.25 ms 11.9x 169.3 MB396.58 ms 11.1x 114.7 MB368.88 ms 10.3x 0 B--91.28 ms 2.55x 90.2 MB35.86 ms 1x 12.4 MB-
write-bulk-report25000 rows - write - Formatted report write - speed-comparisonOfficeIMO.Excel41.74 ms868.51 ms 20.8x 552.7 MB458.95 ms 11.0x 249.0 MB602.19 ms 14.4x 0 B--69.58 ms 1.67x 122.6 MB41.74 ms 1x 11.3 MB-
write-cellformula25000 rows - write - Formula write/read - speed-comparisonOfficeIMO.Excel21.59 ms191.72 ms 8.88x 111.2 MB343.57 ms 15.9x 137.4 MB190.19 ms 8.81x 0 B---21.59 ms 1x 9.9 MB-
write-dictionary-objects-table-direct25000 rows - write - Other - speed-comparisonOfficeIMO.Excel47.26 ms------47.26 ms 1x 14.8 MB-
write-powershell-mixed-objects-direct25000 rows - write - Other - speed-comparisonLargeXlsx41.13 ms403.61 ms 9.81x 175.3 MB493.62 ms 12.0x 141.5 MB--41.13 ms 1x 5.9 MB89.58 ms 2.18x 111.3 MB46.21 ms 1.12x 10.3 MB-
write-powershell-psobject-mixed-direct25000 rows - write - Other - speed-comparisonLargeXlsx46.42 ms410.67 ms 8.85x 175.3 MB487.10 ms 10.5x 141.5 MB--46.42 ms 1x 5.9 MB89.95 ms 1.94x 111.3 MB48.71 ms 1.05x 9.7 MB-
write-powershell-psobject-wide-direct25000 rows - write - Other - speed-comparisonOfficeIMO.Excel216.40 ms1.33 s 6.12x 476.0 MB1.71 s 7.91x 549.7 MB--238.08 ms 1.10x 22.7 MB368.92 ms 1.70x 339.8 MB216.40 ms 1x 35.3 MB-
append-plain-rows25000 rows - write - Plain cell export - speed-comparisonLargeXlsx11.57 ms144.22 ms 12.5x 101.8 MB212.19 ms 18.3x 98.0 MB144.17 ms 12.5x 0 B-11.57 ms 1x 2.7 MB31.96 ms 2.76x 56.9 MB16.80 ms 1.45x 10.6 MB-
write-cellvalues-headerless-rectangle-direct25000 rows - write - Plain cell export - speed-comparisonOfficeIMO.Excel11.45 ms122.84 ms 10.7x 93.8 MB184.56 ms 16.1x 85.4 MB--11.49 ms 1x 3.4 MB-11.45 ms 1x 6.8 MB-
write-cellvalues-rectangle-direct25000 rows - write - Plain cell export - speed-comparisonLargeXlsx29.47 ms293.21 ms 9.95x 205.7 MB353.97 ms 12.0x 206.9 MB292.85 ms 9.94x 0 B-29.47 ms 1x 5.5 MB63.13 ms 2.14x 91.1 MB34.62 ms 1.17x 15.7 MB-
write-cellvalues-sparse-rectangle-direct25000 rows - write - Plain cell export - speed-comparisonOfficeIMO.Excel21.86 ms141.69 ms 6.48x 102.8 MB206.85 ms 9.46x 103.8 MB----21.86 ms 1x 7.7 MB-
write-datareader-plain25000 rows - write - Plain streaming export - speed-comparisonSylvan.Data.Excel27.98 ms275.70 ms 9.85x 101.8 MB317.33 ms 11.3x 114.7 MB269.37 ms 9.63x 0 B-35.55 ms 1.27x 8.2 MB71.40 ms 2.55x 90.0 MB41.67 ms 1.49x 12.7 MB27.98 ms 1x 5.6 MB
write-dataset-sparse-direct-export25000 rows - write - Plain streaming export - speed-comparisonOfficeIMO.Excel34.90 ms605.72 ms 17.4x 273.8 MB599.00 ms 17.2x 132.5 MB--43.39 ms 1.24x 9.0 MB106.07 ms 3.04x 105.6 MB34.90 ms 1x 9.6 MB-
write-blog-2023-20-string-columns25000 rows - write - Plain string export - speed-comparisonLargeXlsx38.84 ms937.90 ms 24.2x 742.0 MB---38.84 ms 1x 10.5 MB159.38 ms 4.10x 221.6 MB48.91 ms 1.26x 11.4 MB-
large-shared-strings25000 rows - write - Shared string write - speed-comparisonOfficeIMO.Excel20.03 ms146.81 ms 7.33x 101.8 MB220.49 ms 11.0x 82.4 MB106.29 ms 5.31x 0 B--37.70 ms 1.88x 72.0 MB20.03 ms 1x 15.4 MB-
write-cellvalue-strings25000 rows - write - Shared string write - speed-comparisonOfficeIMO.Excel17.16 ms114.32 ms 6.66x 101.8 MB191.80 ms 11.2x 82.4 MB114.75 ms 6.69x 0 B---17.16 ms 1x 15.0 MB-
write-cellvalue-strings-distinct25000 rows - write - Shared string write - speed-comparisonOfficeIMO.Excel12.68 ms154.91 ms 12.2x 128.4 MB209.41 ms 16.5x 95.4 MB----12.68 ms 1x 13.5 MB-
write-cellvalue-strings-repeated25000 rows - write - Shared string write - speed-comparisonOfficeIMO.Excel12.81 ms98.22 ms 7.67x 82.5 MB145.99 ms 11.4x 68.4 MB----12.81 ms 1x 7.3 MB-
write-fluent-rowsfrom-direct25000 rows - write - Typed object export - speed-comparisonLargeXlsx28.88 ms293.48 ms 10.2x 101.8 MB342.29 ms 11.9x 114.7 MB308.31 ms 10.7x 0 B-28.88 ms 1x 5.5 MB67.04 ms 2.32x 91.1 MB35.25 ms 1.22x 12.6 MB-
write-insertobjects-direct25000 rows - write - Typed object export - speed-comparisonLargeXlsx28.36 ms286.17 ms 10.1x 101.8 MB351.40 ms 12.4x 114.7 MB310.27 ms 10.9x 0 B-28.36 ms 1x 5.5 MB69.38 ms 2.45x 91.1 MB35.22 ms 1.24x 11.2 MB-
write-insertobjects-flat-dictionaries-direct25000 rows - write - Typed object export - speed-comparisonLargeXlsx29.60 ms289.15 ms 9.77x 101.8 MB349.78 ms 11.8x 114.7 MB--29.60 ms 1x 5.5 MB68.24 ms 2.31x 91.1 MB39.65 ms 1.34x 9.9 MB-
write-blog-2023-20-string-columns300000 rows - package - Package size - focused-package-profileLargeXlsx636.47 ms15.89 s 25.0x 31.0 MB---636.47 ms 1x 28.6 MB2.28 s 3.58x 28.5 MB701.65 ms 1.10x 26.6 MB-

Showing 274 of 274 rows