How large is your file?
If I am correct - and I could be wrong so forgive me please Chris - the code
that was contributed uses the event driven API. Most often - although by no
means exclusively - this API is used by those wishing to process larger
files without running into memory issues; if you
No need to be embarassed, it was VERY much a guess on my part and could well
have proven to be a glorious failure. One aspect that I did fail to mention
at the time was that of course this will not be a 'real' list; it will not
have the correct style applied and will not be regarded by Word itself
You may wish to add your vote to this issue:
https://issues.apache.org/bugzilla/show_bug.cgi?id=45672
gumOnShoe wrote:
This is the only place I could find where LastCellOfRowDummyRecord was
dispatched. And, since I'm unfamiliar with what is going on, I can't be sure
where the bug is... but I a
This is the only place I could find where LastCellOfRowDummyRecord was
dispatched. And, since I'm unfamiliar with what is going on, I can't be sure
where the bug is... but I am led to believe there has to be one here... :/
Excerpt from MissingRecordAwareHSSFListener
// If we're
I have an xls file that has some blank columns for some rows.
When I use the program here (altered for tabs instead of new lines), I get a
problem:
http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/eventusermodel/examples/XLS2CSVmra.java
I receive a new line splittin
The excel file is generated automatically and come from a source. I
do not want
to modify it or manually open it.
Of course not. We all must automate, that's why we use POI.
The data I need exists in the Pivot Tables and that can change.
I want to do the equivalent of opening an test.xlsx f
Thanks David for the reply.
The excel file is generated automatically and come from a source. I do not want
to modify it or manually open it.
The data I need exists in the Pivot Tables and that can change.
I want to do the equivalent of opening an test.xlsx file in Excel 2007 and
Saving AS a te
I'm somewhat embarassed that the solution you gave didn't occur to me. It
got my results close enough. Thank you very much.
Chris Fowler
Manager, Strategic Software Development
J.W. Pepper & Son, Inc.
2480 Industrial Blvd.
Paoli, PA 19301
610-648-0500 ext. 2314
cfow...@jwpepper.com
www.jwpepper
Roberto contributed this functionality to POI - Thanks!
Here is the bugzilla titled - [PATCH] Implementation of an XLSX to XML
Exporter using Custom XML Mapping
https://issues.apache.org/bugzilla/show_bug.cgi?id=47520
When he says that it requires a Custom Mapping to work then that must
be
Thanks for the reply.
I just have to convert a xlsx to xml.
I do not have any custom mappings defined.
This is what I am doing at the moment and its throwing an exception
java.io.IOException: error: Illegal XML character: 0x3
org.apache.xmlbeans.impl.piccolo.io.IllegalCharException:
Illegal XM
Bear in mind that I have never used XWPF in anger when you read the
following; I really think that with inserting bulleted lists you are trying
to accomplish a task that the API is not really rich enough to support at
this stage and that some 'trickery' may be required.
Now, with respect to bulle
Beyond my problem with finding bullets, there seems to be some type of
trim on the run.setText() method so that I can't add leading tabs or
whitespace. Is there a reason for this and how would I accomplish the same
thing?
I'm trying accomplish something like this:
Item # 1
Item # 2
Item # 3
Hello
Our project is using cell comments to get some info from .xls files.
Code:
Iterator rowIterator = sheet.rowIterator();
while (rowIterator.hasNext()) {
HSSFRow row = (HSSFRow) rowIterator.next();
...
Iterator cellIterator = row.cellItera
Hello,
Can anyone tell me how you can add bullets and other types of mark
up to a XWPFDocument? I've found POI very simple to create a document and
add text, but I need to add a little mark up and it isn't obvious to me
how to do this. I can't seem to find any tutorials or anything. Any
Hi Andrea!
Really interesting idea.
If you allow me, i want to make a suggestion:
I doesn't see any relation with POI, maybe you are just a POI "client", but
whatever.
Im saying that because you can use the same idea to create other types of
documents in the future. XLS is just one possibility.
On Fri, 16 Oct 2009, Jan W wrote:
Our project is using dbunit to load data sets from .xls files, and
apparently dbunit is incompatible with POI 3.5. This is confirmed here:
http://www.dbunit.org/dependencies.html which says dbunit requires POI
3.2. Looking at POI source code, the function
HSSF
We need to be able to read Excel 2007 OOXML (.xlsx) files in our application,
and in order to do so, I upgraded from POI 3.0 to 3.5. However after the
upgrade, I am getting this exception:
java.lang.NoSuchMethodError:
org.apache.poi.hssf.usermodel.HSSFDateUtil.isCellDateFormatted(Lorg/apache/poi/
I can't !? ;-(
2009/10/16
> You can find the files if you go to Project Feed (bottom). The revision
> number "1" is a link to the files...
>
> Mit freundlichen Grüßen / Best regards
> Reiner Kühl
> __
>
> Reiner Kühl
> Application Developer
> IS&T
I am writing a program that is using HSSF from POI 3.2 to accept input
from remote users.
Today, one of the users sent in a file that was corrupt. When my
program tried to create its HSSFWorkbook object, it crashed with an
ArrayIndexOutOfBounds exception.
When you create a HSSF filesyste
You can find the files if you go to Project Feed (bottom). The revision
number "1" is a link to the files...
Mit freundlichen Grüßen / Best regards
Reiner Kühl
__
Reiner Kühl
Application Developer
IS&T EAD
QVC Call Center GmbH & Co. KG
Lise-Meitne
Interesting, Andrea. Not much to see yet, though.
What is the motivation for the HTML Templates? Why do we need this?
What is the relation to POI?
Mit freundlichen Grüßen / Best regards
Reiner Kühl
__
Reiner Kühl
Application Developer
IS&T EAD
Q
no files ?
2009/10/16 Andrea Lombardoni
> Document POI is a Java application that allows you to create Excel (XLS)
> files
> very easily, starting from an HTML-like template.
>
> It is licensed under the LGPL.
>
> You can find it here:
> https://sourceforge.net/projects/documentpoi/
>
>
>
>
Document POI is a Java application that allows you to create Excel (XLS) files
very easily, starting from an HTML-like template.
It is licensed under the LGPL.
You can find it here:
https://sourceforge.net/projects/documentpoi/
-
23 matches
Mail list logo
