I'm trying to format a spreadsheet using the tagset.ExcelXP tags and am having problems trying to figure out if the following is possible. The ExcelXP tagset is being used to add filters, frozen headers and multiple worksheets.
---------------1------------------------
Adding a two line header in the report that spans 9 cells for each line. I unable to find an example of this. Is it possible to add a two line embedded title to the spreasheet and specify how many columns it will span?
---------------2------------------------
Changing how the data is being placed. The output currently follows the standard format with the labels across the top and the data filling in the cells below. Is it possible to change the data layout?
We are trying to acheive something similar to the following:
Header1 (span 9 columns)
Header2 (span 9 columns)
Obs1
Label1 Value1 Label4 Value4
Label2 Value2 Label5 Value5
Label3 Value3
Obs2
Label1 Value1 Label4 Value4
Label2 Value2 Label5 Value5
Label3 Value3
.....
Instead of:
Header1
Header2
Label1 Label2 Label3 Label4 Label5
Value1 Value2 Value3 Value4 Value5
Value1 Value2 Value3 Value4 Value5
.....
... View more