Re: Saving MSWord97 Shapes to images

On Tue, 7 Jul 2009, shyamala wrote: I have extracted all org.apache.poi.hwpf.usermodel.Shape from HWPFDocument and would like to save them as images. Aren't those actually escher drawings, and not real images? If so, you'd need to do some work to turn them into java drawing objects to render.

[ApacheCon US] Travel Assistance

Passing this along from the Travel Assistance committee. If you'd like to come to ApacheCon US this year (there'll be some POI stuff, along with lots of other interesting bits), and the cost would prevent you attending, do please look into the travel assistance. -- Forwarded message -

Re: jsr173 vs geronimo

On Thu, 23 Jul 2009, Dale Monti wrote: In POI 3.5 there is a jar file named jsr173_1.0_api.jar which has been replaced with geronimo-stax-api_1.0_spec-1.0.jar in POI 3.6. IIRC it was a question of licensing - the geronimo implementation of jsr 173 was under a better license (apache v2, like po

Re: Embedded Excel/Word in PPT are not extracted

On Fri, 31 Jul 2009, Bijju wrote: In Event driven program of POI for the extraction of Excel/Word documents which are embedded in PPT is not happening. Event itself is not fired as "Workbook" when PPT is provided for extraction. That's to be expected, powerpoint stores embeded documents differ

Re: POI : Memory and Perfomance

On Fri, 31 Jul 2009, jayrp11 wrote: We are in process of migrating from HSSF to SS model. We have already converted our code base to SS model and while testing encountered with strange issue. Memory requirement is very high in SS model also same degrades performance while processing 2007 excel fi

Re: POI : Memory and Perfomance

On Mon, 3 Aug 2009, jayrp11 wrote: We have to find a working solution which will fit my memory requirement ( and for this matter I hope for most of the users ) !! Patches are always very welcome! :) If you join the dev list, people'll be happy to give you help and guidance on how to work on po

Re: FW: Using Jakarta POI | Facing issues

On Thu, 13 Aug 2009, Nitin Eusebius wrote: Tried to use the sample code at the links below, but the JAR files doesn't seem to work. http://poi.apache.org/spreadsheet/quick-guide.html#CreateCells You should follow the documentatio

Re: Query regarding encoding used internally by apache POI libraries

On Tue, 8 Sep 2009, Som Satpathy wrote: Does apache POI follow any particular encoding internally while extracting MS office documents? If so what is the encoding that POI uses? POI is written in Java, so uses native java strings almost everywhere. These are unicode The microsoft file forma

Re: Fwd: Bookmark in Word?

On Tue, 8 Sep 2009, nazim benbourahla wrote: Only one problem trouble this migration, and the solution will be that the bookmark of word be implemented for the last release of POI 3.5 I understand that including it, is difficult but can i have some hope and wait for it or stop the migration now

Re: Query regarding encoding used internally by apache POI libraries

On Wed, 9 Sep 2009, Som Satpathy wrote: "The microsoft file formats generally store text as either US-ASCII or UCS-2. The type of the record/block/etc tells you which it is, so we can turn that into java (unicode) strings" Thanks for the input Nick. But one thing is still not clear, can I encod

Re: matching Embedded documents in POIFS to "EMBED" links

On Sun, 13 Sep 2009, Dan Carter wrote: Is it possible to figure out which of the embedded ole objects corresponds to the "EMBED" section in a word document (i.e. to determine which one belongs where in the text)? I was naively expecting the order of each to correspond, but this isn't the case.

Re: writeProtectWorkbook() method does not work to set password to excel file to open

On Tue, 15 Sep 2009, Lingjiao.Chen wrote: I know you've mentioned that the final version will be released sometime soon (Oct). Do you for-see this functionality being included to that version? I can't see the support being added before 3.5 final by any of the core developers of poi, based on

RE: Poi 3.5 beata6 version mismatch

On Thu, 24 Sep 2009, krishna.bava...@bmwnaext.com wrote: Can I re compile the Jars with xmlbean2.4 as it's the next version is that compatible. This is the entire stack trace. I think that should be fine. The main thing is the OOXML schemas. If you download the source, there's an ant task to d

