Josep Pueyo-Ros Jul 7, 2023

Today, for first time, I needed to write a complex excel file with data validation, cells format, hidden and protected sheets...

{openxlsx} package in  is really great at that! It has been a pleasant discovery!

I wanted to thank its developers.

https://ycphs.github.io/openxlsx/

#rstats #xlsxwriter

Read, Write and Edit xlsx Files

Simplifies the creation of Excel .xlsx files by providing a high level interface to writing, styling and editing worksheets. Through the use of Rcpp, read/write times are comparable to the xlsx and XLConnect packages with the added benefit of removing the dependency on Java.

Michael G. LernerMay 22, 2023
Does anyone know how to insert an image into an #excel or #GoogleSheets cell using #python? Maybe #openpyxl or #xlsxwriter ... the trick is, I don't want to insert it so that it's aligned with the cell. I want it to actually be the cell data. Like you get with Insert Image.