Please help on programming/software/mysql

sachin.rao

Right off the assembly line
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.
 

Clydebrown

Broken In
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
 
Top Bottom