Re: Interesting Error - "Unexpected operation ptg class (org.apache.poi.hssf.record.formula.IntersectionPtg)"

On Mon, 12 Oct 2009, nikhilgonsalves wrote: For example, there are two ranges - previous (which is a vertical range -- A:A) and test ( which is a horizontal range -- A1:C1). These two intersect at cell A1. The formula is cell C1 is "=A2*previous test". This works fine in Excel but when the same f

Re: Interesting Error - "Unexpected operation ptg class (org.apache.poi.hssf.record.formula.IntersectionPtg)"

On Mon, 12 Oct 2009, nikhilgonsalves wrote: Thank you for your reply. We are using beta 3.5. Should we upgrade to final and then try? Yes. Josh has been doing lots of steller work on the formula parser, so might have fixed the bug you're hitting in the mean time! :) Nick ---

Re: POI 3.5 incompatible with dbunit?

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

Re: XSSFWorkbook create fails with xmlbeans exception?

On Sun, 25 Oct 2009, Aaron Zeckoski wrote: Caused by: org.apache.xmlbeans.SchemaTypeLoaderException: XML-BEANS compiled schema: Incompatible minor version - expecting up to 23, got 24 (schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.index) - code 3 Looks like you have two dif

Re: help with reading and editing a file with java

On Sat, 24 Oct 2009, veena pandit wrote: http://poi.apache.org/spreadsheet/how-to.html If you navigate to this link there is another link on this page that is dead. It is supposed to take you to an example on how to read and edit an excel file using java. http://svn.apache.org/repos/asf/poi/trun

Re: Where to Find Previous Releases

On Mon, 26 Oct 2009, jalove wrote: How do I get ahold of previous releases for POI? archive.apache.org holds all the old ASF releases Specifically, I'm looking for the last version that utilized Java 1.4. POI 3.2 eg http://archive.apache.org/dist/poi/release/bin/poi-bin-3.2-FINAL-20081019.

Re: Using OPCPackage with pptx files.

On Thu, 29 Oct 2009, Katie Bell wrote: There should be image and notes relationships as well, I've tried this with my own code as well as using the (mispelling is correct) XSLFSlideShow.getNodesPart(...) function. I am certain that the notes are present in the file, since i've inspected the fil

Re: API documentation required for objects returned from XWPFDocument

On Fri, 13 Nov 2009, Alan Masters (5803) wrote: I am finding a number of objects in the package root org.openxmlformats.schemas.wordprocessingml.x2006 Unfortunately to date I have been unable to find any documentation for classes in packages with this prefix and would be grateful if somebody cou

Re: POI Library Dependencies

