Use existing database data to generate a phpexcel export and send via automatic email

  • Posted:
  • Proposals: 12
  • Remote
  • #671484
  • Archived
Kamran I.Maya V.Hafiz M.Sagar G.Anthony K. + 7 others have already sent a proposal.
  • 0

Description

Experience Level: Intermediate
Estimated Job duration: 1 - 2 weeks
I am looking for someone to adapt phpexcel (https://phpexcel.codeplex.com/) to pull data from an existing MySQL database, save as an XLS file on the server, then send as an attachment to a specified email address, before deleting the temporary XLS server file.

It is important that the XLS file is formatted properly (mainly cell background colours, but also a few cell text colours).

This code will ultimately run on a cron job (scheduled task) once a week to send an export/backup to my client.

Please note the server has already been checked that it can run phpexcel (the example script supplies work properly and save a XLS file on the server) and I already have the start of the export file (which displays in-browser as an HTML table) - the job is to tie these two together to product the same data, in the same format, as my current export display, and then send to email.

Please ask if you have any questions. I aim to award the job within a a few days and hope to have the code completed and tested within a week of awarding the job.

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.