I have trouble in Excel on "Windows98 " and "WindowsMe " by POI.
It 's no problem to create Excel included 2byte font(ex.japanese) on
Windows2000 and XP.
However on win98 and winMe "2byte font " Hi
My name is Venkat. I am working on a project which is using the
http //jakarta.apache.org/poi/apidocs API? I would appreciate any help that I can get.
Can somebody tell me if there is a methIs there any way to get the value of a numeric cell as a string
formatted by the cells data format? Or do I have to write a parser that
can convert to each data format myself?
Any help would be aHello all
Apologies I know similar questions come up often. However I have looked
in the archives and bugzilla and I haven 't found anything that seemed
I was trying to open a (Hi
You can also try jXLS library - http //jxls.sourceforge.net
It allows you to export data to excel using XLS templates.
It is based on POI to read and write excel file. So it preserves all macroses
Use jXLS - http //jxls.sourceforge.net
It is library designed for template-based excel export.
It uses POI to read/modify XLS template.
You can try jXLS library - http //jxls.sourceforge.net - for exporting charts in
Excel. It is based on POI but it is designed for template-based export.
I 'm trying to add some custom properties to a word document using HPSF.
It seems to work fine besides that the information is not displayed in
the properties of the document when I open it using
I 'm getting an error when using dx1 and dx2 to resize the borders of my
HSSFClientAnchor(int dx1 int dy1 int dx2 int dy2 short col1 int
row1 short col2 int row2)co
Apparently InvocationTargetException error is on the bug list
I 'm sure there are other things besides autofiltering which
can cause this error hoHello All
I am currently using POI 's HSSF to read an Excel spreadsheet from Java
using jdk 1.4. However I have a need to run the same application on jdk
1.3. Could someone tell me if POI 2.5.1 runHi Mike.
you search the archive. Then you search the desired month and the
The date I see in my Outlook. There I find a lot oHi Mike.
In January there was a thread "Data range for charts ". Maybe the
information there helps you.
Von news [mailto news@(protected)] Hi there
Can somebody advise if there is a way to work and may be modify a chart in
Excel using POI. I need to do a simple thing. I have a chart in Excel and I
need to change the cell range that thHi there
I am trying now for a few days to extract an image out of a word document. I haven 't succeeded sofar. I am afraid now that POI is not able to do this.
Has anybody succeeded in or know if Hi
I 've got a spreadsheet with values that are displayed for the user like
1 2 foo 3.00
4.00 5 bar 3.5
The formatting for each cell is not static but is up tHi Every one
I have been new to POI.
My word file may contain text and also some pictures ( like polygon
special symbols mathematical expressions ) which we draw using drawing
utilities provHi All
There is any possibilities to read .rtf files using POI.
I used POIFSReader to get the summary information from rtf files.
I got error messages like this
"java.io.IOException Invalid headHi.
If I remember it right just delimit it with \n (and avoid to also have
It was discussed long in the thread "POI line feed/Carriage Return
Problem " end of 2003.
-----I would like to set the value of the cell with the text entered in
multiple lines using
Alt Enter in Excel. Is there a way to format the same way through application?
Thank you for your replies.
Is there some way to find what are the different data formats
present in an excel sheet and to get the index of these formatted cells.
The data are generated somehow to the webpage. So you read from that
data source and write them to Excel. There 's an example in the HOWTO
documentation which should show what to do for writHI
I am trying to export data from a webpage to an excel sheet. Is there any way I can do it using POI ?
You receive the internal representation.
The % is just the external representation. So it 's the same problem like
that with the date some days ago and also something with numeric data
I have an excel sheet some cells contain % values(50% 60%
etc...).When I read from the sheet I get these values as .50 .60 etc..
Is there any way to get these values as they are in the excel shHello there people
This message is for the developers of the POI system any mailing
administrators and for anyone else who cant get their POI running.
I have been browsing the mailing list archivesHi Animesh.
In your case just getNumericValue() returns some non empty value. To
obtain your desired result you need to format this which is normal Java.
It 's a similar problem (internal and externaI am trying to extract an image (inserted as jpeg file) out of a word file. I expected that I could retrieve it from the POIFSFileSystem filesystem because when I look at the binary contents of the fi
I am using POI v 2.5.1 .
I want to read a Formula Cell which has a Numerical Value (say 05005).
The problem is that i want to read this cell as a String such that i get the Value "05005 "Now I 've found the jar that runs at 1.3. Thanks !
I would like to see if it is possible to
1- create a new excel with POI and then add some properties to it
2- open and existing excel (created with |