On Wed, 4 Nov 2009, Sarah wrote: Apologies if I missed this... but is there any documentation anywhere about POI's various library dependencies? I'm not sure there is that much, no. I think David has put it on his list of things to do when updating the site though! (We track the license / at

Re: FW: HSSFCell and HSSFWorkbook symbols not found

On Tue, 17 Nov 2009, John Byrne wrote: problems: The import org.apache cannot be resolved This probably won't work - you'll want to import at least org.apache.poi, if not org.apache.poi.hssf. There's nothing in our jars from the org.apache level refers to the missing type HSSFCell

Re: HSSF output excel file size issue

On Thu, 19 Nov 2009, Cyril.Chang wrote: Issue Description : We Create an Excel File Manually with 218X1000 Cells say test_2.xls And then generate the same data via POI HSSF to output another file say test_2_poi.xls The file size test_2.xls : 1335 KB test_2_poi.xls : 3887 KB (is more than double

Re: First time user of the POI

On Tue, 24 Nov 2009, reji_jos...@veyance.com wrote: The build fails. Here is the log. Unable to locate tools.jar. Expected to find it in C:\Program Files\Java\jre6\lib\tools.jar Are you sure you have the JDK installed? However, looking back at your original error of UnsupportedClassVersionEr

Re: Unable to read entire block :202 bytes read : expected 512 bytes

On Wed, 16 Dec 2009, karthik srinivas wrote: I am trying to read an excel file using POI 2.0 (used 1.5 also) POI 2.0 is almost 6 years old, and POI 1.5 is heading on for 7 years... I'd strongly suggest you re-try with a newer version (eg 3.6 which has just come out) Nick --

Re: Ignoring Validation Errors

On Thu, 17 Dec 2009, Thomas Carolan wrote: Is there a way to ignore validation errors using XSSF? I'm not sure there is yet. As a start, I'd suggest opening a new bug on bugzilla, and uploading two files. One is a very simple 1 cell spreadsheet with the warning there. The 2nd is the same file

Re: Can't execute Java from PHP

On Sun, 3 Jan 2010, Dave Coventry wrote: The command 'java -jar /home/dave/web/drupal/java/dist/emp.jar' works fine on the command line. Could it simply be a path issue? i.e. the "java" command is on your path when run from the command line, but not when run from php? Try giving the absolut

Re: return of method getType() from HSSFHyperlink

Bastian Schurr wrote: I need to get all hyperlinks from an excel file. Therefore I wrote a little method using POI. I take the getType() method to get the type of the hyperlink, but all I got is the return value 0. It seems that HSSFHyperLink wasn't pulling through the type from the underlying

Re: Busy Developers' Guide to HSSF and XSSF Features poi.xssf.usermodel

On Wed, 6 Jan 2010, Chris wrote: Those are differents... poi.hssf.model.Workbook poi.hssf.usermodel.HSSFWorkbook poi.xssf.usermodel.XSSFWorkbook It's org.apache.poi.ss.usermodel.Workbook that you'll be wanting. The one in model has recently been renamed to help prevent people making this mist

Re: bug in cell.setCellType(Cell.CELL_TYPE_NUMERIC) (POI 3.6)

On Tue, 5 Jan 2010, Filip Defoort wrote: I've just stumbled across a bug in POI 3.6: cell.setCellType(Cell.CELL_TYPE_NUMERIC); doesn't work if the cell is anything other than blank or a numeric cell - which kinda defeats the purpose of the whole thing... Any chance you could open a new bug on

Re: Drawing class not having createCellComment function?

On Thu, 7 Jan 2010, Michael L wrote: Hi, I was trying to use a Drawing object created via sheet.createDrawingPatriarch() and noticed that it didn't have the function "createCellComment" that is used to create comments. Cast it to a HSSFPatriarch and you'll find the method you need. Drawing is

HSMF (Outlook .msg) updates

Hi All I've done a bit of a re-working of HSMF, out outlook .msg component. If you just used to use MAPIMessage, you probably won't need to make any changes at all to your code, unless you used attachments which have slightly changed. However, if you used POIChunkParser directly (eg Apache Ti

Re: Drawing class not having createCellComment function?

On Fri, 8 Jan 2010, Michael L wrote: The part of the API where it shows this is: http://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/Drawing.html Ah, it's in the javadocs, rather than the howto documentation. Javadocs on the site always reference the latest state of the API. You should

Re: WordExtractor.getText() returns ^U on word docs.

On Mon, 11 Jan 2010, maxSchlein wrote: It appears that when I use WordExtractor.getText(), and there are tables in the document, it returns  for every table column. Is there a way to have this filtered out other than looping thru the returned text. Did you try passing it through WorkExtractor

Re: WordExtractor.getText() returns ^U on word docs.

On Mon, 11 Jan 2010, maxSchlein wrote: I tried what you suggested: WordExtractor wordExt = new WordExtractor(is); String bodyText = WordExtractor.stripFields(wordExt.getText()); But the  is still in the text. Can you create a new bug on bugzilla, and upload a sample file th

Re: Null Pointer Exception in WorkbookFactory.create(input-stream)

On Mon, 11 Jan 2010, Scott Callaghan wrote: I get a null pointer exception when I use a WorkbookFactory.create() java.lang.NullPointerException at org.apache.poi.util.PackageHelper.copy(PackageHelper.java:129) at org.apache.poi.util.PackageHelper.clone(PackageHelper.java:87) at org.apac

Re: Busy Developers' BAD Guide to HSSF and XSSF

On Wed, 13 Jan 2010, Chris wrote: 1.2.ALL Workbook wb = new HSSFWorkbook(); Oops... HSSFWorkbook wb = is better ... This is deliberate. If you code to the ss.usermodel interfaces, then your code will work with both xssf and hssf 1.2.8. Iterate over rows and cells HSSFSheet sheet = wb.getSh

Re: NoSuchMethodError with slide rendering

On Wed, 13 Jan 2010, ODaniel, Robert L CTR USAF AFMC 72 ABW/SCPT wrote: When trying to render the slide to the Graphics2D object, the following errors are received: java.lang.NoSuchMethodError: org.apache.poi.ddf.EscherContainerRecord.getChildIterator()Ljava/util/Iterat or; at org.apache.poi.hslf

Re: AW: how to set character encoding in new doc file

On Fri, 22 Jan 2010, Doppelhofer Andreas wrote: Can anybody help me with this problem? Word (plus excel, powerpoint etc) can store strings as unicode or non-unicode. POI works only with java unicode strings, and handles reading and writing the strings to the appropriate kinds of bytes for you

Re: XSSFWorkBook is not in poi-3.6.jar

On Wed, 10 Feb 2010, Bjoern Thalheim wrote: My problem is: The class XSSFWorkbook is not contained in the JAR which I get when I fetch version 3.6 of POI with maven by using: org.apache.poi poi 3.6 That's because you didn't include all the POI artificats. If you want to

Re: Exception in thread "main" java.io.IOException: Could not find all blocks

On Fri, 19 Feb 2010, William Lindner, III wrote: I have an excel file that I can open in Excel, but when I attempt to open as an input stream and read as a new POIFSFileSystem(inputStream), I get the stack trace: First question - have you tried with the latest poi? Second question - if you loa

Re: XLSX2CSV bug?

On Fri, 19 Feb 2010, Prenom Nom wrote: After searching a little bit more, i've tried the "Yegor" version with same result: The most recent version is in svn under src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java Exception in thread "main" java.lang.IllegalArgumentExcep

Re: xls file reading skipping record

On Fri, 19 Feb 2010, khan379 wrote: I am seeing an issue with the HSSF reader to read a xls file. if the first column of my xls file is blank then the reader is not reading the record at all. That's probably because excel decided not to put a record there at all. You only get blank records gen

Re: Bug in HSSFCellStyle.getDataFormatString( ?? )

On Fri, 19 Feb 2010, David Law wrote: It would seem there is a problem in HSSFCellStyle.getDataFormatString(). Delving even deeper, HSSFCellStyle relies on a static list from BuiltinFormats. The concept of fixed standard Builtin formats used in poi does not seem to hold water. It's not our co

Re: Extract embedded files in Word 97 Documents (hwpf)

On Fri, 19 Feb 2010, amp834 wrote: Does anyone have sample code for extracting embedded files from Office 97 .doc files? Take a look at getEmbededDocsTextExtractors in src/ooxml/java/org/apache/poi/extractor/ExtractorFactory.java While it's focused just on text extraction, it ought to be a go

Re: Exception in thread "main" java.io.IOException: Could not find all blocks

On Fri, 19 Feb 2010, William Lindner, III wrote: The file was not originally written by Microsoft Excel, so I would assume this is the problem. Unfortunately, I do not have the ability to change how the file is created. You might be able to put a workaround into poifs. The place it's breaking

Re: Conversation Index using HSMF

On Fri, 5 Mar 2010, emile83 wrote: We are parsing .msg files using HSMF to link all emails pertaining to a particular conversation. However i am unable to obtain a conversation index for each email(i.e. PR_CONVERSATION_INDEX (PidTagConversationIndex)). HMSF offers the conversation topic. Any i

Re: Suppressing cell errors like xlNumberAsText

On Fri, 5 Mar 2010, Robert Tomanek wrote: I would like to programmatically (via POI) set the Ignore property for cell errors to True. There's currently some low level record support for this, via FeatRecord / FeatFormulaErr2. However, there's no usermodel support for this, as no-one's come up

Re: Suppressing cell errors like xlNumberAsText

On Mon, 8 Mar 2010, MSB wrote: That's a surprise Nick because I just did some simple testing myself - using Excel - and could not store these settings in the file. It's not impossible that your version of excel isn't storing them in the file, despite that being possible! Pages 669 and 67

Re: SummaryInformation class

On Mon, 8 Mar 2010, kavita deshpande wrote: What is the alternative for spreadsheets created in Excel 2007 i.e. those that are XSSFWorkbook?? org.apache.poi.POIXMLProperties handles this for you for the ooxml files You can look at the text extractor stuff to see it in use Nick --

Re: NoSuchMethodError

On Wed, 10 Mar 2010, MPras wrote: I am encountering the following exception when trying to read an xslx file. Could someone help me understand why? Thank you. java.lang.NoSuchMethodError: See the FAQ - http://poi.apache.org/faq.html#faq-N10006 Nick ---

Re: Populating EXCEL Templates using configuration files

On Tue, 16 Mar 2010, Richard Holmes wrote: So for me the following worked 1) Load the Excel Workbook as normal for processing. *this*.filesystem = *new* POIFSFileSystem(excelInputStream); *this*.workbook = *new* HSSFWorkbook(*this*.filesystem); 2) Register a read listener on the Root directory

Re: Populating EXCEL Templates using configuration files

On Tue, 16 Mar 2010, Richard Holmes wrote: Thank you this is what I was looking for, I am pretty new to this only started using it a couple of weeks ago so don't know everything available. http://poi.apache.org/poifs/index.html is a good starting point when working with POIFS - both the direct

Re: Read data from excel file in matrix.

On Wed, 17 Mar 2010, Tyagi wrote: Is there any way through which I get 5 cells for each row ? http://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFWorkbook.html#setMissingCellPolicy(org.apache.poi.ss.usermodel.Row.MissingCellPolicy) Nick

Re: reading xls or xlsx file using SS model

On Mon, 22 Mar 2010, khan379 wrote: khan379 wrote: we often get xlsx file so i was planning to switch to POI 3.5-FNAL and use SS model to read both xls and xlsx formats. the class i have attached heavily uses org.apache.poi.hssf.eventusermodel and i dont know much how i can convert this file to

Re: reading xls or xlsx file using SS model

On Mon, 22 Mar 2010, khan379 wrote: can i implement same low level + low memory event based parsing for xlsx files ? (using XSSF or SS model, doesnt matter). This gives an example of low level parsing of XLSX workbooks with XSSF and sax: http://poi.apache.org/spreadsheet/how-to.html#x

Re: Removal from List

On Thu, 25 Mar 2010, Zachary Mitchell, BCIS wrote: Could this email address, please be removed form the POI users list? See http://poi.apache.org/mailinglists.html You can unsubscribe yourself, just send an email to user-unsubscr...@poi.apache.org from the address you wish to unsubscribe Ni

Re: How to read meta from ms words file

On Mon, 29 Mar 2010, Thet Naing Soe wrote: I am a user of Apache POI API. I would like to extract metadata from microsoft word 2007 docx file. I couldn't find how to extract metadata from docx file. Take a look at POIXMLPropertiesTextExtractor - that shows you how all the different kinds of OO

Re: Parse Excel 2007 with Java 1.4

On Mon, 29 Mar 2010, Hingu, Sanjay (MLITS) wrote: Is there anyway I can get poi 3.5 working with java 1.4? I mean I want to parse excel 2007 (.xlsx) file with java 1.4 Java 1.4 was EOL'd getting on for 3 years ago, you really ought to think about upgrading to a version of Java that sun still s

Re: "org.xml.sax.SAXParseException: does not close tag ." when opening some .xlsm files

On Mon, 29 Mar 2010, MSB wrote: Good work Paul and it is equally interesting to know that version 3.5 does not throw the exception as that will help the developers to isolate the issue IMO. I have a hunch that it might just be that POI 3.5 didn't parse that bit of the file. 3.6 processes a fe

Re: How to create a simple instance of XWPFDocument with POI?

On Wed, 7 Apr 2010, philip.gillis...@bayerbbs.com wrote: I'm trying to create a simple docx file with POI but I don't know how and I don't find much information on the web. I'm not sure if that's supported yet. You might have more luck with creating a template empty file in word, and editing c

Re: Process java memory

On Fri, 9 Apr 2010, Alberto Pedrera wrote: Thanks for you attention. Yes, I have tempted to get 3.6 but unfortunately the problem is present. I'd suggest you get a profiler (many of them have free trials for example), and run your app under that. Hopefully that'll give you some ideas on where

Re: Is there a way to "refresh" or "apply" the workbook values/formats?

On Sun, 11 Apr 2010, Ramon F. Herrera wrote: (*) I get the little upper-left triangle and the warning sign: "The number in this cell is formatted as text or preceded by an apostrophe." See the list archives, as this was discussed recently. Currently there's record level support for this, but n

Re: The supplied POIFSFileSystem does not contain a BIFF8 'Workbook' entry. Is it really an excel file?

On Thu, 15 Apr 2010, Andre-John Mas wrote: I am trying to read an Excel 2007 file and I running into the following issue: java.lang.IllegalArgumentException: The supplied POIFSFileSystem does not contain a BIFF8 'Workbook' entry. Is it really an excel file? Your file isn't in the expected st

Re: The supplied POIFSFileSystem does not contain a BIFF8 'Workbook' entry. Is it really an excel file?

On Thu, 15 Apr 2010, Andre-John Mas wrote: This is the tree I am getting: Root Entry - EncryptionInfo EncryptedPackage _DataSpaces - TransformInfo - StrongEncryptionTransform - Primary <(0x06)Primary> Version DataSpaceMap DataSpaceInfo - StrongEncryptionDataSpace

Re: The supplied POIFSFileSystem does not contain a BIFF8 'Workbook' entry. Is it really an excel file?

On Thu, 15 Apr 2010, Andre-John Mas wrote: What I don't seem to understand is why the Excel 2003 parser (HSSF) is being used when I call WorkbookFactory.create() on this file, instead of the Excel 2007 parser (XSSF). The file ends in '.xlsx'. Since you got the output that you did from POIFSLis

Re: PST Outlook Format

On Fri, 23 Apr 2010, Dave Coventry wrote: Is POI able to look at Outlook PST files? HSMF should work with most outlook .msg files. I've no idea how close they are to .pst ones though. It's probably worth comparing the output of org.apache.poi.poifs.dev.POIFSLister on a .msg and a .pst file to

Re: why only double for cell.setCellValue? BigDecimal/Long/Integer

On Sun, 25 Apr 2010, Dave wrote: But the Cell.setCellValue(...) has double type for numeric, it does not have method for BigDecimal, Long and Integer. The excel file format only supports storing doubles. Excel doesn't support anything else. If converting these types to double, it lost accur

Re: Can we edit spreadsheets using XSSF?

On Sun, 25 Apr 2010, MSB wrote: It might be worth posting a question to the list with this sort of title - 'How do I extract the complete OOXML archive from Maven?' Or 'How to extract individual archives from the Maven repository?' Something like thit should elicit a more cific response I would

Re: Can we edit spreadsheets using XSSF?

On Mon, 26 Apr 2010, Ramon F Herrera wrote: Have you tried to edit an XSSF spreadsheet? That is what triggered the problem. Yes, but generally only simpler spreadsheets Nick - To unsubscribe, e-mail: user-unsubscr...@poi.apac

RE: Max number of rows in an HSSFSheet? Max row num for HSSFRow? Excel 97?

On Mon, 26 Apr 2010, Mark Barnes wrote: I do have the source for POI 3.6, but I just wanted to know if anyone knew of a technical reason why the limit was hard-coded -- like if some counter was a short value that might overflow, for instance -- before proceeding. If you look at RowRecord.java

Re: Is it possible to read a table from Excel

On Mon, 26 Apr 2010, Sony Antony wrote: these are not embedded files. But tables created by : 1. select a rectangle region of cells 2. From Home -> Format as Table > Medium I'd suggest you create a very simple file without tables, and save it. Then, open a copy, and add a very simple table, an

Re: Can we edit spreadsheets using XSSF?

On Mon, 26 Apr 2010, MSB wrote: Sadly, I cannot build a 'complete' ooxml-schemas archive on the source that I checked out of SVN - ant reports that a file is missing - so do not have that archive to dig into, but it seems as though this is the cause of the problem. Someone seems to have removed

Re: Support for custom properties

On Wed, 19 May 2010, Parag Doke wrote: I wanted to ask if POI supports (in decreasing order of interest :-) ): 1) Creation/modification/deletion of custom properties 2) Modification of built in properties HSPF should do all of this for you: http://poi.apache.org/hpsf/ I'd suggest starti

