sprawa wyglada tak, ze mam iles tam plikow excela w ktorych dokladnie w tych samych komorkach beda jakies dane, chcialbym sobie stworzyc skryptem jeden plik, ktory pobierze te dane i umiesci je w jednym arkuszu w skoroszycie, poki co stworzylemc os takiego:
<?php
header("Content-Type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=filename.xls");
require_once 'Excel/reader.php';
$data = new Spreadsheet_Excel_Reader();
for ($k=1; $k<=2; $k++)
{
echo '<table border="1">'; $data->read("$k.xls");
for ($i = 1; $i <= $data->sheets[2]['numRows']; $i++)
{
for ($j = 1; $j <= $data->sheets[2]['numCols']; $j++)
{
echo '<td>'.$data->sheets[2]['cells'][$i][$j] .'</td>';
}
}
}
?>
ale niestety nie dziala to do konca dobrze tzn testuje poki co na 2 plikach i czyta mi dwa razy dane ale tylko z pliku 1.xls i na dodatek wywala komunikat o bledzie w pliku excela:
<?php
Notice: Uninitialized string offset: 8911 in c:usrkrasnalwwwexcelExcelreader.php on line 481
Notice: Uninitialized string offset: 8912 in c:usrkrasnalwwwexcelExcelreader.php on line 481
Notice: Uninitialized string offset: 8913 in c:usrkrasnalwwwexcelExcelreader.php on line 482
Notice: Uninitialized string offset: 8914 in c:usrkrasnalwwwexcelExcelreader.php on line 482
Notice: Uninitialized string offset: 8915 in c:usrkrasnalwwwexcelExcelreader.php on line 484
Notice: Uninitialized string offset: 8916 in c:usrkrasnalwwwexcelExcelreader.php on line 484
Notice: Uninitialized string offset: 8917 in c:usrkrasnalwwwexcelExcelreader.php on line 485
Notice: Uninitialized string offset: 8918 in c:usrkrasnalwwwexcelExcelreader.php on line 485
Notice: Uninitialized string offset: 11513 in c:usrkrasnalwwwexcelExcelreader.php on line 481
Notice: Uninitialized string offset: 11514 in c:usrkrasnalwwwexcelExcelreader.php on line 481
Notice: Uninitialized string offset: 11515 in c:usrkrasnalwwwexcelExcelreader.php on line 482
Notice: Uninitialized string offset: 11516 in c:usrkrasnalwwwexcelExcelreader.php on line 482
Notice: Uninitialized string offset: 11517 in c:usrkrasnalwwwexcelExcelreader.php on line 484
Notice: Uninitialized string offset: 11518 in c:usrkrasnalwwwexcelExcelreader.php on line 484
Notice: Uninitialized string offset: 11519 in c:usrkrasnalwwwexcelExcelreader.php on line 485
Notice: Uninitialized string offset: 11520 in c:usrkrasnalwwwexcelExcelreader.php on line 485
?>
ktos cos moze doradzic?
Ten post edytował suck 14.07.2006, 23:34:27