I've done that, I can show you, I promised to send out the code but didn't get the chance, I will do it asap.
Basically you have to write into .xml file like Mark said. I get the syntax. On Mon, Apr 11, 2011 at 2:32 AM, Mark Beardsley <[email protected]>wrote: > I was certain someone had done exactly this recently so my first step would > be to search back toruhg the messages on the ists for the past few weeks > and > see if you can track them down. If you do, post a message onto that thread > in the hope they are watching/listening to it and will respond. If you > cannot find that poster then the best way to do what you are after is to > modify the BigGridDemo program itself so that you create and then export > the > correct xml syntax to the file. > > 1. Using Excel, create a simple workbook that has a freeze pane set. Save > that file to disc. > 2. Rename the file you created in step one above, give it a .zip extension. > 3. Unzip the renamed file into a folder on your machine. > 4. Look through the xml markup in the various files to see what Excel has > created to set the freeze pane. > 5. Modify the BigGridDemo program so that it creates the same xml markup > and > exports it into the appropriate files. > > Once you have made this change, consider posting the information onto the > list so that others can benefit from what you have done. > > Yours > > Mark B > > > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/How-To-Set-Freezing-for-BigGridDemo-tp4295267p4295276.html > Sent from the POI - User mailing list archive at Nabble.com. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
