6 Access Data🔗ℹ

6.1 cell/cell-value?🔗ℹ

cell is the XLSX’s cell’s name:

First is the column’s index identified by the alphabet from "A".

Second is the row’s index identified by the number from 1.

Example: Cell in the second row, the third column, so cell is "C2".

cell-value can be these type: string, number, date.

6.2 Example Sheet Data🔗ℹ

(add-data-sheet "sheet1" '(

(1 2 3)

(4 5 6)

))

6.3 Skip the with-sheet*🔗ℹ

If not have a mass access on a sheet, you can get/set data a sheet directly, not need in a with-sheet* scope.

Example:

There are 3 ways to locate a sheet:

sheet-ref: use sheet index, start from 0.

sheet-name: use sheet name, match exactly.

sheet-*name*: use part of sheet name, locate first matched sheet name.

Example:

6.4 get-cell/set-cell!🔗ℹ

get-cell (-> string? cell-value?)

(check-equals (get-cell "B2") 5)

set-cell! (-> string? cell-value? void?)

(set-cell! "C1" 8)

6.5 get-row/set-row!🔗ℹ

Row’s index from 1.

get-row (-> natural? (listof cell-value?))

(check-equal? (get-row 1) '(1 2 3))

set-row! (-> natural? (listof cell-value?) void?)

(set-row! 1 '(7 8 9))

6.6 get-rows/set-rows!🔗ℹ

get-rows (-> (listof (listof cell-value?)))

(check-equal? (get-rows) '((1 2 3) (4 5 6)))

set-rows! (-> (listof (listof cell-value?)) void?)

(set-rows! '((1 2 3) (7 8 9)))

6.7 get-col/set-col!🔗ℹ

Col’s index from 1.

get-col (-> natural? (listof cell-value?))

(check-equal? (get-col 1) '(1 4))

(check-equal? (get-col 2) '(2 5))

(check-equal? (get-col 3) '(3 6))

set-col! (-> natural? (listof cell-value?) void?)

(set-col! 1 '(7 8))

6.8 get-cols/set-cols!🔗ℹ

get-cols (-> (listof (listof cell-value?)))

(check-equal? (get-cols) '((1 4) (2 5) (3 6)))

set-cols! (-> (listof (listof cell-value?)) void?)

(set-cols! '((7 8) (9 0) (1 2)))

6.9 get-rows-count/get-cols-count🔗ℹ

get-rows-count (-> natural?)

get-cols-count (-> natural?)

(check-equal? (get-rows-count) 2)

(check-equal? (get-cols-count) 3)