Comments (3)
The problem is that I assumed the first two nodes would be sysClr
<a:theme xmlns:a="http://schemas.openxmlformats.org/drawingml/2006/main" name="Office Theme">
<a:themeElements>
<a:clrScheme name="Office">
<a:dk1>
<a:sysClr val="windowText" lastClr="000000"/>
</a:dk1>
<a:lt1>
<a:sysClr val="window" lastClr="FFFFFF"/>
</a:lt1>
But in this case the first one is srgbClr
<a:theme xmlns:a="http://schemas.openxmlformats.org/drawingml/2006/main" name="Office Theme">
<a:themeElements>
<a:clrScheme name="Custom 2">
<a:dk1>
<a:srgbClr val="262626"/>
</a:dk1>
<a:lt1>
<a:sysClr val="window" lastClr="FFFFFF"/>
</a:lt1>
So I should check the name of the child node first, then.
- If it's
sysClr
, use thelastClr
attribute - Otherwise use the
val
attribute
from tidyxl.
Thanks Dan. Confirmed. Do you happen to know what software created the original file?
from tidyxl.
Excel 2016 64-bit
from tidyxl.
Related Issues (20)
- Read in openxlsx workbooks with xlsx_cells() HOT 2
- Can you make R Makevars specify gcc? ipcc fails. HOT 9
- Change licence to MIT HOT 3
- Encoding issue when using cell references on Windows 10 HOT 9
- Formulas referring to other files HOT 2
- 1.234, once formated as currency is imported as numeric 1.23 instead of numeric 1.234 HOT 5
- R Studio crashes reading file HOT 11
- apply* formats should default to false HOT 2
- How to import data from a URL? HOT 1
- Identify Grouped Rows in Excel HOT 10
- Identifying pivot tables in sheets HOT 1
- special characters in file path HOT 2
- select sheet in xlsx_formats() HOT 2
- Hidden columns sometimes cause R session to crash with calling tidyxl::xlsx_cells() HOT 1
- create xlsx from xlsx_cells HOT 1
- Readme doesn't show gif on pkgdown site HOT 1
- Hexcodes for colors are strange/incorrect HOT 4
- xlsx_formats for sheets in an xlsx file HOT 1
- `xlsx_cells(include_blank_cells = FALSE)` fails on blank cells with comments
- Cells incorrectly identified as blank HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from tidyxl.