I have created a xlsx worksheet from an RDLC in c# .net (RDLC similar to RDL in SSRS). I use two tablix in RDLC to create the two tables in the worksheet.
When I only have 1 tablix, I can refine the worksheet after the data in loaded by applying style element to cells.
When I have two tablix, the style elements do not affect either table on the worksheet.
Do I need to refer to a specific tablix to apply style elements, and or is there a better way to do this.
In the C# code, I am trying to unmerge cells in the header, just above the data in the tablix. The area that I'm trying to unmerge is colored in red in the attached file.
I am using the following code to unmerge the cells:
Cell cell = worksheet.Cells["B1"];
Again, this code works just fine when only one tablix is used in the RDLC, but fails to work when a second tablix is placed on the RDLC.