Relative Content

Tag Archive for rparallel-processingopenxlsx

openxlsx and writeData in parallel

I’m trying to parallelise with openxlsx and its function writeData the export of many Excel individual files that should be somehow summarised in a central Excel file.
As can be shown in the reprex below I first create the central Excel file before creating the parallel processes and then I create the individual files in their respective parallel clusters.
The problem is that nothing (i.e. no ‘summary’, here simply the Row counter) is written in the central Excel file, although I exported its associated workbook object to the parallel processes.