tidyxl
tidyxl copied to clipboard
nacnudus
Read untidy Excel files in R https://nacnudus.github.io/tidyxl/
When a formula references cells on the same sheet, the sheet name is implied, so it isn't available to the lexer. It would be convenient to put the sheet names...
I have a large excel file that causes `xlsx_cells` to crash. It would be nice to say, "Only get this many rows and this many columns" when calling xlsx_cells. Could...
ECMA p.1678. Rows have a `customFormat` attribute, and if this is `1` then apply their `s` attribute (style index), except where individual cells override it. Columns have a `style` attribute...
With more functionality, it makes sense to split things up into separate functions. * [x] `xlsx_cells()` cells of all worksheets in one data frame (#16) * [x] `xlsx_formats()` formatting and...
Probably related to #10. Test file: [test_failing.xlsx](https://github.com/nacnudus/tidyxl/files/12765374/test_failing.xlsx) Reprex: ``` r tf sheet address row col is_blank content data_type error logical numeric date #> 1 Sheet1 A1 1 1 TRUE blank...
Thanks very much for your great work with `tidyxl`! I often have to deal with Excel files where key information is in the color coding and `tidyxl` finally solves that...
For example, consider a sheet like this: If I read this file using `xlsx_cells()`, as far as I'm aware this wouldn't show me that `C5` belongs to `myTable[bar]`. Thank you!...
