Search Results

Because this is a file with thousands of records containing bi-weekly hours, which need to be added up to show the amount of hours per month worked on the same project by the same employee. If I...

Yes, but I need to parse the data and remove redundant information and display it formatted per month.

Thanks for the reply.

A .xlsx file is a combination of XML architecture and ZIP compression for size reduction. Basically though, I have to output to a spreadsheet.

The other problem is that...

Thanks for the reply. Yes, I need this to be automated. Plus, the extraneous data, the hours, I need to add these together to get a total for the month (each line is the total for the week).
...

I have a csv file which I need to process and export back to xlsx file.

For instance, the csv contains:

John Smith, job-title, hours
John Smith, job-title, hours
Mary Smith job-title, hours
...