I have a program which retrieves data from a SQL server. I want to write this data to an excel sheet and draw graphs using this data.
As of now I wrote the output of my program in csv format, so after I run the program it creates an excel file.
But how can I make my program open an excel sheet, write data to it, generate the graphs.
Basically my output should be an excel file with data and graphs in it.
Any kind of help is appreciated.
Thanks.