Was expecting the library to work based on its past stable history. Note 4: I receive a warning when I load the openxlsx library, built under R 3.1.4, sorry if this is why I'm getting the error.

I would really like to continue using openxlsx. I abandonded XLConnect as soon as openxls was written, saving me from various issues processing large datasets. The XLConnect created workbook has no issues. Note 3: I have successfully run the same testing sceanrios using XLConnect, with no issues. Note 2: I have tested multiple variations on fixed filenames, fixed path and actual flename to try and isolate the issue. All I need to do is create a new workbook, add an empty worksheet and save. I have spent a couple of hours pulling apart my R script, to get to the basic failure scenario. The issues seems limited to the creating and saving of a new workbook. Note 1: I can successfully use the read file and openXL functions on my PC, from the openxlsx library. Excel 2016 states file is corrupt and fails to recover it. When creating a new empty workbook, adding an empty worksheet, then saving workbook, MS Excel 2016 fails to open and recover the workbook.Ī xlsx file with the expected filename and extension is created in the destination directory. When creating a new empty workbook, using openxlsx, add a blank worksheet and saving file, I expect the new workbook to open in MS Excel 2016 without errors. I have recently installed the 3.4.0 version of R and I am trying to get some useful openxls R script running again.

Winzip 21.5 pro edition