Interacting With Excel

[Tresky]

I am trying to make a program that will take data input through an SFML GUI and then print and format it into specific slots in an Excel document. Any good APIs for this? If not any suggestions would be great.

[Computergeek01]

Does it have to be .xls\.xlsx format? If not it's a whole ton easier to use .tab or .csv to delimit your data.

[Tresky]

I don't suppose it HAS to be. All I need to do is put data in specific cells.

[Computergeek01]

In that case .tab is a tab delimited format. .csv stands for "Comma Seperated Value" Excel will know how to read either one of those with zero trouble at all.

[Tresky]

Which do you suggest and how do I go about doing this?

[Computergeek01]

I'd recommend .csv because it's "cleaner" to work with. When you want data to go into a new column just enter a comma, when you want a new row enter a new line.

[Tresky]

Wow! That's easy. Do it just like a text file, but make the extension .csv?

If I wanted the words "Hello, World!" in the 4th column, 2 row I would just do:

|
|,,,Hello, World!

[Tresky]

Just tested it out. Works insanely awesome. Thanks, your great!