Hi there. Maybe I don't understand your need, but don't it'd be easier and lighter to use HSSFSheet.setDisplayGridlines(false)? http://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFSheet.html#setDisplayGridlines(boolean)
HTH. 2008/3/28, Moody Lee <[EMAIL PROTECTED]>: > > Thanks Nick. > > I've not found any API to do so till now. > And I've compared the two excel files using hssf.dev.BiffViewer. > > The following description differs in the result. > ================================================= > Offset 0x24fd (9469) > recordid = 0x23e, size = 18 > [WINDOW2] > .options = 6b6 > .dispformulas= false > .dispgridlins= true > .disprcheadin= true > .freezepanes = false > .displayzeros= true > .defaultheadr= true > .arabic = false > .displayguts = true > .frzpnsnosplt= false > .selected = true > .paged = true > .svdinpgbrkpv= false > .toprow = 0 > .leftcol = 0 > .headercolor = 40 > .pagebreakzoom = 0 > .normalzoom = 0 > .reserved = 0 > [/WINDOW2] > ================================================= > This is the descriptions of the file with gridlines displayed. > The "disgridline" property is set to "false" when the gridlines not > displayed. > > Hope this useful... > > Best Regards, > Moody > > 2008/3/27, Nick Burch <[EMAIL PROTECTED]>: > > > > > On Thu, 27 Mar 2008, Moody Lee wrote: > > > I'm working with POI 3.0.2-FINAL, using it to generate some report. > > > Does anyone know how to perform the following action by API like I'm > > > operating the Excel file? > > > > > > I'm not aware of anything, so if you've searched and couldn't find the > > answer, it might not currently be possible > > > > What you'll probably want to do is create a very simple excel file, > > without grid lines. Save that, then turn on grid lines, and save to > > another file. Use the various dev tools (poifs.dev.POIFSViewer and > > hssf.dev.BiffViewer) to spot what excel changed between the two files. > > > > Once you know that, it should hopefully be fairly easy to support it > > nicely in poi. Until we know what records get changed / added / removed, > > supporting it isn't really possible > > > > > > Nick > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > >
