rsheets / rexcel

Extracts spreadsheet data from Excel workbooks and puts into linen format
50 stars 5 forks source link

understand notions of cell emptiness #6

Open jennybc opened 8 years ago

jennybc commented 8 years ago

When I use rexcel_read() on an xlsx that originated from a Google Sheet, empty cells show up in the linen object. Since the default Google Sheet has 1000 rows and 26 columns, for tiny test sheets, this constitutes the vast majority of the cells in the linen object.

@richfitz how well do you already understand cell emptiness? I bet native Excel sheets don't turn into linen objects with great gobs of empty cells, yes? If true, is that something you did explicitly or ...?