forked from dbortz/simple_xlsx_writer
-
Notifications
You must be signed in to change notification settings - Fork 3
/
README
47 lines (30 loc) · 1.26 KB
/
README
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
** Description **
This is a simple no fuss generator for OpenXML aka XLSX files. No
formatting, styles just raw content with a few basic datatypes
supported. Produced output is tested to be compatible with
- Open Office 3.2 series (Linux, Mac, Windows)
- Neo Office 3.2 series (Mac)
- Microsoft Office 2007 (Windows)
- Microsoft Office 2010 (Windows)
- Microsoft Office 2008 for Mac (versions 12.2.5 or above)
- Microsoft Excel Viewer (Windows)
Numbers of iWork '09 does not appear to support the inline string
storage model prefered by this gem. Apple may release a fix for this
eventually, I have avoided the more common shared string table
method as it cannot be implemented in linear time.
** Sample **
serializer = SimpleXlsx::Serializer.new("test.xlsx") do |doc|
doc.add_sheet("People") do |sheet|
sheet.add_row(%w{DoB Name Occupation})
sheet.add_row([Date.parse("July 31, 1912"),
"Milton Friedman",
"Economist / Statistician"])
end
end
file_with_data = serializer.zipfile
serializer.cleanup
** License **
See attached LICENSE for details.
** Credits **
Written by Dee Zsombor: http://primalgrasp.com
Funded by Harvest: http://www.getharvest.com