This content has been marked as final. Show 7 replies
yes current excel templates wont support more than 63000 rows but i think it will be fixed in next release.1 person found this helpful
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 .
regarding basic excel templates :
we never had any issue with them till now we have developed like 30-40 reports using excel templates.
Thank Varma. I do write XSL templates, usually when the report is non-tabuar.
I will pursue Excel templates further then. However, I have not had any luck so far. (Please see next post.)
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 (18.104.22.168).
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
There is a bug in 22.214.171.124 which prevents named cells from being recognized in Excel templates, when those cells were named by a macro instead of manually. It works in 126.96.36.199, which is not out yet.
Let me see, I've now been waiting through four major versions of BI Publisher for some way to get true native Excel output...