I want to know what is the best way to create a script in any language for importing a text file in excel. I use to code in java but I'm interrested to learn any other language.
The goal is to import a txt file in excel without opening excel for example using java or vb...
I have a folder where everyday a text file is downloaded and I want to import it in excel and the I could check for graphs.
I tried to import it in java, but it seems it's not possible.
Thank you for your help.
I think the best way would be to convert your text file into a .CSV file (Comma Separated Values).
Use whatever language you like, but I would suggest a scripting language like preferably Python.
EDIT: Forgot to mention earlier that CSV files open up in excel by default.