Although I was initially disappointed when I found that Excel templates don't support Excel 2007 format (xlsx) I got over that because 64,000 rows is a lot of network throughput anway.
I was more interested in making our existing reports much smaller, because tens of thousands of rows results in tens of megabytes when outputting to those fake Excel files. That's just too big to email to our report recipients.
Now I can't even get basic (auto-generated) Excel templates to work. What I'm wondering is if anyone finds the experience with the new templates a positive one, or should I abandon this avenue for more fruitful labor?
Edited by: Multiverse on Apr 1, 2012 10:29 AM
yes current excel templates wont support more than 63000 rows but i think it will be fixed in next release.
if you want more than 64000 rows in excel go for xsl templates .may be you already have idea about these.
we are using excel templates and xsl templates .
I have written an Excel macro which does the following:
1. Open the Blank Excel Template and save with a new name in Excel 97-2003 format.
2. Prompts user to pick an XML file that was produced by BI Publisher (22.214.171.124).
3. Reads the XML file using MSXML2 library, finding all the child nodes of the main XML group (G_1).
4. Successively renames cells in the second row of Sheet1 with names like XDO_?[node_name]?, where [node_name] is the name of the child node in the main XML group.
5. Renames the range of cells that were just renamd to XDO_GROUP_?G_1?.
These are the only alterations to the workbook I make, but the BI Publisher Desktop add-in previewer fails with an ArrayIndexOutofBounds Exception.
When I look at all the renamed cells in Excel's Name Manager, everything looks normal. I am so far not impressed with the Excel Template robustness.
Tim is currently helping me with this. He gets the same error that I get.
Incidentally I have installed a much-improved Name Manager add-in into Excel. It gives much better insight into your named cells and cell ranges.
Edited by: Multiverse on Apr 10, 2012 11:22 AM