excel - Performance/Load Testing PHP / Coldfusion Spreadsheet Web Processing?

264

PHP Pear:PHPExcel vs PHP:PHP-Excel-Reader vs Coldfusion:CFspreadsheet vs Railo:CFSpreadsheet.

Has anyone done any comparison performance or load tests for large/frequent data-set imports to databases? If so, what do the performance comparisons look like? I'm hoping someone already has specific time/resource metrics.

Also open to any possible alternative spreadsheet processing libraries that can serve up web content. Java/C-derivatives are welcome.

928

Answer

Solution:

I faced the same problem few times ago and it appeared that PHP libraries to deal with XLS were relatively slow. (Didn't try all the one you mentioned here though) We used PHPExcel for our main try and it was really not satisfying.

Our solution was to use Java' library OpenXLS and create a PHP <> Java interface. Not sure if you'd need it in your case or if you can import from Java directly.

Anyway, the main problem about these libraries was always the same : lack of documentation.

People are also looking for solutions to the problem: How to submit/save to DB the cell's input data in dynamically added rows on a table using javascript /php

Source

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

Similar questions

Find the answer in similar questions on our website.