tommycahir
New member
- Joined
- May 31, 2006
- Messages
- 1
- Programming Experience
- Beginner
Hi All
Just really looking for some ideas on how to approach this rather than actual assistance with an error.
I currently am generating a number of excel spreadsheets for different customers and then at the end of the month there is a number of reports generated from the spreadsheet for that particular customer.
What i am looking to do is create program that can read that spreadsheet and then depending on which button is pressed generate the report.
i am planning to use VB.net to create this program( as i have some VB experience and have coded macros in VBA to generate some of the report's and am interested in learning VB.Net)
as i have stated i have some of the VBA macros developed and working in the excel spreadsheets themselves but i want to be able to distribute this single exe to allow the customer to generate the report themselves without worrying about the macros in the spreadsheet
i was thinking of displaying these charts and data tables in a html format so that they can be placed on a web server.
Any body got any ideas on how i can read in the excel file -> run the code to generate the charts,graphs,data tables and display neatly in HTML or another better format for this?
I must also note the the spreadsheets contain a header row and was thinking of a way to select the columns that should be read in and used to generate the reports
also is it hard to display the graphs charts etc in the application on a frame ( or something similar) first and then have the option to write out to a html file?
Any help or suggestions would be welcome
Tommy
Just really looking for some ideas on how to approach this rather than actual assistance with an error.
I currently am generating a number of excel spreadsheets for different customers and then at the end of the month there is a number of reports generated from the spreadsheet for that particular customer.
What i am looking to do is create program that can read that spreadsheet and then depending on which button is pressed generate the report.
i am planning to use VB.net to create this program( as i have some VB experience and have coded macros in VBA to generate some of the report's and am interested in learning VB.Net)
as i have stated i have some of the VBA macros developed and working in the excel spreadsheets themselves but i want to be able to distribute this single exe to allow the customer to generate the report themselves without worrying about the macros in the spreadsheet
i was thinking of displaying these charts and data tables in a html format so that they can be placed on a web server.
Any body got any ideas on how i can read in the excel file -> run the code to generate the charts,graphs,data tables and display neatly in HTML or another better format for this?
I must also note the the spreadsheets contain a header row and was thinking of a way to select the columns that should be read in and used to generate the reports
also is it hard to display the graphs charts etc in the application on a frame ( or something similar) first and then have the option to write out to a html file?
Any help or suggestions would be welcome
Tommy
