in reply to
how use Spreadsheet::ParseExcel::Stream;?
Write a minimal amount of code similar to what's in the Synopsis of the module, tell us what doesn't work or what you're having trouble with, and it will be easier to help you. Including irrelevant code that creates XML documents doesn't really help focus on the problem you're having.
The row() method returns rows of data from the spreadsheet, you can also check the test directory of the distribution for more examples, and the module is meant to be functionally similar to Spreadsheet::ParseExcel::Simple