Tracking trends in autogenerated Excel File

[karthikkotha]

Hi,

I am a new user of PERL and am having slight trouble with my latest code. This is what I need to do:
1. Run a query on the database and dump the results in an excel file.
2. A new file with the date and time is generated each time I run the script.
3. One column in the query is called "Rank" and is either A, B or C
4. I need to count the number of A, B and C's each time I run the script and keep adding them to a single file and saving it over time.
5. I need to plot the trend of number of A's, B's and C's each week.

Can someone please help me with steps 4 and 5?

Thank you,
Karthik

[numberwhun]

Hi,

I am a new user of PERL and am having slight trouble with my latest code.

Ok, so where is your code? We cannot help you troubleshoot it if you don't supply it to us.

This is what I need to do:
1. Run a query on the database and dump the results in an excel file.

For this you will need to look at the Spreadsheet::WriteExcel module for writing an Excel spreadsheet, and also the DBI module for interacting with the database.

2. A new file with the date and time is generated each time I run the script.
3. One column in the query is called "Rank" and is either A, B or C
4. I need to count the number of A, B and C's each time I run the script and keep adding them to a single file and saving it over time.
5. I need to plot the trend of number of A's, B's and C's each week.

This will all be handled by your code. Go ahead and post your code and someone who knows a little about writing Excel spreadsheets will try and assist you.

Regards,

Jeff