sphereC

Results 29 comments of sphereC

It is around 60 columns and as said ~15K rows. What I did now was to create one large df (with intermediate NAs-rows) and then I fill in the section...

Will do :). I'll post more performance numbers in case I come across other bottlenecks. Awesome package!

Thank you! I will check it out asap.

Short question: Does the new version allow for writing existing xlsm files? With the old version I can open/modify existing xlsx files but as soon as there's a macro in...

Hi - I wanted to follow up on this one. Is there maybe a way to hack it? Any direction would be helpful. I could try to use the reticulate/python...

Okay thanks. Apologies for not being exact in my question. I was actually talking about the first two options as well - I've never used the third one in the...

Okay this seems to have worked fine: ` wb$worksheets[[1]]$sheetPr

Okay got it. I never looked at the actual library code but I assume that sending something to sheetPr adds the xml to the existing one? Reason I was asking...

Hi - Has this ever been addressed? I'm running into the same issue. The "Repacking large object" step takes painfully long. Happy to provide more details, but it happens across...