Re: Apache POI functionality breaks in JAVA 17

On Thu, 5 Jan 2023, Dhaval Kaushik wrote: Also, this error only comes on using tomcat and java 17 version. The apache-poi version is 3.14. On upgrading to a higher version it breaks some existing code which is not correct. So is apache-poi not compatible with java 17 in tomcat? Apache POI 3.14

Re: font problem or wrong usage

On Fri, 9 Sep 2022, Peter Busfy wrote: This class (StyleCreator) where I hold all styles, are created per workbook. And all styles are in this StyleCreator class initialized only once. Hmm, that's the most obvious cause excluded For a workbook where one sheet is happy and one sheet isn't: *

Re: font problem or wrong usage

On Fri, 9 Sep 2022, Peter Busfy wrote: I started using POI recently. And I ran to one interesting issue with fonts. I have one dedicated class where I store all styles which I use in my project. Here in this class, I also hold font. So far, I just need only one font in whole project. So, I

Re: Thread Safety of sheet operations

On Mon, 16 May 2022, Andreas Reichel wrote: Of course I am fully aware that POI is not thread safety on workbook level and threads can only be used as long as every sheet is processed within its own thread (without altering styles). We only ensure that you are safe if each workbook is created

Re: org.apache.poi.xwpf.usermodel.XWPFDocument Set start/end Page to extract text

On Sat, 23 Oct 2021, nskarthik wrote: Process : POI 4.1.2 ,jdk15 ,win10 You should consider upgrading to Apache POI 5.0 - there have been quite a few fixes since then, see http://poi.apache.org/changes.html#5.0.0 Question : Extract Text only from MS-Word docx/doc from specific pages (

Re: Reading Massive Excel Files to csv

On Mon, 3 May 2021, Oscar Bastidas wrote: Thanks Nick for the updated link. I've updated the link in the sources for the site, hopefully one of the other devs who has all of the tools installed can republish shortly With your comment on moving to Gradle, does this mean there will be a time

Re: Reading Massive Excel Files to csv

On Mon, 3 May 2021, Oscar Bastidas wrote: I am trying to read a large Excel spreadsheet (60,000 rows) but I get what appears to be a memory leak error from the JVM when I use the *XSSFWorkbook *API. I learned recently that there are size limitations on Excel files being read in this way and

Re: Invalid CellReference:1A

On Wed, 10 Feb 2021, Ash B wrote: While reading the file in java , getting below issue . java.lang.IllegalArgumentException: Invalid CellReference:1A at org.apache.poi.ss.util.CellReference.seperateRefParts A cell reference of 1A is invalid - it should be A1. Where is this problematic file

Re: Upgrade to 5.0.0 resulted in IOException message

On Fri, 5 Feb 2021, Bryan Coleman wrote: That makes sense. I am using an ant script to unjar individual jars and then to create a mega jar from my classes and those APIs. I am keeping the services files. That said, I noticed that both the main poi and the poi-ooxml jar have services files

Re: Upgrade to 5.0.0 resulted in IOException message

On Wed, 3 Feb 2021, Bryan Coleman wrote: java.io.IOException: Your InputStream was neither an OLE2 stream, nor an OOXML stream or you haven't provide the poi-ooxml*.jar in the classpath/modulepath - FileMagic: OLE2, having providers: [org.apache.poi.xssf.usermodel.XSSFWorkbookFactory@40086342]

Re: Floating Point Arithmetics, reading 0.1066913 gives 0.10669129999999999 --> GNUMERIC vs LibreOffice vs Excel

On Sun, 20 Oct 2019, David Law wrote: the Cells have no Format.  Take a look at the attached File, cell F10. Andreas tells me it was entered as 0.1066913 & that's how its displayed too, although it has no format. Numeric cells have a default format if nothing else is applied, it could be

Re: Floating Point Arithmetics, reading 0.1066913 gives 0.10669129999999999 --> GNUMERIC vs LibreOffice vs Excel

