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]
>
>
