On this page:
Simple-Xlsx:   XLSX File Reading and Writing
8.12

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.

    1 Install

    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.1 write-xlsx

      3.2 read-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 Access Data

      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 Set Styles

      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

      8.2 Line Chart

      8.3 Bar Chart

      8.4 Pie Chart