When you generate an Excel file, you usually generate it with a single sheet. You can however generate a file with more sheets. With PDI, you can generate an Excel file with several sheets even if you don't know in advance how many sheets you will generate, or the name of those sheets.
In this recipe, you will create such an Excel file. Your file will have book title information separated in different sheets depending of the genre of the books.
You will need a database containing books and authors with the structure described in Appendix, Data Structures.
Carry out the following steps: