It it possible to write a custom Velocity report that exports to an excel containing multiple sheets ?
Yes, this is possible. You can start with creating the file with the sheets you need in excel, then save it as Single File Web page (file ending .mht) and then rename the file ending to *.vm.
Inside the file, the sections are separated with "------=_NextPart_...." and each sheet should be annotated with sheet001.htm, sheet002.htm, etc.
Then add your velocity code to the respective sheet.
Do you know if it's possible to have the velocity report separate items based on folders into separate excel tabs? For example, I have a Set with 4 folders filled with items and I want each folder put into separate excel tabs. I would think it's similar to how velocity can do hierarchy based on folder level and turn them into headings for Word but I'm not sure how to apply that to Excel velocity exports.
This is probably not so straight forward, but you could maybe write a macro which creates a sheet for each folder. Difficulty is probably to let the code create the file list and the array of Tab names, which have to come at the beginning of the file.
HEADQUARTERS|135 SW Taylor Suite 200, Portland, Oregon, 97204