search

multiprocessio / datastation

App to easily query, script, and visualize data from every database, file, and API.
https://datastation.multiprocess.io
Other
2.9k stars 112 forks source link

Empty cells/fields are filled with values from preceding rows #217

Closed steirico closed 2 years ago

steirico commented 2 years ago

I came across this issue using dsq and was able to narrow is down to this project.

The issue arises with the attached file fail.xlsx which has the following structure:

A B C D
a1 b1 c1 d1
a2 b2 c2  
a3 b3    
a4      

Dumping the file's structure using dsq is as follow:

> dsq --pretty fail.xlsx
+----+----+----+----+
| A  | B  | C  | D  |
+----+----+----+----+
| a1 | b1 | c1 | d1 |
| a2 | b2 | c2 | d1 |
| a3 | b3 | c2 | d1 |
| a4 | b3 | c2 | d1 |
+----+----+----+----+
eatonphil commented 2 years ago

Great work noticing and finding a reproducable case!

eatonphil commented 2 years ago

The fix is now released in dsq 0.14.0 https://github.com/multiprocessio/dsq/releases/tag/0.14.0