How do i select a sheet within a work book?

Nobody has claimed this yet.

```
Hi
I am very new to this so please any1 that can help it would be much
appreciated.

I have been looking for ages now for a reader i found this google one which
works but i have a xls file workbook with multiple sheets. Im trying to
modify this code to get it to look between the sheets if that makes sense?

Please note the below works!! just need help on how to make it do what i
need it to. I would like to be able to get it to cross search/read the
workbook (sheets).

Any help would be much appreiciated

I have attached all 3 files.

example.php

table.excel {
border-style:ridge;
border-width:1;
border-collapse:collapse;
font-family:sans-serif;
font-size:12px;
}
table.excel thead th, table.excel tbody th {
background:#CCCCCC;
border-style:ridge;
border-width:1;
text-align: center;
vertical-align:bottom;
}
table.excel tbody th {
text-align:center;
width:20px;
}
table.excel tbody td {
vertical-align:bottom;
}
table.excel tbody td {
padding: 0 3px;
border: 1px solid #EEEEEE;
}

dump(true,true);

?>

```

Original issue reported on code.google.com by `yor...@gmail.com` on 8 Aug 2009 at 8:22

Attachments:
- [book1.xls](https://storage.googleapis.com/google-code-attachments/php-excel-reader/issue-41/comment-0/book1.xls)
- [example.php](https://storage.googleapis.com/google-code-attachments/php-excel-reader/issue-41/comment-0/example.php)
- [excel_reader2.php](https://storage.googleapis.com/google-code-attachments/php-excel-reader/issue-41/comment-0/excel_reader2.php)

Start by reading the attached excel_reader2.php and example.php to understand how Spreadsheet_Excel_Reader loads and dumps workbook data. Check whether the existing reader exposes sheet selection or traversal; done should mean the requested workbook sheets can be searched or read, with the behavior demonstrated in the example.

Written by the indexing model from the issue text.