Re: Problem using newline in XSSFRichTextString (a bug, perhaps?)

On Fri, 21 May 2010, Guilherme Mussi wrote: I am making a tool to translate html to a XSSFRichTextString When i find a br tag, i'm simply appending a \n character, like this: richTextString.append("\n", font); Unfortunately, if i do this, the .xslx file gets damaged and doesn't open correctly

Re: Problem using newline in XSSFRichTextString (a bug, perhaps?)

On Fri, 21 May 2010, Guilherme Mussi wrote: the xml generated by poi with I think something (your editor? email client?) has munged the xml. Any chance you could re-post it having double checked that you have the real thing? <#> and - are both a sign of something having gone wrong... (At th

Re: Problem using newline in XSSFRichTextString (a bug, perhaps?)

On Fri, 21 May 2010, Guilherme Mussi wrote: just to make it clear: the problem is with excel itself when i append just a "\n" in the XSSFRichTextString, it creates a node with just a newline character. The problem is excel simply ignore this node (it pops up a warning message saying the file is

Re: Problem using newline in XSSFRichTextString (a bug, perhaps?)

On Fri, 21 May 2010, Guilherme Mussi wrote: visually, excel represents my file without the newlines. To check - does excel not show the newlines in excel, or do you mean it shows them but you can't spot them in the xml? excel saves its own newlines like this: text before the newline So it

Re: Performance Issue with POI 3.6 as compared to 2.5.1

On Mon, 24 May 2010, K raghavendra Rao wrote: I was using POI 2.5.1 to generate .xls files until the record count crossed the 65k+ limit set by Excel 2003. At this point, I switched to POI 3.6 and to XSSFWorkbook (from the previous HSSFWorkbook) This'll be the main cause. My hunch is that you'

Re: Get Cell FillForeground and FillBackground Color

On Tue, 25 May 2010, Vj Ali wrote: I want to get the FillForeGround color index and FillBackGround color index of the Cell. But its returning 64 for background and Zero for foreground index(In case of XLSX type). In case of XLS foreground color index is retrieving correctly. Is the data store

Re: Embedded word document with web page content doesn't get extracted

On Tue, 25 May 2010, Gitu wrote: I have attached an excel file which has few objects embedded in it. If you excel file has other office documents embeded in it, then these documents are stored seperately and you need to handle each one individually If you're just doing text extraction, take

Re: parsing property streams from .msg files

On Wed, 26 May 2010, Arjohn Kampman wrote: Please excuse me if this has been asked before (couldn't find anything in the archives), but does POI and/or HSMF supporting parsing of properties from the property streams of msg files? Fixed length properties values such as the send date seem to be sto

Re: parsing property streams from .msg files

On Wed, 26 May 2010, Arjohn Kampman wrote: Thanks for the quick response. I've been doing quite a bit of reading through these specs already. It looks fairly easy to parse this particular data stream. The problem I always find with the outlook stuff is that the documentation is strewn across

Re: autoSizeColumn issue

On Fri, 28 May 2010, calintz wrote: I'm currently using poi-3.6 to generate excel file. It is working well in my development environment(window xp & jdk1.6.0_20). When i try to generate excel file in my production environment(centOS 5 & OpenJDK 1.6.0-b09), i found that autoSizeColumn does not pro

Re: getPageCount() is not working

On Tue, 1 Jun 2010, Mr Zappee wrote: This code does not throw any exception, but it is not working very well, because getPageCount() always return to 1. I tried it to lots of *.doc files, but the value of getPageCount was always 1. I suspect that if you look in office, it'll show a pagecount o

Re: getPageCount() is not working

On Tue, 1 Jun 2010, Mr Zappee wrote: I check the number of pages in word. The statistics page shows that the document contains 16 pages. If you view the statistics and re-save the file, does word correct the property information? How can I update the properties? Can I update it with apache

Re: XSSF POI /var/tmp protection issues

On Fri, 4 Jun 2010, TARAF, WALID (ATTSI) wrote: We have an issue where we have a Unix box with a few vtiers, and when a user first creates an XLSX, it creates the file under "/var/tmp/poifiles" with a random file name Take a look at org.apache.poi.util.TempFile for how this comes about. II

Re: Can't open .XLSX files.

On Fri, 4 Jun 2010, Jorge Moya wrote: So, I downloaded the new .jars, updated the code and migrated to SS, but unfortunately it won't open .xlsx (while .xls does fine). Two key bits of the stack trace: [java] Caused by: java.lang.RuntimeException: Could not instantiate SchemaTypeSystemImp

Re: Can't open .XLSX files.

On Fri, 4 Jun 2010, Jorge Moya wrote: I'm pretty sure I'm using XMLBeans2.3 and I even tried XMLBeans2.4 to no avail. Check your classpath. I suspect there's an older version on there too, and since something like xmlbeans-2.1.0.jar sorts before xmlbeans-2.3.0.jar you'll normally get the olde

Re: Power Point Viewer

On Fri, 4 Jun 2010, Túlio Severiano wrote: I am using this example. But it does not display the background or text formatting. Any help? http://poi.apache.org/slideshow/how-to-shapes.html#Render I suspect that these are bits that still need work. Your best bet is to identify the shape object

Re: Performance Issue with POI 3.6 as compared to 2.5.1

On Wed, 9 Jun 2010, K raghavendra Rao wrote: Any thoughts regarding this? Any thoughts or suggestions would be greatly appreciated. XSSF and HSSF are quite different. One is binary based, one xml based, and that's why they behave differently. However, if you really want performance and low me

Re: Extracting "Last Ten Authors" info from ms word documents

On Tue, 15 Jun 2010, Abdulkadir Poşul wrote: Is there any method or a way to extract last ten authors info of ms word/97 documents by using apache POI project I'm not aware of where in the file that gets stored, so I think it's unlikely that it's currently directly available. HPSF should let y

Re: openxml4j InvalidFormatException

On Thu, 17 Jun 2010, Jorge Moya wrote: One last question, actually: Do you guys have any idea why xercesImpl and xercesImpl.2.9.0 are causing a conflict with POI and .xlsx data? If both files are stored in the endorsed folder, it'll state the "can't find file" error, but if I remove any of the

[Announce] POI 3.7 beta 1

Hi All It's been about 6 months now since 3.6 FINAL, and the changelog [1] shows we've fixed a fairly hefty number of bugs, even if there haven't been that many new features. So, we've decided to do a new release, of POI 3.7 Beta 1. Along with the very large number of bug fixes, there have b

Re: Auto Filter

On Fri, 25 Jun 2010, DavidZaz wrote: Can anyone verify that is correct? I believe it still remains to be added If it was not implemented, are there any pointers about how I could get it added? You'll need to add support for the various records, and then write some usermodel code to make it

Re: Newbie: Problem using XSSFEventBasedExcelExtractor in 3.7 beta1

On Wed, 7 Jul 2010, William Graham wrote: In using either the getText or processSheet methods it seems that this extractor somehow treats an empty cell as not actually being there when it returns the delimited text. That's because in the file format, empty cells really aren't there! (.xlsx is

Re: Newbie: Problem using XSSFEventBasedExcelExtractor in 3.7 beta1

On Thu, 8 Jul 2010, William Graham wrote: That's because in the file format, empty cells really aren't there! (.xlsx is a zip file of XML files, so you can unzip it and see for yourself. Empty cells are skipped.) When using the usermodel, we can detect this and return an empty cell for you if req

Re: Updating the text of a XWPFParagraph using Apache POI

On Sat, 10 Jul 2010, Mathias Dahl wrote: I have been able to loop through all paragraphs in a document and get at the text and everything and I have read and understood how you can create a document from scratch. But how can I update and replace the text in a paragraph? Each run has the same ch

Re: Implement cell forumula border feature

On Sun, 18 Jul 2010, allelopath wrote: Excel has a feature in which when you dbl-clk on a cell with a formula, the cells referred to by that formula become correspondingly colored. I need to implement this in Java with POI. The formula parser is where you'll want to be looking. You probably w

  1   2   3   4   5   6   7   8   9   10   >