[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-user
Subject:    Re: How to get the workbook ref in Apache POI formula (e.g. formula [CELL])?
From:       Nick Burch <apache () gagravarr ! org>
Date:       2013-04-09 10:31:31
Message-ID: alpine.DEB.2.00.1304091130130.6735 () urchin ! earth ! li
[Download RAW message or body]

On Tue, 9 Apr 2013, Huang Xin wrote:
> I want to implement a Excel formula that is CELL function use the Apache 
> POI.
>
> It will return the Current Excel workbook filename when the cell eval 
> expression is =CELL("filename").

How will you get the filename for the workbook though? In most cases, POI 
doesn't know what the filename is. In quite a few cases, there is no 
filename!

(POI will open from a file or an inputstream, and most kinds of 
inputstream are not file backed, so there's no filename to go with them)

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

[prev in list] [next in list] [prev in thread] [next in thread]