search

awalker89 / openxlsx

R package for .xlsx file reading and writing.
Other
364 stars 79 forks source link

Problem with the content of an excel file #475

Open PatientIntern opened 5 years ago

PatientIntern commented 5 years ago

Expected Behavior

Simply opening a workbook and saving the workbook under a different name to create a copy/rename.

Actual Behavior

The excel file comes back with a "problem", and can be opened only with considerable amounts of data missing.

Steps to Reproduce the Problem

(please attach an example xlsx file if possible)

  1. Loadworkbook

  2. Saveworkbook

Currently the code looks exactly like this: wb <- loadWorkbook(file_name) saveWorkbook(wb, newfileName, overwrite = T)

This isn't what the full program will look like, but I figured I would start as simply as possible, as writing data to it also produces the same errors.

simonaubertbd commented 5 years ago

Same issue, I lost all the headers and some columns. :( Is a correction expected soon?