-
Notifications
You must be signed in to change notification settings - Fork 20
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Identify Grouped Rows in Excel #77
Comments
Hi, sorry for a slow reply. I think this will be possible. Notes to self: ECMA p1600 the |
A branch is ready to be tried. It can be installed with How do you envisage using this? The tree-like structure that Excel displays is unfortunately not represented in the data. Each row and column only records its own depth in the tree, but not its relation to its neighbours. |
Thanks! I'll try to take a look over the next few days. I envision using it by extracting out each "level" into its own data frame, and then trying to |
I'm getting a slightly weird result -- I'm not sure if its fixable or if its inherent to Excel.
Thanks again for all your hard work -- I really appreciate all your effort, and the digging into whatever happens under excel |
Oops, I think I've fixed those two mistakes. Thanks for checking. |
Thanks! The new version works well and indeed fixed the issue! One last suggestion (although I have no idea if it is difficult/feasible): I noted that the "top level" of the outline is 0, as is the indicator for any row/col that is not in an outline at all. Is there a way to change this, so that we can distinguish when something is not in an outline at all? (either with If not, this is still extremely useful, and will definitely take advantage -- thanks for your great work! |
Levels are already 1-4 for a 4-level outline. Do you see something different? I ran the following from the root of this the repo at this branch. print(tidyxl::xlsx_cells("tests/testthat/outlines.xlsx")[, c("sheet", "row", "col", "numeric", "row_outline_level", "col_outline_level")], n = Inf) |
When I ran your code, I saw the numbers of 0-3 -- even though, when I open the Excel file, I see the numbers 1-4 in the "outline" area. Am I misunderstanding what the results should be? |
I see, the button numbering from 1 to 4 implies that level 1 includes every row/col. It's recorded as level zero in the specification, but I'll add 1 to every level. |
Thanks for testing this. Feel free to reopen if the fix didn't work. |
Hi,
I am sometimes sent Excel files by contributors who group rows, using the "Outline" Function in Excel ( as explained here). Is there a way to identify the outline levels in a document?
My ultimate goal is to "un-outline" the data - and do primary analysis on the lowest level, but keeping the ability to do my own
group_by() %>% summarize()
with the higher level groupings.Thank you! This is a great package!
The text was updated successfully, but these errors were encountered: