lisp-xl
lisp-xl copied to clipboard
Row with empty first cell skips the cell
If the first cell of a row is empty, NIL should be returned as the cell value, instead the row is shorted by one cell value, causing data to be shifted by one column to the left.
Using LispWorks 8.0.1 (32-bit) on Windows 10, loaded from QuickLisp.
Test Code:
(defun read-xlsx (pathname)
(lisp-xl:with-open-excel-sheet (pathname 1 sheet t)
(lisp-xl:process-sheet sheet
:row-function #'(lambda (row) (print row))
:initial-row 1
:debug-print t)))
Test Spreadsheet:
Test Output:
Row Number = 1 || |B1 (style NIL, type s, value 1) ("A1 missing") <===== should be (NIL "A1 missing") Row Number = 2 || |A2 (style NIL, type NIL, value 2)|B2 (style NIL, type s, value 0) ("2" "B") "Finalizing rows..."