Category "openxlsx"

Newline in openxlsx

A question on openxlsx library in R: I'm looking for a way in openxlsx to add a newline to a cell value so that the value is in two (or more lines) in Excel. I

`openxlsx` `dataValidation`: providing text input in list insteaf of cell reference

The documentation for openxlsx::dataValidation demonstrates how to get a dropdown menu by referencing cell(s). However, I'm interested in adding text input ("Ye

How to detect TIME when reading from an excel sheet using R

The issue is that when I read from an excel sheet into R using read.xlsx from openxlsx package, the TIME column is converted into a fraction. Here is an exampl