Export to Excel without opening Excel

[leonard.moelders]

If you are familiar with python you can use @GavinCrump’s code from here:

Export data to Excel using Python/Microsoft Interop

I’ve been trying to pick apart the methods and logic used to export a basic 2D matrix of data to a worksheet in an existing file today. I managed to work with some code from Bumblebee to get importing to work consistently, but have been hitting a lot of errors with exporting of data. I know part of this relates to how COM objects are released and the XlApp is quit, as files are sometimes left in a readonly state until I restart, but generally the warnings indicate I’m also getting something wro…

the visibility of the excel app is preset to invisible there