search

nacnudus / tidyxl

Read untidy Excel files in R https://nacnudus.github.io/tidyxl/
https://nacnudus.github.io/tidyxl/
Other
246 stars 20 forks source link

xlsx_formats for sheets in an xlsx file #90

Closed austinj closed 11 months ago

austinj commented 11 months ago

Thanks for this excellent package! I haven't been able to figure out how to get xlsx_formats() to grab formatting from sheets beyond Sheet 1 in an xlsx file. For instance, spreadsheet.xlsx contains Sheet 1, Sheet 2, and Sheet 3, and I'm trying to get xlsx_formats() to get the formatting based on the cells in Sheet 3.

Is this possible?

nacnudus commented 11 months ago

Thanks! The scope of formatting is the whole file, not just particular sheets. Excel itself scopes them that way.