I'm sure there a few instances, but your search is bit inaccurate. It
includes test and dev classes, scratchpad, etc... if you exclude those I
wonder how many system.foo.print we have.
On Mon, Nov 19, 2018 at 10:07 AM Sawan.Patwari
wrote:
> Hi Andi,
> There were around 91 matches to the
Assuming new XLSX format -- I had one of these and opening it, the sheets
contains the last cached value that was in the excel workbook. POI can
read that value without issue.
Now if you need the latest data then that's another issue.
On Wed, Jun 10, 2015 at 7:33 AM, Mark Beardsley
Are you using POI-HMEF to read in the RTF? Not that it matters, but I
don't believe HMEF and HSSF/XSSF or SS are directly linked.
You'll have to read and store all the formatting information, then create a
new XSSF document and apply the formatting you want.
From your output I suspect you're
In an individual cell, 32767 characters is the Excel limit. It has nothing
to do with POI but POI is rightly limiting so that you can't write a file
that you can't read or will not be as intended.
XLS format:
It's a simple string at that point, use SimpleDateFormat or Jodatime to
convert it to whatever you like.
Although not best practice I usually build a static block of various
SimpleDateFromat checker that I use with a loop and an empty catch block to
find the right format match. That'll allow you
Why not just system copy the file?
On Mon, Dec 8, 2014 at 6:56 PM, Blake Watson blake.wat...@pnmac.com wrote:
Is it possible?
I'm guessing I could create a new workbook and clone all the sheets but I'm
worried I might miss something.
--
*Blake Watson*
*PNMAC*
Application Development
It's still a POJO, no matter how fast or how many copies you need.
On Tue, Dec 9, 2014 at 11:56 AM, Blake Watson blake.wat...@pnmac.com
wrote:
Because it's in memory, and I need a fresh copy every few seconds. =P
On Tue, Dec 9, 2014 at 12:30 AM, Aram Mirzadeh a...@mbcli.com wrote:
Why
Just open the template, manipulate as needed, save to a different location.
Or
Use FileCopy to copy the template to it's destination, then open it and
manipulate it.
On Sat, Dec 6, 2014 at 8:03 AM, j.ballada...@verizon.net
j.ballada...@verizon.net wrote:
Hi all,
I check this link of examples
You can set the value to whatever you want it to be, but if you set it to
$123,456.00, it'll be stored as a String.
If you want it to be numeric, then you have to set the value of the cell to
a numeric value (123456), then apply the formatting to it.
On Fri, Nov 21, 2014 at 4:34 PM, Blake Watson
There exists a test class/interface just for this, search for classes that
implement the ExcelExtractor interface.
for
example:
./src/ooxml/testcases/org/apache/poi/xssf/extractor/TestXSSFEventBasedExcelExtractor.java
On Tue, Nov 11, 2014 at 5:06 AM, Jebarlin Robertson
You may have to post your code to see where the problem is then.
On Wed, Oct 22, 2014 at 6:43 AM, ms_guruvai ms.sankaralin...@gmail.com
wrote:
Sorry we able to get good rows when file cotanins exactly 65536 rows or
less
than that. After that even if we increase one or two rows also we
65535 would be the hard limit on short and older xls files.
If you're processing 65538 maybe you're running out of heap space? Try
increase your Xmx.
On Tue, Oct 21, 2014 at 2:07 PM, ms_guruvai ms.sankaralin...@gmail.com
wrote:
yes!. we are not using any short type. still only prcoessiong
Hi,
Is there a function matrix available for the other projects? (excluding
the event and streaming)
http://poi.apache.org/resources/images/ss-features.png
Thanks.
Thanks Nick.
I was hoping for a for the component level support matrix. I'll use the
text provided on the overview page.
Aram
On Tue, Sep 16, 2014 at 9:02 AM, Nick Burch apa...@gagravarr.org wrote:
On Tue, 16 Sep 2014, Aram Mirzadeh wrote:
Is there a function matrix available for the other
Because they're passed by reference not by content. You're better off
just re-creating the table as needed than copying an existing one.
On Sat, Sep 6, 2014 at 12:28 PM, 尘 445335...@qq.com wrote:
Hi, everybody,
I need to generate a complex docx file which mainly contains many
tables. I
http://stackoverflow.com/questions/6452765/how-to-increase-heap-size-of-jvm
On Mon, Sep 1, 2014 at 6:42 AM, Ajeet V. Singh ajeet.si...@mastek.com
wrote:
Hi Team,
I am using apche POI-3.10, I have to read an sample.docx file and write
its content to new sampleOutput.docx file.
However I
Hi,
Is it me or you can't set a solid background color on cells?
I need to highlight a couple of rows of data, is there any other
alternatives? I'm already using text coloring for other purposes.
Aram
-
To unsubscribe,
It's a JDK 7 problem ... if you can recompile with 1.6 it'll work.
On 3/3/2014 4:39 PM, Crocker, David wrote:
Hi,
I'm struggling with the worksheet.autoSizeColumn() method. I've looked over
posts on the web, but can't seem to tease out what I'm doing wrong. I followed
all of the advice
Not sure if this is the best way or not.
I have found with XSLX, it's much easier to unzip the file and go
through the media directory and grab an image that I need rather than
trying to do it with the POI API. It's a hack but it works.
On 3/3/2014 5:42 PM, Steve Lamont wrote:
Dear all:
On 3/3/2014 8:01 PM, Steve Lamont wrote:
Never mind.
I'm an idiot.
spl
-
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail:
Hi,
I have an existing document with a place holder in it.
I need to replace the place holder with a table with some rows and columns.
How do I convert a XWPFTable object to a Run object so that I can
document.addRun(myTable)?
Thanks.
On 12/11/2013 11:12 PM, Nick Burch wrote:
On Wed, 11 Dec 2013, Aram Mirzadeh wrote:
The first 15 rows (all columns), the text of the cell is replaced
with a numeric value, it's the same value each time but I can't
figure out where it's coming from.
Commenting out the cell.setCellType
I have this method for a number of years and I think when I upgaded to
3.10-beta1 I started to see this odd behavior. I'm also running 64-bit
jdk build 1.7.0_25-b17, in eclipse Juno (64bit) on windows 7 (64bit).
The first 15 rows (all columns), the text of the cell is replaced with a
, Yegor Kozlov wrote:
We never had such a method. With POI you can clone a sheet in a
workbook, that's similar but not qiute the same.
Yegor
On Fri, Oct 12, 2012 at 12:50 AM, Aram Mirzadeh a...@mbcli.com wrote:
Hi,
I might be losing my mind, but I thought I had seen a method that copied
Hi,
I might be losing my mind, but I thought I had seen a method that copied
a sheet from one workbook to another. I can't seem to find it now. Am
I dreaming? Was there ever such a util class?
Aram
-
To unsubscribe,
( at some level and in XML version ) because even
if it fails to open correctly, you can apply the sytle to the cells
again and save it/open it and it works.
Aram
On 5/9/2012 1:22 PM, Nick Burch wrote:
On Mon, 7 May 2012, Aram Mirzadeh wrote:
Recently, after we upgraded to 3.8 we started to have
Solution -- don't use a singleton to create your styles.
On 5/9/2012 7:02 PM, Aram Mirzadeh wrote:
I created a bug and attached a test case for this in bugzilla, #53209.
I am creating ahead of time in a singleton and then just applying them
to the cells. I included the singleton
Hi,
I'm tracking down an issue with one of our excel generators. The
programs copies then modified a standard template and fill it in with a
ton of data.
Recently, after we upgraded to 3.8 we started to have a strange
behavior. The excel file would open in a corrupted state, and excel
I have to do some automated power point modifications to an existing
template file (PPTX, although it has no PPTX features being used).
What I need to do is find and duplicate slides, find and replace text,
insert a couple of graphics (bar, pie charts). The master is nicely
setup, with
On 8/30/2011 11:21 AM, Nick Burch wrote:
On Tue, 30 Aug 2011, Aram Mirzadeh wrote:
At this point, is it worth working with XSLF if no features are being
used? Or am I better off sticking with OLE for now until we can
improve XSLF further?
You'll likely find that HSLF is better developed than
with OOXML, it works in 3.7, no idea about 3.2 or OLE2.
On 12/24/2010 7:38 AM, Sai Smriti Mohapatra wrote:
Hi,
Has anyone been able to edit cell formats on a password protected HSSFSheet
created using POI-3.2?
I am creating a HSSFSheet with locked and unlocked cells and protecting it
with a
It sounds like you changed the POI library codes and now it doesn't
work. This isn't a IDE problem. After you made the change did you
run through all of the various test-cases? Did you write a new
test-case for your new functions?
My suggestion is to trace it down in Eclipse to the
This is from my code for XSSF:
POIXMLProperties.ExtendedProperties props =
getProperties().getExtendedProperties();
props.getUnderlyingProperties().setApplication(© 2010 TranquilPhotos.com);
The props are very limited capabilities as far as I know though. For
example I have a lot of custom
You're 100% right, I had that somewhere else in my LIbrary jar and I
never realized it was getting called.
On 12/18/2010 8:53 AM, Mark Beardsley wrote:
Hello Aram,
I have had a dig around and think that, in this case, the OP needs to call
the getCoreProperties() method of the
Just in case it helps you in this case -- I was doing the same thing and
having all sorts of issues until someone pointed out you can just copy
the template using system copy and then modify what you want rather than
do it programmatically.
On 12/15/2010 1:35 PM, Narayanan wrote:
I can
It isn't a graphic it's a text box but the content is still editable as
text.
If not, can you post the workbook.xls file.
On 12/10/2010 3:45 PM, Risken wrote:
Why is it that the generated xlsx file containing 2 images and one textbox
gives such strange result when I try dragging the
On 12/10/2010 6:51 AM, Mark Beardsley wrote:
Hello Nick,
No, that does not seem to work for me. The result is that the workbook in
the embeddings folder is actually empty or blank following the write
operation and using the OutputStream obtained from the PackagePart object.
Also, deleting the
If I try what you suggest, the output file is actually corrupted. I can
still open the resulting word document in office (the original image is
there, but it's no longer an excel embedded file) - I think the image
that shows up is a cached image. If I try to open it back in POI, I get
all
This works for me, these are created as part of style generation, which
are global
// - Hyperlinks - by default hyperlinks are blue and underlined
hLinkStyle = wb.createCellStyle();
final Font hLinkFont = wb.createFont();
hLinkFont.setFontName(Ariel);
On 12/8/2010 8:06 PM, Nick Burch wrote:
On Wed, 8 Dec 2010, Aram Mirzadeh wrote:
Let me make sure I'm on the right path here, because this isn't
sticking in my head yet.
1. Open the docx
2. Get all embedded part as pPart
3. Use pPart.getPartName().getName() to get the name of the embedded
On 12/7/2010 7:56 PM, Nick Burch wrote:
On Tue, 7 Dec 2010, Aram Mirzadeh wrote:
On 12/7/2010 12:47 AM, Nick Burch wrote:
On Sun, 5 Dec 2010, Aram Mirzadeh wrote:
I'm trying to update the values for the excel chart. I can read
the docx, get the embeded object, and read and modify the cells
I just did this in 3.7-release and it worked for me. The cell kept the
existing style (which was just bolded). Just a note that I use SS
style to be consistent, rather than switch back to XSSF as you have done
here.
Aram
On 12/8/2010 4:14 PM, Rohan Grover wrote:
Hello all,
I am
On 12/7/2010 12:47 AM, Nick Burch wrote:
On Sun, 5 Dec 2010, Aram Mirzadeh wrote:
I'm trying to update the values for the excel chart. I can read the
docx, get the embeded object, and read and modify the cells that I
need. My question is how do you save the embedded excel file?
You'll
Forgot to mention that I'm on POI 3.7.
Thanks.
On 12/5/2010 10:38 PM, Aram Mirzadeh wrote:
Hi,
I'm reading in a docx (2007 xml based [actually it's from word 2010])
file which has a Excel chart embedded in it (suprisingly it isn't
xlsx, it's binary xls file format).
I'm trying to update
Hi,
I'm reading in a docx (2007 xml based [actually it's from word 2010])
file which has a Excel chart embedded in it (suprisingly it isn't xlsx,
it's binary xls file format).
I'm trying to update the values for the excel chart. I can read the
docx, get the embeded object, and read and
Hi,
Is the functionality to remove a link from a cell (internal link to
another sheet) exist in XSSF? I cannot seem to find it in any of the
javadocs.
Thanks.
-
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
I've been using XLSM files for a while now I think, using 3.7b1 now so
it was supported at some point or maybe if you don't touch the macro
part of it -- it has always worked.
I changed your code to use SS model and it works fine --
public static void main(final String[] args) throws
I've run into the same error at least and it turned out to be
surprising enough, illegal characters for XML without being escaped.
Either check the source data coming in or add in all of the checks to
make sure the data you're inserting doesn't haveetc...
On 8/20/2010 9:30 AM,
Hi,
I have a template XSLM file that I use as the basis for the output
file. In HSSF I just duplicated the workbook via:
private static POIFSFileSystem duplicateTemplate(final String
outputExcelFile, final String templateFile) {
POIFSFileSystem fs = null;
Really the only reason is the verification of the content being actually
a valid excel file. Although I can come up with something else during
the template upload to verify that and not do it here.
On 8/6/2010 10:55 AM, Mark Fortner wrote:
Is there some reason that you're not using
I still haven't been able to find anything further on this. Is this
something that is not implemented?
On 7/27/2010 9:21 AM, Aram Mirzadeh wrote:
Hi,
Two questions:
1) I'm adding in an image (png) to a slide, there doesn't seem to be a
way of getting the width and height of the image
Hi,
Two questions:
1) I'm adding in an image (png) to a slide, there doesn't seem to be a
way of getting the width and height of the image via the Picture class.
Is there a class that I'm missing that can provide this or do I just
have to read in the file seperately and figure out it's
This is an old joke and off topics so I apologize in advance for both.
But don't you love the sound of deadlines? Specially as they fly
right by?
Aram
Yegor Kozlov wrote:
We plan to release 3.5-FINAL by October 1.
Stay on the mailing list and watch for announcements.
Yegor
There's got
private final static char bulletChar = 8226;
deep4u wrote:
Hi Mark,
what is the character value for arrow type of bullet. can u send
out what are available characters.
Thanks,
MSB wrote:
I am just weak and could not resist having a play. Anyway, here you go,
how to
Hello,
I have a task to update the properties (custom variables) of a DOCX file
(Office 2007). I tried looking on POI's website but I can only find a
reference to a XPFFWordExtractor but not much else in terms of docx
support. I know it's still in very early development, but I was hoping
Hi,
I'm just finished with my HSSF project and I already need to start
looking at moving to XSSF. The size of the file in HSSF is just
unworkable at this point.
Now I know the XSSF coding is nowhere near as mature of the HSSF code.
Is there a list of functions/areas that have been
Hi I just downloaded the last SVN and am trying to build it on Vista
64. 'ant jar' does work, so I can continue, but just wanted to report
this -- this is the result of 'ant dist'
site:
BUILD FAILED
c:\POI\build.xml:847: The following error occurred while executing this
line:
57 matches
Mail list logo
