Writing to Excel with openpyxl or similar

[cmezey]

I’m currently writing a custom script in VEScripts in IES 2019 to export energy simulation results to Excel. I’m hoping to use the package openpxyl, which will enable me to write to a specific existing worksheet in an existing Excel workbook. I’ve had success importing the library xlsxwriter in VEScripts, but when I use its methods to write to Excel, it always deletes all existing sheets in the Excel file before writing to it. I’ve been struggling to use openpyxl in VEScripts. Does anyone have any recommendations for how to proceed – whether you know of others who have used openpyxl in VEScripts (or whether it’s maybe not available in the VE Python environment), or if there’s a workaround/ other library that you’ve found can write to Excel without writing over existing content. Thanks so much!