This splits the document into two panes - top and bottom. It seems that all freezing is defined in the WorksheetOptions XML node. Freezing panes helps and keeps the important header row(s) always on top (the numbers are corresponding to the picture on the right hand side): Select the cell, whose the row above and the column on the left you want to freeze. After selecting your row, navigate to View in the header toolbar and select Freeze Panes. For this example, I’m selecting row number three to freeze row number two. To see how this fits into the rest of the XML, please see my entry on creating Excel documents using ColdFusion and XML. The function in Excel is called ‘Freeze Panes’. To freeze a specific row in Excel, select the row number immediately underneath the one you want frozen. Here is how I have been doing this - this demonstrates only a given XML node of the overall XML document. This can be most useful for header rows (frozen row) or ID columns (frozen column). ![]() One of the things that is highly useful is freezing a pane (number of rows / columns) in an Excel document such that the rest of the document scrolls and the frozen cells stay in place. ![]() So, this is just trial and error until I can get that documentation up and running. ![]() There is an XML Schema that you can download and install, but it doesn't seem to be working on my computer. I have been tinkering around with creating Excel files using ColdFusion and XML and have been figuring out how different Excel features are defined.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |