Please help on programming/software/mysql

3 posts · originally from https://geek.digit.in/community/threads/please-help-on-programming-software-mysql.166827/

Hi. I have to create a software/application which will help me in extracting data from excel sheets and perform certain calculations on a daily basis. It should 2 options. 1 is to enter data and 2nd is to view reports which will be generated by excel. Right now I have been advised to use the following:
1. Heidi sql as the backend
2. ODBC connector
3. Webex for online design
Please let me know if you know any better alternatives. Also, if you know any tutorials/start-up material on these. It ll be of great help!
Thank you.

As per my view if you would like to extract content from excel sheet then you can use interop with .Net. Here I have given a link where you can get more details about it. Even you can generate reports from excel sheet.

Excel And C# – Interop With .Net 4 – How To Read Data From Excel « Don't Break The Build

I have also tried in developing like this kind of application but in that i have used java with JDBC connector & MySql