What for to do such a work, propose your client a 50% 50% solution:
Small export -> excel
Big export -> csv (and they can optionally open in excel).
The conversion excel to pdf is really heavy, is not an option. If you have to create a pdf is better to use fpdf, but you will be forced to create an hardcoded solution (no template in excel).
i need the template from excel,but i need to generates to pdf or a file which can print all pages easily…because not just 1 page to be printed but many…
i think im going to use fpdf like your suggestion…
Nice technologies are expensive: is nice to have a template in excel and then print in pdf, but is too expensive.
I can give you another suggestion:
Once we did some contract’s generation, and we used rtf as template. The customer prepared with word a template in rtf, with some magic words that we substitute.
Rtf is a plain text file, you can freely substitute all with preg_replace, it work great.
Unfortunalely you cannot use this for large table.