 | | | POI | | When I generate a sheet with this function
IF(COUNTBLANK(G11 I11) 0 SUMPRODUCT(G11 I11 $G$10 $I$10)/SUM($G$10 $I$10) " ")
(if there is at least one blank column the result should show blank anHi
I want to extract text from an excel file that is embedded inside another excel file. Is there any tool to do that.
Dipankar.Hi All
When I have tested the POI and JExcelAPI which are both open
standards I have identified that JExcelAPI is much better than
POI 's HSSF
The Reasons are
1. it can handle formulae
2. II need to load serveral workbooks take the first sheet of each and
combine them into one workbook.
I 've looked and see know way to do this other then iterating through
each cell and copying the
Hi all
does anyone know how to delete a HSSFCellStyle object from the styles collection
of a workbook.
Or if it is somehow possible to add a self-created HSSFCellStyle to the
collection
I am new to POI and am running into some problems trying to create a new
report using a template in POI 2.5.
I found a similar problem being reported in POI 2.0 but the bug report said
that it waHi everybody
the jakarta news page (http //jakarta.apache.org/site/news/news-2004-1stHalf.html) mentions that POI 2.0 added codepage support for HPSF.
Now I have downloaded POI 2.5 from http //whi
following the example under scratchpad i tried
to detect headings in a word doc by comparing
the style name of the paragraph with "Heading... ".
unfortunately the doc has been created with Hi Developers
I wanted to know whether it is bug of POI or POI is not
supporting this document format (It seems The format is in Word
97 only). When I try to extract the text from the attached
Hi Developers
I wanted to know whether it is bug of POI or POI is not
supporting this document format (It seems The format is in Word
97 only). When I try to extract the text from the attached
Hi Jean.
In the family of LOOKUP functions in Excel some work better and some not
so good.
Does the cell even not contain a formula?
Regards Karl-Heinz.
-----Urspr?ngliche Nachricht---Sorry to be a pain I have asked this question once before never got a
reply and then the project went on hold.
Question does POI support range names that cover more than one continuous
range ofHi Steve.
Try something like
HSSFCellStyle oCS oWB.createCellStyle()
oCS.setDataFormat(HSSFDataFormat.getBuiltinFormat( "@ ")) // text
Does it also happen then?
I didn 't discover such phello ppl
I have a assignment to convert a dynamically generated jsp page(with images)
to excel . I 've been able to obtain the same use the following code snippet
...
response.setContentTypeI am creating a HSSFWorkbook with HSSFCell and it works pretty well.
The cells are created using text values not number values and when this is
viewed in Excel none of the cells can be formatted usiHi Dong.
Excel macros aren 't lost when you modify Excel files using POI (2).
I never had to use (1).
Regards Karl-Heinz.
-----Urspr?ngliche Nachricht-----
Von Dong Chen [mailto Dong.C
Hi
I 'm new to POI/HSSF and this mailing list.
I have some questions regarding using Macros in Excel through POI
1) Can I use POI to write (export) VBScripts macros to an Excel spreadsheeI will be out of the office starting 12-May-2004 and will not return until
17-May-2004.
I will respond to your message when I return.
For Engineering or Elixir issues contact David Cowen
ForI 'm using POI to insert a VLOOKUP and a SUMIF formula in a cell.
However when opening the workbook the cell is completely empty.
Is VLOOKUP and SUMIF supported in POI ?
Thanks in advance
> Let me see if I get it straight. Please suppose I have a
> simple table with 1 title row two data rows and 6 columns.
> Each of these rows has it 's own fill color and each of the
> data cHi Dmitry.
We had such effects when we used copied and modified templates. POI was
bringing an "unknown Ptg 3D warning " and Excel made problems. Building
the templates from the scratch led to proHi
I 'm facing a strange problem which I suspect may stem from a obscure
error somewhere in POI code.
I 'm generating excel files from a template. Pretty much just finding
certain cells usHi
Let me see if I get it straight. Please suppose I have a simple table with 1 title row two data rows and 6 columns. Each of these rows has it 's own fill color and each of the data columns has Hello
I have a question concerning the possibility of sorting by a column
I fill and generate an excel-sheet with two separate list of datas. Both
sets of data share the same key. Now befo
Hi
I want to get thumbnails of some MS Office documents. (Only first pages)
I 've found some information about PropertyIDMap and Thumbnail classes but
I 've problems about implenenting
Why when I try to put a paragraph in a table the word document
gets corrupted?
Is there possible to do this?
And another thing how can I assign Hi All
1. How to parse the complex files of Word Document. What are the
problems that the developers are facing in developement of API
for Word Fast Saved Documents.
2. Are people are able to
I 'm trying to programmatically update an Excel spreadsheet that is in shared mode. (Tools- >SharedWorksheet... Allow Changes by more than one user at a time On). It 's a status worksheet that several Hello All
I have asked this question before but nobody was interested in it. So I am pestering you again.
How to use the "HSSFCellUtil " class without having to put many of the apache jars in > I have some issues reading in certain kinds of cells. Specifically I
> have a few date cells that I want to read in. My code looks
> like this
>
> String aDate
>
> String.value |
|
|