On Sun, 20 Oct 2019, Andreas Reichel wrote: Opening the file in an XML Text Editor, I get 0.106691299. Opening the file in GNUMERIC, I get 0.106691299. (Both the shown cell content as well as the editable text box). Opening the file in LibreOffice, I get 0.1066913. (Same file, I

Re: Hyperlink() special case

On Thu, 29 Nov 2018, Greg Woolsey wrote: The first argument to the function is the target URL, the second argument is optional display text. The current implementation returns the display text, if present, as the function value. This is correct, as that's the value displayed, but if you want

Re: CLI for POIFS

On Wed, 21 Nov 2018, Jarl Friis wrote: As explained on http://poi.apache.org/components/poifs/index.html POIFS is a library to handle POIFS files just like a zip-container. Is there a command line tool to just unpack any OLE2, i.e. POIFS file? org.apache.poi.poifs.dev.POIFSDump may do what

Re: Disabling Logging in POI 3.15

On Mon, 19 Nov 2018, Sawan.Patwari wrote: There were around 91 matches to the 'System.out.println' statements in the POI-3.15 source-code Apache POI 3.15 is now over 2 years old, and several security issues have been fixed in newer versions. What happens when you upgrade? Nick

Re: POI 4.0.0 issues with new commons-compress library "InputStream of class [..] is not implementing InputStreamStatistics"

On Sat, 29 Sep 2018, Jörn Franke wrote: as part of the HadoopOffice library ( https://github.com/zuinnote/hadoopoffice/wiki) we provide the functionality to read office documents, such as MS Excel, on Big Data platforms, such as Hadoop/Hive/Spark/Flink. We should probably list that on the

Re: Create XSSFWorkbook

On Fri, 7 Sep 2018, Tony Obermeit wrote: Thanks. Much progress, now it's failing on: org.apache.xmlbeans.XmlException. I think that's part of ooxml-schemas-1.3.jar, trying to find a downloadable jar. Nope, that's in xmlbeans itself. If you download the binary release of Apache POI, it's in

Re: Create XSSFWorkbook

On Fri, 7 Sep 2018, t...@tamborine.to wrote: This document and others gives a snippet: new XSSFWorkbook() or workbook = new XSSFWorkbook() This fails: unable to resolve class XSSFWorkbook See http://poi.apache.org/components/index.html#components - XSSF (and the other OOXML classes) require

Re: Workbook saved using POI 3.16 needs to be repaired when opening in Excel 2016

On Fri, 22 Jun 2018, Quinton McCombs wrote: The nightly build does not have this problem although 3.17 does. Is there a workaround until 4.0 is released? Keep using the nightly build? (I'd actually recommend a nightly build from about a week ago, there's a bunch of changes happening right

Re: Workbook saved using POI 3.16 needs to be repaired when opening in Excel 2016

On Fri, 22 Jun 2018, Quinton McCombs wrote: I have run into a problem after upgrading from POI 3.14 to POI 3.16. With POI 3.14, I can load a workbook, save it, and then open in Excel 2016 without a problem. However, after upgrading to POI 3.16, the workbook needs to be repaired after opening

Re: Application fails with Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/poi/xwpf/usermodel/XWPFDocument

On Sat, 10 Feb 2018, Marco Lechner - FOSSGIS e.V. wrote: Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/poi/xwpf/usermodel/XWPFDocument     at de.bfs.dokpool.faq.importer.FaqImporter.main(FaqImporter.java:23) Caused by: java.lang.ClassNotFoundException:

Re: upgrade from 3.16 to 3.17 fails with cannot access org.apache.poi.wp.usermodel.Paragraph

On Sun, 11 Feb 2018, Marco Lechner - FOSSGIS e.V. wrote: when I try to upgrade to 3.17 from 3.16, I get the following error: cannot access org.apache.poi.wp.usermodel.Paragraph [ERROR] class file for org.apache.poi.wp.usermodel.Paragraph not found This class is contained within the main

Re: POI snapshot jars

On Fri, 15 Dec 2017, pj.fanning wrote: Do we publish poi snapshot jars to a maven repo? I checked http://repository.apache.org/snapshots/ but didn't find poi jars. On the whole, the ASF isn't a huge fan of letting "general end users" work with nightly builds/snapshots. Generally, there's a

Re: getCellType and getCellTypeEnum

On Tue, 14 Nov 2017, polatalemdar wrote: http://poi.apache.org/apidocs/ Can you show me what is the description of the deprecation and what alternative we can use in this documentation? The website always shows the latest javadocs. As such, it shows the new Enum-returning version as not

Re: getCellType and getCellTypeEnum

On Tue, 14 Nov 2017, polatalemdar wrote: Can you explain what should we use if both of them are deprecated? Did you read the full deprecation notes in the javadocs for the version of Apache POI you are using? That explains what is happening, and what to do in the mean time Alternately,

Re: Conditional Formatting issue

On Wed, 18 Oct 2017, Blake Watson wrote: I've attached a greatly reduced version of the spreadsheet. About 15 cells with one conditional. I've tried to reduce it further but can't seem to do it without altering the error. Actually, that might be important. Most of my tweaks, if they don't fix

Re: Conditional Formatting issue

On Wed, 18 Oct 2017, Blake Watson wrote: Related: I downloaded Eclipse and POI to build a test case, but I'm kind of at a loss. I haven't been able to run the tests from Eclipse. The steps ought to be: * Ensure you're on a version of Eclipse that supports Java 8 * Checkout from svn / git *

Re: Conditional Formatting issue

On Tue, 10 Oct 2017, Blake Watson wrote: I'm trying to create a simplest example of this but I have a situation where I: 1. Load a workbook with a conditional. 2. Create a FormulaEvaluator for that workbook. 3. Create a ConditionalFormattingEvaluator for that workbook and evaluator. 4. Create a

Re: Corrupted xlsx file on just one server

On Thu, 7 Sep 2017, Seb Duggan wrote: Notice the differences in the first two lines... There is a minimal difference in the Java version on the servers: my local computer is running 1.8.0_112, staging is running 1.8.0_45, and live (producing the corrupt files) is on 1.8.0_66. All are Oracle

Re: Fwd: Clarification on Actual Date from Excel

On Thu, 8 Jun 2017, sridhar vr wrote: We are working on a requirement. where in excel the value is 05/06/2017, but while retrieving the values comes as 05-Jun-2017. That looks correct to me! It also would look correct to most of the world too... See the handy map on

Re: IS it safe to write to multiple sheets from threads?

On Sat, 13 May 2017, yevsh wrote: Is it safe to write to multiple sheets that belong to same workbook, from multiple threads? No It is safe for multiple threads to write to their own workbooks. However, all operations on a single workbook must be done from the same thread Nick

Re: Java API for Excel

Apache Commons CSV talks the Excel CSV variant (amongst others - it's configurable) Nick On 21/04/17 22:48, Javen O'Neal wrote: I'm guessing that an Excel CSV file is a regular CSV file that is written in a specific dialect (quoted strings,

Re: Evaluating Arbitrary Formula

On Wed, 19 Apr 2017, Greg Woolsey wrote: Missed the 2nd half of the question. This class only returns rules that match the current state of the workbook for a given cell - rules that would be applied were it open in Excel. Note that this logic is limited to evaluating functions actually

Re: How to identify date cell type using XMLStreamReader (poi's XSSFReader api)

On Wed, 29 Mar 2017, kakadi wrote: Can you please give me an example on how to get formatIndex and formatString for my above example as isADateFormat(int formatIndex, java.lang.String formatString) expects both the parameters Take a look at XSSFSheetXMLHandler - that shows how to get the

Re: Apache POI - Detecting difference between an xlsx file and a normal zip file

On Wed, 22 Mar 2017, Thiyagarajan wrote: I have an InputStream wrapped in a BufferedInputStream and I'm trying to detect whether it is a normal zip file or a xlsx file (and take appropriate actions accordingly). I have tried to use hasOOXMLHeader

Re: xssf writing large numbers

On Tue, 31 Jan 2017, Cem Dayanik (Ibtech-Software Infrastructure) wrote: While I searched quite a lot in net, I havent able to find an exact solution. I havent able to write a number with 16 digits. Ex) 3340005973272861 That's an excel limitation, or rather a limitation in the various Excel

Re: How do you code cell striping?

On Mon, 12 Dec 2016, Eric Douglas wrote: I found one sample that shows how to code the condition using org.apache.poi.ss.usermodel.SheetConditionalFormatting.addConditionalFormatting() to put in the formula that would color each cell if it's in an even numbered row, but I'm having trouble

Re: poifs: Orphan VBA directory entry when removed

On Mon, 5 Dec 2016, Maxime GUERREIRO wrote: I'm trying to remove a directory structure from a Composite Document File V2 Document file, and my code is working in every cases I could test except one. Here it is: https://gist.github.com/mguerreiro/7023cab737917e936ac40857cdc12035 sampleCall is

Re: Dependencies of APACHE POI

On Fri, 18 Nov 2016, Sateesh K Kolusu wrote: Hi - How/Where do we exactly know the versions of dependency components for APACHE POI 3.14 ? For human-readable, see http://poi.apache.org/overview.html#components For machine-readable, see the maven poms for the components you use, eg

Re: Restarting styled numbered/lettered lists

On Thu, 3 Nov 2016, Jim Klo wrote: As I toiled away trying to figure out how to restart styled bulleted/numbered/lettered lists without messing with the applied numbering style - as there seems to be a lack of reasonable examples (in both the unit tests, and existing documentation and

Re: POI-3.15: Commons-Collections-4 vs. Jasper Reports' dependency on Commons-Collections-3

On Wed, 26 Oct 2016, Andreas Reichel wrote: Sine POI 3.15 the software depends on commons-collections-4 (previously it depended on commons-collections-3 only). There is however another good software library "Jasper Reports", which still depends on commons-collections-3 and also Apache POI.

Re: Linking External Workbooks

On Thu, 6 Oct 2016, Blake Watson wrote: That's just how Excel stores it for XLSX files. The link table provides the mapping between those indexes and the names shown in Excel. When POI hits one of those, it goes to the link table to find the name of the file, then checks for a setup referenced

Re: Linking External Workbooks

On Wed, 5 Oct 2016, Blake Watson wrote: I've also tried putting in "[1]" or "1" in the map rather than my spreadsheet name. I don't see in all this how the spreadsheet name in Excel comes out as "[1]" in POI. That's just how Excel stores it for XLSX files. The link table provides the mapping

Re: BigGridDemo for a RichText

On Sun, 2 Oct 2016, Ratna wrote: Could you please specify the XML format for each cell,as mine is not working Don't use BigGridDemo any more! You should use SXSSF instead Nick - To unsubscribe, e-mail:

RE: Formulas don't throw exceptions but show up "#NAME"

On Tue, 13 Sep 2016, Justin Flowers wrote: OK, it was a sanity issue on my part. Apparently you can get this issue if a UDF is not defined. And of course I wrote a Java UDF here that it cannot find on its side. The functions I'm implementing already exist in Excel, just not yet in POI

Re: Including poi-ooxml-schemas

On Thu, 11 Aug 2016, Branden Visser wrote: So it begs the question, what is the intended usage of this "poi-ooxml-schemas" dependency? http://poi.apache.org/faq.html#faq-N10025 Nick - To unsubscribe, e-mail:

Re: Reading xlsx file using poi3.7

On Tue, 14 Jun 2016, pavanikureti wrote: I will change the poi jars with the suggested version. I am using few more jars also as below. javax.xml.stream-1.0.1, xmlbeans-2.3.0.jar, dom4j.jar, ooxml-schemas-1.0.jar Are these fine? See http://poi.apache.org/overview.html#components for the

Re: Reading xlsx file using poi3.7

On Tue, 14 Jun 2016, pavanikureti wrote: I am using following jars javax.xml.stream-1.0.1, poi-3.8-final-jdk1.4-20120520-rc1, poi-3.8-final-jdk1.4-ooxml-20120520-rc1, xmlbeans-2.3.0.jar, dom4j.jar, ooxml-schemas-1.0.jar Can you please let me know am I using the correct jars? Nope, you should

Re: CTLongHexNumber

On Thu, 2 Jun 2016, Murphy, Mark wrote: Is there a way to use CTLongHexNumber without it causing a type cannot be resolved error? The error is: The type org.openxmlformats.schemas.wordprocessingml.x2006.main.CTLongHexNumber cannot be resolved. It is indirectly referenced from required .class

Re: How to write normal and subscript text in one excel cell?

On Thu, 2 Jun 2016, janek.schroeder wrote: I want to insert normal text and subscript/superscript (eg. CO2) in one excel cell. You want to use RichTextString functionality. See the docs for more: http://poi.apache.org/spreadsheet/quick-guide.html#RichText And also some examples, eg

Re: extracting hyperlinks from xlsx with XSSFEventBasedExcelExtractor?

On Thu, 12 May 2016, Allison, Timothy B. wrote: On TIKA-1454, one of our users asked to add extraction of hyperlinks from xlsx. It looks like hyperlink info appears at the end of the sheet.xml (after the in the section). Are there any recommendations for merging hyperlink info with the

Re: not implemented subtotal functions (101-111)

On Tue, 26 Apr 2016, Jean Rossier wrote: I'm wondering if there is any roadmap to implement the subtotal functions with the option "ignore hidden values" (function code 101-111) ? https://poi.apache.org/apidocs/org/apache/poi/ss/formula/functions/Subtotal.html We'd love a contribution for

Re: POI not parsing these XLS file

On Thu, 21 Apr 2016, Andrew Munn wrote: I can not get POI to parse these XLS files being generated by Bloomberg into something useful. I can use Tika to parse them into one long line of HTML but then there are no cell breaks or line breaks.

RE: New POI problem

On Fri, 15 Apr 2016, Thaddaeus Fillmore - US wrote: Thanks for the reply! I actually got it to work using ExtractorFactory though. (I had a typo in the path to the jar files). Is Tika just for Office documents or can it also read other formats? Ideally I'd like something that could process

Re: New POI problem

On Fri, 15 Apr 2016, Thaddaeus Fillmore - US wrote: Gah, I'm back. Ok, so now I'm trying to extract the text from a word document being uploaded to the server. (This is all in coldfusion). I first write a temp copy of the file to the disk. I have verified the file writes successfully and

Re: Need Help with XWPFDocument issue

On Wed, 13 Apr 2016, Thaddaeus Fillmore - US wrote: Hello, I'm venturing into using POI to extract text from Word documents. For some reason when XWPFDocument initializes from my FileInputStream, there's and exception generated from java.util.zip.InflaterInputStream.

Re: Digging into Conditionals....

On Tue, 29 Mar 2016, Blake Watson wrote: I did a bit of stuff on it, enough to solve a $DAYJOB need, then stopped again. Creation and Reading should both cover most things you want. Modifying ought to have most things, but might need more work, especially as it probably doesn't check enough to

Re: Digging into Conditionals....

On Thu, 24 Mar 2016, Blake Watson wrote: We're trying to figure out how to apply conditionals to our spreadsheets, and have noticed that it looks like some work is being done in this area I did a bit of stuff on it, enough to solve a $DAYJOB need, then stopped again. Creation and Reading

Re: Reading .xlsm file with more than 1 millions of rows

On Wed, 23 Mar 2016, arashmoeenj wrote: Thank you for your reply. I'm pretty new to Apache POI and the concept of excel parsing, so is there any example for 'mid-level SAX-based SheetContentsHandler' that I can refer to ? Umm, the one from my previous email? Nick

Re: Reading .xlsm file with more than 1 millions of rows

On Wed, 23 Mar 2016, arashmoeenj wrote: In my project I have to parse a xlsm file which contains more than 1 million rows (separated in multiple sheets each containing 1 million rows at maximum), and do some validations on the cells. I've tried so many examples provided by Apache POI and

Re: Reading (not writing) conditional states: possible?

On Wed, 24 Feb 2016, Blake Watson wrote: Thanks for the response, Nick! I guess we'll have to roll our own... And contribute it back? ;-) Nick - To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional

Re: Reading (not writing) conditional states: possible?

On Wed, 24 Feb 2016, Blake Watson wrote: So, there's lots of examples on how to write out conditional stuff to Excel files. If you look at the unit tests, you'll see quite a few examples of reading conditional formatting too But I've got an Excel workbook with some conditional cells in it

Re: When using SAXParser to parse xlsx file, blank cells are skipped

On Mon, 22 Feb 2016, Lynn Li wrote: When using SAXParser to parse xlsx file, blank cells are skipped. Does anyone have code to not skip blank cells using SAXParser? Any help you can provide is appreciated. You just need to keep track of the cell reference of the last cell seen, and spot

Re: Ability to set solid color on DataBarFormatting

On Wed, 3 Feb 2016, Maheshwar Jayaraman wrote: Interesting. The spec from 2009 (https://msdn.microsoft.com/en-us/library/hh656506(v=office.12).aspx) does have the attribute but I see POI is using 2006. Is there a reason its not updated? Nick, Any pointers? I've got a feeling that someone

Re: Ability to set solid color on DataBarFormatting

On Wed, 27 Jan 2016, Maheshwar Jayaraman wrote: I have one question. Which branch should I submit the patch on? Trunk or REL_3_11_branch? Trunk - we're working up to 3.14 final at the moment! Nick - To unsubscribe, e-mail:

Re: Ability to set solid color on DataBarFormatting

On Tue, 26 Jan 2016, Maheshwar Jayaraman wrote: The default is gradient fill for a data bar. I wanted it to be a solid (I think it translates to a gradient=0 attribute). I spent enough time trying to set this via reflection that I think I can take a stab at adding a patch for this. I will read

Re: Change chart type programmatically?

On Sat, 9 Jan 2016, Ken Hausam wrote: I am using XSSFChart and associated classes to create a line chart using Apache POI. Works great! Thanks. My question is, is there an easy way to change the chart type programmatically from a line chart to a stacked bar chart? I looked quickly at the

Re: 3.12 org.apache.poi.ss.formula.FormulaParseException

On Thu, 3 Dec 2015, Brian Milnes wrote: As I don't know how to correctly elide the format, I'll send you the long text. It seems to be a defined name, perhaps some type of print area? Looks to be a named range What do you get if, on the first sheet, you just type into a cell

Re: 3.12 org.apache.poi.ss.formula.FormulaParseException

On Thu, 3 Dec 2015, Brian Milnes wrote: I have a strange bug that I can't quite grasp. org.apache.poi.ss.formula.FormulaParseException: Unused input [[llave]] after attempting to parse the formula [[1]!tbltipoentidad[llave]] Do you know what the formula is supposed to mean, and what Excel

Re: 3.12 org.apache.poi.ss.formula.FormulaParseException

On Thu, 3 Dec 2015, Brian Milnes wrote: It evaluates to #NAME as it's a broken formula of some type. If you take the same string, and type it into a new formula, can Excel cope? Does it accept it, or error? Nick - To

Re: Advice on tracking down an error thrown by evaluateAllFormulaCells()

On Wed, 25 Nov 2015, Javen O'Neal wrote: Nick Burch said: See http://people.apache.org/~yegor/apachecon_us2010/Evaluation_Of_Excel_Formulas_In_POI.pptx for information on how evaluation works, functions, ptgs etc, if it's new to you This presentation would have been helpful when I was first

Re: Advice on tracking down an error thrown by evaluateAllFormulaCells()

On Tue, 24 Nov 2015, Tom Chiverton wrote: So, TREND() isn't implemented. Why don't I get a NotImplementedException then ? I'll see if I can knock up a quick implementation to contribute. POI only has some support for array functions, so I wonder if it's tripping up on that first? A trend

Re: Advice on tracking down an error thrown by evaluateAllFormulaCells()

On Tue, 24 Nov 2015, Tom Chiverton wrote: I am trying to evaluate all the formula's in an Excel file. There are about a dozen sheets, with several tens of formula on each, all driven by a few input fields on the first sheet. This all works fine in Excel 365 itself. However, when I try and run

Re: Reading Excel 5.0/7.0 files

On Mon, 23 Nov 2015, bestfrieend wrote: can anyone please tell me how to read older excel files? Apache POI doesn't have any high-level APIs for working with the older Excel file formats. If you just want the textual contents, then there's org.apache.poi.hssf.extractor.OldExcelExtractor

Re: Will poi library support reading encrypted excel file?

On Wed, 18 Nov 2015, Ni Lei wrote: I tried to read Excel files which are protected with password, but got the EncryptedDocumentException. That's a sign that you need to have the password and to do the decryption! Case 1: when reading .xlsx file: Caused by:

Re: Data format

On Thu, 12 Nov 2015, Javen O'Neal wrote: In one POI project I'm working on, I am writing a date to a cell. I'm using CellStyle datetStyle = workbook.createCellStyle(); dateStyle.setDataFormat(22); Is there a POI constant that I can use instead of the number 22?

Re: InvalidFormatException with OPCPackage or XSSFWorkbook

On Thu, 5 Nov 2015, Jonathan Hodges wrote: Yes this file is from online and likely generated in a non-Excel system. When I re-saved the file it works. All this makes sense why it isn't working, but is there any other work around besides re-saving via Excel, preferably a programmatic option?

Re: InvalidFormatException with OPCPackage or XSSFWorkbook

On Thu, 5 Nov 2015, Jonathan Hodges wrote: When I attempt to open an Excel file (.xlsx) file I receive the following stack trace. org.apache.poi.openxml4j.exceptions.InvalidFormatException: The part /_rels/.rels does not have any content type ! Rule: Package require content types when

Re: Formula not working as expected

On Thu, 5 Nov 2015, Jason Tomforde wrote: A1 string cell = 1 A2 numeric cell = 2 A3 numeric cell = 3 A4 formula cell = IF(A1=1,A2,A3) The result I am getting is 0. Any thoughts? Are you evaluating the formula when you're doing with settings cells? http://poi.apache.org/spreadsheet/eval.html

RE: Drawing Borders is SLOW

On Thu, 5 Nov 2015, Murphy, Mark wrote: My thought was to build the borders on their own, then once the borders are created, apply them to the cell styles in a single step. This would require a few new objects. You are going to have to change poi.apache.ss.util.CellUtil.setCellStyleProperty

Re: moving formulas, or, what version of Poi should I use?

On Thu, 5 Nov 2015, Ralph Johnson wrote: When I started looking for info on changing formulas in Poi, I realized that 3.6 is woefully out of date and that 3.13 has much better support for updating cell references when you insert rows. So, I installed 3.13 and made sure the system worked with

Re: Excel Files using XSSFWorkbook over a certain size display an excel error when I open the .xls file in excel

On Wed, 4 Nov 2015, Schene, Chris wrote: I am using the code below to create a very large spread sheet that is 47 rows wide. There are a few very large strings in the rows, but for the most part the data is fairly small. If the .xls file is over about 1000 rows I get an error when I load the

Re: Drawing Borders is SLOW

On Tue, 3 Nov 2015, Murphy, Mark wrote: I am sure you all know this. But the problem increases as the number of styles grows. In looking at the code, I am convinced that the problem can be found in the fact that when borders are drawn, the cell style is retrieved, the border is applied, and

Re: method to return POI version?

On Fri, 30 Oct 2015, Philip Nienhuis wrote: Is there a method that will return the version of Apache POI? Does the org.apache.poi.Version class not cover you? Nick - To unsubscribe, e-mail: user-unsubscr...@poi.apache.org

Re: POI XSSF and ClipBoard issue

On Thu, 22 Oct 2015, Sam' wrote: Yes the attachment is in XSSF format. I produced the file without POI. That means I opened Excel on my computer, then fill the cell and add a comment and saved it. Then I opened it again, clicked on the first cell and did a copy of it. Then after, I do a "paste"

Re: Zoom settings for XWPF?

On Fri, 28 Aug 2015, Mark Beardsley wrote: Thanks Dominic, I will not bother digging any further into the api to discover how to convert from the string descriptor into the relationship ID, how to get this "rId4", from this

Re: Word to OOXML Conversion using Apache POI

On Wed, 29 Jul 2015, Sarfaraz Husain wrote: Is there a way to convert the Word Document to OOXML using Apache POI and save this XML? As in to convert a Word .doc file into a Word .docx file? (.docx files are OOXML-based) If so, sadly the answer is no using Apache POI. It would be nice to

Re: Word to OOXML Conversion using Apache POI

On Wed, 29 Jul 2015, Sarfaraz Husain wrote: I am looking a way to convert Word .docx file to XML with all information in that XML like wordML, images and other relation xml etc. all in one XML file. .docx files are already XML, it's a zip file with several different xml files in there

Re: Apache POI is not supporting MS Word 2013(Strict Open XML Document) - .docx

On Thu, 9 Jul 2015, rathnamm wrote: If I save a MS Word document as Strict Open XML Document(*.docx) then I am not able to process this document. I am getting below exception when I pass this document in XWPFDocument(InsputStream) code. What version of Apache POI are you trying this with? And

Re: Apache POI is not supporting MS Word 2013(Strict Open XML Document) - .docx

On Thu, 9 Jul 2015, rathnamm wrote: I am using Apache POI 3.8 but I tried with Apache POI 3.10 as well but it is not working. And what happens if you try the current latest release? (Those are both old releases) Nick - To

Re: Apache POI

On Wed, 1 Jul 2015, karthikeyan S wrote: Using Apache poi How many row and column to read in excel .xlsx format?? Did you try looking at the Iterating over rows and cells part of the documentation? http://poi.apache.org/spreadsheet/quick-guide.html#Iterator Nick

Re: POI stop no response and errors

On Fri, 5 Jun 2015, donli wrote: System.out.println(Start to parse DOC file.); POIFSFileSystem fs = new POIFSFileSystem(u.openStream()); System.out.println(File opened.); I run this code in a loop, open the word document and parse the document. Sometimes the code stopped at new

Re: WorkbookFactory.create taking long time

On Tue, 26 May 2015, Vipin wrote: Workbook wb = WorkbookFactory.create(attachment.getDataHandler.getInputStream()); This call takes around 1400 ms to read 10k rows , each row has 4 column and there is no formula. All columns have numbers and strings only. I'd suggest you start with the

[Announce] New Committer and PMC Member, David North

Hi All On behalf of the Apache POI PMC, we're pleased to announce that David North has been elected as a committer and PMC member for the project! For anyone else thinking of getting involved, there's some information available on the project website at http://poi.apache.org/guidelines.html

Re: setting up a header

On Thu, 14 May 2015, parthiprft wrote: I'm using 3.11 version of POI, I have to set an header in an excel sheet(this header should be visible even if I scroll up or scroll down), is it possible ? See http://poi.apache.org/spreadsheet/quick-guide.html#Splits Nick

Re: NPE on OPCPackage

On Mon, 11 May 2015, João Miguel Penetra wrote: I have a web site where users can upload CSV and XLSX files and I use Apache-POI to parse XLSX files. However, I discovered something unusual. When I convert a CSV file to XLSX on Excel 2013 I get a NPE while initializing XSSFReader:

Re: java.lang.reflect.InvocationTargetException in pptx conversion using poi

On Fri, 8 May 2015, Shiva Kumar wrote: Please give me a solution. Is there any class that I can override solve the issue if not possible please take this as a bug report and solve this. Caused by: java.lang.NoClassDefFoundError:

Re: Reading XLSX

On Thu, 30 Apr 2015, João Miguel Penetra wrote: This guide has been very useful and I've managed to reduce the memory problems and optimize the performance but now I have issues parsing the data. I have these two examples: c r=B2 s=3v33015/v/c and c r=D2 s=1v91001/v/c In the first

Re: Remove Invalid XML in DOCX

On Mon, 27 Apr 2015, Michael Nguyen wrote: We convert MS-WORD documents to DOCX using LibreOffice (clunky), but some files are unreadable because they contain invalid UTF-8 characters in the XML that version 1.0 and 1.1 of XML do not like. Your best long term fix is to report the bug to

Re: Cell Type - Numbering Format

On Tue, 14 Apr 2015, mskavim wrote: I am creating Bill Of Material report using Apache POI. I have a column for Part Numbers... there are few occasion where P/N has 0 in the prefix like 000501 000502 ... so on. if I set the Cell Type as Numeric. The prefix 0 is getting stripped. is there

  1   2   3   4   5   6   7   8   9   10   >