Save chunks from database in xls

Question

I use this code from Krasimir to output data from PHP to .xls

function xlsBOF() {
    echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0);
}
function xlsEOF() {
    echo pack("ss", 0x0A, 0x00);
}
function xlsWriteNumber($Row, $Col, $Value) {
    echo pack("sssss", 0x203, 14, $Row, $Col, 0x0);
    echo pack("d", $Value);
}
function xlsWriteLabel($Row, $Col, $Value) {
    $L = strlen($Value);
    echo pack("ssssss", 0x204, 8 + $L, $Row, $Col, 0x0, $L);
    echo $Value;
} 
// prepare headers information
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");
header("Content-Disposition: attachment; filename=\"export_".date("Y-m-d").".xls\"");
header("Content-Transfer-Encoding: binary");
header("Pragma: no-cache");
header("Expires: 0");
// start exporting
xlsBOF();
// first row 
xlsWriteLabel(0, 0, "id");
xlsWriteLabel(0, 1, "name");
xlsWriteLabel(0, 2, "email");
// second row 
xlsWriteNumber(1, 0, 230);
xlsWriteLabel(1, 1, "John");
xlsWriteLabel(1, 2, "[e-mail]");
// third row 
xlsWriteNumber(2, 0, 350);
xlsWriteLabel(2, 1, "Mark");
xlsWriteLabel(2, 2, "[e-mail]");
// end exporting
xlsEOF();

It works fine for a small amount of data, but when I export from a database, for example, a large amount of data (100,000 records), I get a server timeout error.

How can I modify this code so that I can write small pieces of data to a file progressively?

I am currently using a method that only works for tab-delimited files or CSV

I write pieces of 1000 lines in a .xls file. After exporting the piece, I use window.location.href=the_script.php?offset=new_offsetto call the script for the next offset, and open the file again and add the next 1000 lines.

, Excel . . . , . ?

- script ?

Answer 1

PHP-.