Search code examples
javaexcelexport-to-excel

Best language to use when exporting an excel file

I want to write a macro program that takes in data from a text file and then arranges it in a specific manner in an excel file. I don't know which language has the best features for dealing with Excel.

I prefer java, and I see someone made an api called JExcelApi, but I'm not sure about it's capabilities. I would like to be able to generate a graph automatically in excel based on the data in a certain column. Is this possible in any language? I would guess that Microsoft's VB or C# would have an advanced feature such as this, but I'm not sure. Thanks.

Solution

  • JExcel Api Gives you total control on what you want to write, it's powerful, fast and pure java.

    I suggest it, here's a tutorial.