Hi,
Is it possible to import a csv into a new tab in an existing xlsx file, headless?
Bonus question, is it possible to convert several csv files into a new xlsx file, one tab per csv?
Thanks
Yes. Do menu:Insert Sheet From File… and then inspect the sheet’s properties.
Sorry but that doesn’t solve the problem.
I need to do it strictly in headless mode.
What are we discussing here if you don’t know how to acomplish some task in the user interface? There are many ways to import text into a spreadsheet. The by far easiest way for macro coders uses a database connection. You save the text table (csv) under a distinct path-name, open the spreadsheet document and refresh a distinct database range.
Thanks, I oepened the interface and tried all these methods and they all work,
but now how can I do it without the interface?
Thanks
1 Like
Hallo
Python pandas has umty methods to read|write data from several sources. It works not only "headless" … it doesnt need any excel|Libreoffice|Openoffice -instance
see also this to write …xlsx
1 Like
I was trying to do it without coding, but if I have to go down that route, you know which one performs better for very large spreadsheet (~500k rows) between python, perl, and php?
Thanks