Simple-Xlsx: XLSX File Reading and Writing

Simple-Xlsx: XLSX File Reading and Writing

1	Install
2	Basic Example
3	Top Level: *-xlsx
4	Second Level: with-sheet*
5	Add Data Sheet
6	Access Data
7	Set Styles
8	Add Chart Sheet

On this page:

Simple-Xlsx: XLSX File Reading and Writing

8.16.0.1

top contents ← prev up next →

Simple-Xlsx: XLSX File Reading and Writing🔗ℹ

Chen Xiao <chenxiao770117@gmail.com>

The simple-xlsx read and write .xlsx file.

1. Campatible with Microsoft Office, Google Sheets, Libre Office, WPS.

2. Support string, number, date as data type.

3. Multiple style supported: color, border, font, etc.

4. Can generate simple chart sheet.

2 Basic Example

2.1 Generate a xlsx file

2.2 Read a xlsx file

2.3 Read a xlsx file, modify something and Write back

3 Top Level: *-xlsx

3.3 read-and-write-xlsx

3.4 get-sheet-name-list

3.5 get-sheet-count

4 Second Level: with-sheet*

4.1 with-sheet-*

5 Add Data Sheet

5.1 add-data-sheet

6.1 cell/cell-value?

6.2 Example Sheet Data

6.3 Skip the with-sheet*

6.4 get-cell/set-cell!

6.5 get-row/set-row!

6.6 get-rows/set-rows!

6.7 get-col/set-col!

6.8 get-cols/set-cols!

6.9 get-rows-count/get-cols-count

7.1 about styles

7.2 cell/row/col range

7.3 set-row-range-height

7.4 set-col-range-width

7.5 set-freeze-row-col-range

7.6 set-merge-cell-range

7.7 about color

7.8 set-cell-range-border-style

7.9 set-font-style

7.10 set-alignment-style

7.11 set-number-style

7.12 set-date-style

7.13 set-fill-style

8 Add Chart Sheet

8.1 add-chart-sheet

top contents ← prev up next →