:: Forum >> Version 2 >>

Export excel to Mysql database

More information on this topic is available in the documentation section: /grid.examples/php-mysql.html.

I want to do the opposite of the example given. I want to know if Active Widgets exports excel to Mysql database.
E
Friday, January 19, 2007
use PEAR function

<?php
require_once 'Spreadsheet/Excel/Writer.php';

// Creating a workbook
$workbook = new Spreadsheet_Excel_Writer();

// sending HTTP headers
$workbook->send('test.xls');

// Creating a worksheet
$worksheet =& $workbook->addWorksheet('My first worksheet');

// The actual data
$worksheet->write(0, 0, 'Name');
$worksheet->write(0, 1, 'Age');
$worksheet->write(1, 0, 'John Smith');
$worksheet->write(1, 1, 30);
$worksheet->write(2, 0, 'Johann Schmidt');
$worksheet->write(2, 1, 31);
$worksheet->write(3, 0, 'Juan Herrera');
$worksheet->write(3, 1, 32);

// Let's send the file
$workbook->close();
?>
ferri
Tuesday, August 28, 2007



This topic is archived.

Back to /grid.examples/php-mysql.html

Documentation:

Forum search