README.md in fast_excel-0.2.0 vs README.md in fast_excel-0.2.1
- old
+ new
@@ -1,8 +1,10 @@
# Ultra Fast Excel Writter for Ruby
```ruby
+require 'fast_excel'
+
workbook = FastExcel.open("hello_world_ffi.xlsx", constant_memory: true)
workbook.default_format.set(
font_size: 0, # user's default
font_family: "Arial"
)
@@ -22,10 +24,12 @@
for i in 1..1000
worksheet.write_row(i, ["Hello", (rand * 10_000_000).round(2), Time.now])
end
+worksheet.write_row(1001, ["Sum", FastExcel::Formula.new("SUM(B2:B1001)")], bold)
+
workbook.close
```
This repositiry and gem contain sources of [libxlsxwriter](https://github.com/jmcnamara/libxlsxwriter)
@@ -33,26 +37,26 @@
1000 rows:
```
Comparison:
FastExcel: 31.7 i/s
- Axslx: 8.0 i/s - 3.98x slower
+ Axlsx: 8.0 i/s - 3.98x slower
write_xlsx: 6.9 i/s - 4.62x slower
```
20000 rows:
```
Comparison:
FastExcel: 1.4 i/s
- Axslx: 0.4 i/s - 3.46x slower
+ Axlsx: 0.4 i/s - 3.46x slower
write_xlsx: 0.1 i/s - 17.04x slower
```
Max memory usage, generating 100k rows:
```
FastExcel - 20 MB
-Axslx - 60 MB
-write_axslx - 100 MB
+Axlsx - 60 MB
+write_xlsx - 100 MB
```
## Install
```ruby