This project has moved and is read-only. For the latest updates, please go here.

Add functionality to disable freeze frames in Excel export in ExcelReportWriter

May 6, 2011 at 1:51 AM

Could you please add the functionality to disable/enable the freeze frames and the Header/Body split in the Excel export? I have compiled my source to not include this but it would be handy to turn it off and on.

The culprit:

        sb.AppendFormat(@"
                <x:FreezePanes/>
                <x:FrozenNoSplit/>
                <x:SplitHorizontal>{0}</x:SplitHorizontal>
                <x:TopRowBottomPane>{0}</x:TopRowBottomPane>",
                        numberOfHeaderLines + 1);

 

I had some users download the report and get confused as they were not aware of this functionality in Excel. Thankyou for DoddleReport!

Cheers,

Jeremy Child