javaexcelscripting-language

What is the best solution to create a script for importing a text file in excel?


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.


Solution

  • 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.