Thanks a lot ook. That's what I want!
2008/3/28, ook? ook! <[EMAIL PROTECTED]>: > > 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] > > > > > > > > >
