Comments (2)
Hi @millerjef, thanks for reporting this.
Which column of the data frame is missing the values? E.g. if cell D24 has a value in the character
column, is D25 NA
in the character
column? Maybe the value of D25 is in one of the other columns, e.g. numeric
, date
, logical
or error
.
If that isn't the problem then I really need a file to work with, so here are a couple of suggestions to create one:
- Create a new workbook, and paste cells D24 and D25 into it. If that doesn't reproduce the problem, then try option 2 below.
- Delete all the cells except D24 and D25, and send me the file. Step by step this would mean
a. Delete columns A:D (select the whole column, right-click, delete). The original column D would now be column A.
b. Then select columns B to the edge of the sheet, and delete those.
c. Repeat for the rows.
d. Finally, delete any other sheets in the workbook.
from tidyxl.
@millerjef do you still have this problem? I'll close the issue now, but feel free to reopen it if it isn't solved.
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 3
- 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.