Re: Apache POI- SXSSFWorkbook - Block a row from flushing

Hi, Maybe Stax is your solution to post-update the file in a performant way, it combines a streaming API with DOM like access. see http://en.wikipedia.org/wiki/StAX for details. An implementation is available at http://stax.codehaus.org/ Dominik Am 17.05.2013 16:51 schrieb "Nick Burch" : > On Fr

Re: Reading macro using apache poi is taking too long

Hi, It is impossible to state anything without a look at how you create the file or how the file looks like. Can you provide a sample file which allows others to reproduce the behaviour? Thanks... Dominik. On Fri, May 31, 2013 at 8:32 PM, vijay wrote: > I'm big big fan of apache Poi, I used i

Re: error while use Workbook write

Hi, You seem to try to add a hyperlink without actual location that the hyperlink points to, can you post the code which creates the Excel file? Thanks... Dominik. On Wed, Jul 31, 2013 at 11:36 AM, dsmadja wrote: > here my error log > > java.lang.IllegalArgumentException: target > at

Re: problem creating two xlsx files from single Workbook

Hi, can you explain what you mean with "corrupt" in your case? Does Excel refuse to read the file? Does POI itself refuse the read the file in again? Which errors are you seeing? We currently know about two issues that can happen if you continue to use a XSSF workbook after it was written out, on

Re: Kindly help me in configuring poi source code in eclipse

Hi, I have just added Eclipse project files to the source code, so if you check out the latest trunk, you will be able to import these into Eclipse and start hacking right away. The only necessary thing will be to run ant on the commandline once before to the 3rd party libraries downloaded and som

Re: ss.Sheet.autosize problem

Have you tried newer versions of POI? 3.6 sounds a bit outdated. If still the same, it can be related to the OS installation/font setup, maybe you can provide a bit more information, like full error message/stacktraces/OS information/... Thanks... Dominik. On Wed, Oct 23, 2013 at 1:56 PM, Ty Da

Re: question about read excel file

Hi, It seems you should be able to read the RichText-information via the "runs" by casting to XSSFRichTextString, however when I create such a XLSX in LibreOffice, POI actually produces NullPointerExceptions because some data is not filled as POI expects, does it work on your file? XSSFRi

Re: Excel Tables and Streaming Workbooks

Hi, it seems there is currently no support for tables in SXSSF currently, without anyone submitting patches it probably is not going to be added soon, anyone wants to take a stab? Thanks... Dominik. On Tue, Dec 24, 2013 at 8:46 PM, Craig Milhiser wrote: > I have a program that creates a MS Exce

Re: Where are the ooxml-schemas Sources?

Hi, seems your best bet is to run the build locally, you can get the jar built via Ant-target "compile-ooxml-xsds", the resulting jar is ooxml-lib/ooxml-schemas-src-1.1.jar Dominik On Thu, Jan 30, 2014 at 12:29 PM, David Law wrote: > Hi Nick, > > nice to hear from you. > > I confess to being an

Re: java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlException

Hi, It depends on how you specify the jar files (scripts, IDE project config, ...), but wherever you specify the poi-*.jar, you should also define the xmlbeans-2.3.0.jar and the dom4j-1.6.1.jar file. Thanks... Dominik. On Wed, Feb 5, 2014 at 8:06 AM, kwokchunw...@gmail.com wrote: > i also havin

Re: Please check in the ooxml-schemas Sources!

Hi, Can you please report this as Bug at https://issues.apache.org/bugzilla/enter_bug.cgi?product=POI, this way it will not be burried in emails... Thanks... Dominik. On Thu, Feb 6, 2014 at 1:00 AM, David Law wrote: > Could I suggest someone check in the ooxml-schemas sources? > > Contrary to w

Re: ShiftRows, Bug in POI 3.10 Beta 2: "Could not find 'internal references' EXTERNALBOOK"

Please report a bug at https://issues.apache.org/bugzilla/enter_bug.cgi?product=POI so we can investigate. Please also provide information where the Excel file is coming from, i.e. manually created (which version of Excel) or created by some other tool? Thanks... Dominik. On Fri, Feb 7, 2014 at

Re: xls maximum number of comments

Yes, it sounds like a bug, Can you enter an entry for this at https://issues.apache.org/bugzilla/buglist.cgi?product=POI, preferably with a self-contained unit test which creates too many comments, stores and re-reads the file and fails when the comments are not there the same way as before. Than

Re: Excel Pivot tables

Hi, See http://poi.apache.org/howtobuild.html for how the source code can be built after you have applied the patch in a local SVN checkout or the downloaded source. Thanks... Dominik. On Fri, Jun 27, 2014 at 10:06 PM, j.ballada...@verizon.net wrote: > Hi, > I am trying to create pivot tables w

Re: Excel Pivot tables

Hi, we ship a pre-defined Eclipse project file, you should be able to import this in Eclipse using File-Import->Existing Projects into Workspace in Eclipse after the build was executed once via Ant on the commandline. Dominik. On Mon, Jun 30, 2014 at 2:03 PM, j.ballada...@verizon.net wrote: > T

Re: Not able to generate the values in xlsx sheet more than 150 chars

Hi, Can you paste a sample file and your code so it becomes a bit clearer what your problem is? Thanks... Dominik. On Thu, Jul 31, 2014 at 7:44 AM, Nalini Nizamkar wrote: > Hi, > > I am facing the strange issue. > In my case the xlsx sheet is generated successfully, but could notice few of > th

Re: Not able to generate the values in xlsx sheet more than 150 chars

Sorry, but it is still hard to see where exactly your problem is located. If I run the code I get some files with some content, but no error message, so what content do you not expect? Thanks... Dominik. On Fri, Aug 1, 2014 at 7:44 AM, Nalini Nizamkar wrote: > Below is the code... > > > > > impo

Re: Not able to generate the values in xlsx sheet more than 150 chars

Hmm, it is really hard to state what the problem is when we cannot see the problem in action and also unit tests do not reproduce the problem. Can you rule out that another part of your application is cutting off after 150 characters? Maybe the problem is already happening in code that runs before

Re: Help migrating setRepeatingRowsAndColumns.

Hi, I think this is the correct way to do this nowadays. The CellRangeAddress has the advantage that it allows a more meaningful way of addressing, e.g. it allows something like this: sheet1.setRepeatingRows(CellRangeAddress.valueOf("1:4")); sheet1.setRepeatingColumns(CellRan

Re: POI 3.11 NullPointerException when doing removeSheetAT() for .xls file

Hi, With a random sample xls I do not see the NullPointerException. Can you also share the XLS file that is triggering this? Or even better a self-contained unit-test that does not require one to adjust the code to make it compile? Also the full stacktrace of the exception would help in finding

Re: Poplulate XLSX shows 0 rows

Hi, Can you share such a file that is not working? Sounds like your CM system exports files in a slightly different or non-standard way which seems to not break in Excel, but breaks POI... Dominik. On Fri, Sep 26, 2014 at 1:33 AM, Michael Guerrero wrote: > First post. Here goes… > > I have ex

Re: ASCII control characters in Sheet names - writing workbook possible, cannot be opened by Excel nor created from file

Hi, I don't think this is a valid Sheet name and I would try to simply avoid it if possible as XML does not allow control characters at all (at least in XML 1.0), I think the best we could do in POI would be to throw an error if we find these characters, however this would slow down processing as

Re: Reading/writing DocX on Android

Hi, This sounds like you are using an older version of class XMLEventFactory from somewhere, it probably is pulled in by stax-api.jar or an outdated xml-apis.jar, the classes in JDK 6 or higher have the method newFactory(), while older ones seem to miss it. Dominik. On Sun, Oct 12, 2014 at 4:11

Re: Reading/writing DocX on Android

newFactory if I can't > count on my VM shipping it (I.e. Dalvik?) I tried stax:stax:1.2.0 but it > doesn't seem to ship with a set of javax classes--at least, I can't find > one in Gradle's build directory. There is of course a stax 1.0.1 that > doesn't include newF

Re: Error- Illigle name chartor while creating xls using xml streaming

Can you share the code that creates the file and a sample xlsx file? Dominik Am 29.10.2014 18:42 schrieb "rhya...@gmail.com" : > I am creating a xlsx file using xssf api using xml streaming. There are > some > special characters in the input data due to which final excel file > generated > is get

Re: cloneSheet causes file damage

Hi, If nobody knows how to reproduce the bug, it will not be fixed anytime soon for sure :). Please report a bug with description of your steps and sample files, preferrably as ready-to-run unit test, so we are able to try to reproduce your problem. Thanks... Dominik. On Wed, Nov 5, 2014 at 8:0

Re: Error- Illigle name chartor while creating xls using xml streaming

Hi, To be honest it is very hard to see much based on this code-example, there is a lot of stuff being done and the incoming data is not included, so it's very hard to debug further without a self-contained test/sample-file. Maybe you can reduce the code to be a self-contained unit test together

Re: Error- Illigle name chartor while creating xls using xml streaming

Hi, Yes, having the source code that re-creates the problem will help to try to reproduce and see if there is a possible fix. The resulting file alone will likely not be enough, the actual code to create it is more useful. Best if it is a self-contained unit-test that can be run independendly. Do

Re: "IllegalArguementException : Value for parameter 'id' was out of bounds"

Can you create a Bug-Entry for this? Preferably with a sample file and some lines of code which shows the problem. If you can, a patch which fixes the problem and a unit-test are a plus as it makes it much easier to incorporate this into POI. Thanks... Dominik. On Wed, Nov 19, 2014 at 9:49 PM, M

Re: Error creating Pivot table

Hi, This is likely due to a change from the *List() methods to *Array() methods in POI in 3.11-betaX, you can either use the full char or also use the getFieldArray() Method. See http://poi.apache.org/faq.html#faq-N10025 for more details. Dominik. On Tue, Nov 25, 2014 at 2:27 PM, wrote: > > Hi

Re: Java Memory issue

That's why we call it "beta" :) Can you share the xls-template that you use here? Otherwise it will be very hard to reproduce/fix. Thanks... Dominik On Tue, Dec 9, 2014 at 11:04 PM, j.ballada...@verizon.net wrote: > Move back from POI 3.11 Beta 3 to 3.9 and it works. > Why? Anyone can explain?

RE: No Such Method Error Upgrading Trom 3.10 To 3.11

i think Ibm java 6 does not provide the full xml parser functionality, can you try IBM Java 7? Dominik Yeah, looking at the exception, it's complaining about a missing SAX parser method, likely employed as of 3.11. SAX is included with Java 6 but perhaps your version of java is a bit old. This l

Re: Xmlvalueoutofbounds exception while reading a value

Hi, do you have a sample document that you can share? Thanks... Dominik. On Wed, Dec 31, 2014 at 12:27 PM, Perundevi wrote: > Hi, > > If i read the value of page width like, > > document.getDocument().getBody().getSectPr().getPgSz().getW() > > It throws the XmlValueOutOfBounds Exception if the

Re: insert row function

This is not a very useful question as you do not state at all what actually fails and how it fails. You will increase your chances of getting some answers if you add more information about your problem, e.g. sample code, actual error message, what you already tried, if it worked in a previous versi

Re: Issue in writing very large spreadsheet with cell comments using SXSSF

Hi, SXSSF should stream the content out and thus should not require a lot of memory, so it sounds you hit some bug where things are kept in memory nevertheless. Can you create a bug entry at https://issues.apache.org/bugzilla/ and share some code that allows to reproduce this? Ideally as unit tes

Re: Navigating relationships in OOXML docs

What about the following: OPCPackage pkg = OPCPackage.open(filename); pkg.getPart(PackagingURIHelper.createPartName("/xl/_rels/workbook.xml.rels")); Dominik. On Fri, Jan 9, 2015 at 12:35 PM, Chris Bamford wrote: > > Hi there > > I need to look for a relationship in the ".rels" file of the

Re: insert row function

quot;are there any function of inserting row in Excel File > in POI?". I'd like to insert row into Excel File using POI. > > 2015-01-09 18:32 GMT+09:00 Dominik Stadler : >> This is not a very useful question as you do not state at all what >> actually fails and how it f

Re: Resubmit to application when user clicks on "Enable Editing"

Hi, I don't think there is a way that would allow to control this from POI, it actually would render the whole "enable editing" feature of Excel useless if you could build the document in a way to prevent it. Also doing another request upon "enable editing" is likely built into Excel as part of m

Re: Array Formula

Hi, yes, sure, patch-submissions are welcome, see http://poi.apache.org/guidelines.html for some instructions and tips. As soon as you have something ready for discussion, please open a ticket at https://issues.apache.org/bugzilla/buglist.cgi?list_id=121173&product=POI and attach the patch toget

Re: Resubmit to application when user clicks on "Enable Editing"

Hi, I am not an expert in that area, but maybe you can set the MediaType of your download to some binary form, not "excel", then the browser usually just offers to download the file, not to open it. Dominik. On Tue, Jan 20, 2015 at 4:04 PM, bhames50 wrote: > Dominik, > > Thanks for the reply! Y

Re: Clone a workbook?

Hi, In our unit-tests we do the following a lot when we verify that writing/reading the data keeps things at their expected state/place. This writes the spreadsheet to a byte[] and then reads it back in as new Workbook. ByteArrayOutputStream baos = new ByteArrayOutputStream(4096);

Re: Array Formula

.apache.org/spreadsheet/formula.html > > From: Dominik Stadler > To: POI Users List ; Ahmed Ashour > Sent: Monday, January 19, 2015 10:16 PM > Subject: Re: Array Formula > > Hi, > > yes, sure, patch-submissions are welcome, see > http://poi.apache.org/guide

Re: How do control font and autoSizeColumn in XSSF?

Hmm, they should behave very similar, only if you run it on different machines there might be differences due to the number of fonts found on the machine. Does one break if you leave out the other, i.e. without setting the Font, does autosize work and vice versa? Can you pack that up into a self-

Re: How to remove data validation on a cell ?

What error messages/validation errors do you get reported? Thanks... Dominik. On Fri, Feb 20, 2015 at 9:49 PM, Marc-Olivier Blanc wrote: > Hi, > > > > I am reading an XLSM file and have some processing to do including writing > some data in it. > > > > Unfortunately there are some data validatio

Re: ArrayIndexOutOfBoundsException in poi3.11

Sounds like a bug, can you open a bugzilla entry with the two versions of the file attached? Thanks... Dominik Am 22.02.2015 09:30 schrieb "Rajiv Poddar" : > Hi, > I'm using POI 3.11 latest release to read an Excel file (.xls). While > reading, it gives following exception- > > java.lang.ArrayI

Re: HyperLink issues ....

Hi, This sounds related to a problem with more than 1024 comments that was reported a while ago, see https://bz.apache.org/bugzilla/show_bug.cgi?id=56852, unfortunately nobody did yet come up with a fix or explanation of a limitation of the Excel format for this... If you are using xls/HSSFWorkbo

Re: XSSFWorkbook File constructor not defined in 3.11

Hi, Your dependencies contain "poi-3.8", the constructor with File did not exist in that version yet, see http://svn.apache.org/viewvc/poi/tags/REL_3_8_FINAL/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFWorkbook.java?revision=1301934&view=markup Not sure how you got the 3.11 in the output of

Re: XSSFWorkbook File constructor not defined in 3.11

writing > my original email). > > I tried Nick's suggestion and recreated the Driver as a Java source and, to > my great surprise, the problem didn't show up. I am now working with the > Groovy community to pinpoint and will update this mailing list with what I > find

Re: Warning from user@poi.apache.org

Hi, It usually means that your mail-server did deny receiving the mails for some reason, you will likely need to have a closer look there why messages cannot be delivered to you sometimes. Thanks... Dominik. On Sun, Mar 15, 2015 at 2:09 PM, Amine BADID wrote: > Hello > > I receive always the me

Re: Fun with XSSF Fill Colors

Hi, I did a fix lately under bug 56295 - https://bz.apache.org/bugzilla/show_bug.cgi?id=56295, POI previously did use a default of "false" for the "applyfill" attribute, whereas Excel and LibreOffice seem to use "true" as default. As a result of this, POI did not read in background/foreground fill

Re: POI Memory issue

Hi, As the XSSF implementation is fundamentally based on having all elements in memory, there will always be a file size which exceeds that available memory. How big are your files? I.e. are you just a bit over the available memory or a lot? Maybe you can do a heapdump using the Java flags as exp

Re: org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:543) --> Need book to evaluate name 'B65537'

BTW, the code fails at if (_book == null) { // Only test cases omit the book (expecting it not to be needed) throw new IllegalStateException("Need book to evaluate name '" + name + "'"); } and member _book is initialized in the constructor with whatever you

Re: Reading XLSX cell content

Hi, 1. The mailing lists have a gmame mirror, which allows searching, e.g. http://news.gmane.org/gmane.comp.jakarta.poi.user and http://news.gmane.org/gmane.comp.jakarta.poi.devel, also google can be used via a search like "site:http://mail-archives.apache.org/mod_mbox/poi-user/ " 2. It likely d

Re: Create an XSSFAutoFilter ok, but I don't know how to use it by coding

Hi, Please try with the full schema-jar, see http://poi.apache.org/faq.html#faq-N10025 Dominik. On Wed, Mar 25, 2015 at 9:19 AM, BRANDA Didier wrote: > Hello, > > > > I'm using 3.11 poi for create xlsx files. > > I know how to create a XSSFAutoFilter, and I can use it manually when the > file

Re: Excel validation problem of poi generated document (simple)

Hi, Is something actually not working because of these differences? Most of them should still work fine when parsing/opening the resulting documents. Dominik. On Thu, Mar 26, 2015 at 2:15 PM, BogdanM wrote: > Hello I'm generating the following .xlsx from the following java code > > > > XSSFDraw

Re: Java newbie question

Hi, this sounds not related to POI as it neither uses something from org.mortbay nor org.joda. More likely some problem with Jetty and other dependencies in your project. Dominik. On Sat, Apr 11, 2015 at 8:46 PM, Jeroen Baten wrote: > Hi, > > I just added the poi lib to my maven dependencies. >

Re: Background Color for XLSX Files when usinng Indexed/Automatic

Hi, Can you try with the latest nightly build of POI from https://builds.apache.org/job/POI/lastSuccessfulBuild/artifact/build/dist/ ? We applied a fiew a few weeks ago which might make this work as expected. Dominik. On Mon, Apr 13, 2015 at 1:27 PM, Pankaj wrote: > Hi, > > I would like to kno

Re: Background Color for XLSX Files when usinng Indexed/Automatic

Hi, Glad that it works, seems multiple people stumbled over this recently, the fix will be included in the next released binaries, either 3.12-beta2 or 3.12 final, whichever comes first, we have not decided yet. The fixes were done as part of Bug 56295, SVN changes can be seen at https://svn.apac

Re: Apache POI 3.12 Beta2 - Shifting of rows with cell comments in excel

Hi, thanks for reporting. We are not aware of this, the best option to ensure that we can work on this is to create a bug entry at https://bz.apache.org/bugzilla/ together with the sample file and a Java Unit Test, either as patch for the POI tests or as self-sufficient java test to allow us to re

Re: Background Color for XLSX Files when usinng Indexed/Automatic

> > cellStyle.setAlignment(halign); > cellStyle.setVerticalAlignment(valign); > > cell.setCellStyle(cellStyle); > > } > > > > Christopher Schene > Field Engineer, Solution Delivery > > 41ST PARAMETER >A pa

Re: How to create a line chart without smoothed lines

Hi, unfortunately support for charts is not very elaborate at the moment. You can maybe get a glimpse on the required changes in the XML format by doing the minimal necessary changes in Excel and saving the document in a second file. Then the DevTool OOXMLPrettyPrint (available in the POI sources

Re: How to get section columns width in word binary document

I am sorry that you do not get as many answers as you would like, unfortunately the Word format is not fully supported yet in POI and not many people are actively working on it. Thus likely some of the things that you are trying are simply not possible inside the framework, but would require some e

Re: I can not read the EMBED Excel.Sheet in Word

Did you take a look at https :// poi.apache.org / poifs

Re: How to create a line chart without smoothed lines

o 0 so I can generate > my own jar for my application. > I could then look into the changes necessary to incorporate this back into > the project which would provide an option to set this value to 1, but keep > the default of 0 since I wouldn't want to break the existing functionality. >

Re: Getting the line count of docx file created using POI - 3.10

These fields are likely precomputed and stored in fproperties in the document by Word upon saving. POI does not populate them currently, not sure how much effort it would be to correctly compute these things and how costly it would be. It is a bit similar to formulas in Excel files, you also have t

Re: Unable to set Landscape if RepeatingRows is set for the sheet

Hmm, we have a unit test which tries to verify that this does not happen at TestXSSFBugs.bug49253(), maybe you can try to find out what the difference in your case is? Thanks... Dominik. On Tue, Jun 16, 2015 at 5:03 PM, normandenton wrote: > Hi Ryo. > > Thanks very much for your post!!! I have

Re: Missing greek character of mu from doc extraction

Hi, Can you provide a sample document and the java code that you are using so it is easier to try to reproduce this? Thanks... Dominik. On Thu, Jun 4, 2015 at 10:19 AM, teressa kim wrote: > Hi > > I have obsverved that the third greek character of mu "μ" in word doc file is > not extracted whe

Re: Suggestion on how to read huge excel files.

It seems not that many people need similar functionality currently, however it looks useful for handling very large documents. I looked at it and it looks good, some comments: * The finalize() in the Beans looks strange and should not be needed, these members are freed anyway and having to implem

Re: Missing greek character of mu from doc extraction

Hi, sorry, but there is no attachment for me, can you resend? Thanks... Dominik. On Thu, Jun 25, 2015 at 10:42 AM, teressa kim wrote: > Hi Dominik > > This is my java code, and I enclose a word document for you to have a look. > There are three symbols for Greek mu and the one in the first lin

Re: Borders and ranges

Not sure I understand the question correctly, but wouldn't you just apply top/left/bottom/right borders as appropriate to get the larger box? At least that is what you can do in Excel to get such an effect... Dominik Am 29.06.2015 20:19 schrieb "Murphy, Mark" : > I understand how to apply a borde

Re: What's the easiest way to get this patch merged?

Hi, I took a look, basically the patch looks good, however we usually like to get some unit-tests for the touched/added parts, with that in place I can apply the changes shortly. Dominik. On Tue, Jun 30, 2015 at 6:59 PM, Dustin Spicuzza wrote: > Hey, > > My patch has been open on bugzilla for o

Re: Borders and ranges

I want to give some of these > bordered cells a background, and others not, it becomes even more complex no? > In Excel I can simply grab a range, and apply the borders I want. How do I do > that with POI? > > -Original Message- > From: Dominik Stadler [mailto:domini

Re: How to read 1 million rows in excel (.xlsx) format using Apache poi??

No, not related to eclipse.ini in your case. These are commandline parameters for Java to control how much memory it may consume. You specify it when you start your application, take a look at https://docs.oracle.com/cd/E13150_01/jrockit_jvm/jrockit/jrdocs/refman/optionX.html for details. Dominik.

Re: paragraph.spacingBefore() is returning 0 for binary DOC file.

Obviously nobody knows the answer right away so unfortunately your only possibility will be to debug this and look at the source code to find out where the information is in the objects and why it is not returned correctly. Dominik. On Thu, Jul 2, 2015 at 7:13 AM, Shiva Kumar wrote: > Hi, I aske

Re: Split the excel file generated using SXSSF

Hi, I don't see a quick way to do this as we do not expose the name of the temporary file and the resulting file could have a slightly different size as we likely add more metadata and also because we hold a configurable number of rows in memory which will be written out from time to time... So I

Re: CellFormat.getInstance(style.getDataFormatString() Throwing Exception

Hi, What is the cell-format at this cell in Excel? And what is the content of style.getDataFormatString() when it fails? Thanks... Dominik. On Thu, Jul 9, 2015 at 12:49 PM, Shiva Kumar wrote: > Hi, below is a portion of my method which causing the exception given below > while getting the Cell

Re: How to write a subscript in apache poi column!

Not sure, I would probably create a small sample file in Excel and see what richtext string and styles poi returns for the cell. Dominik. Am 09.07.2015 16:19 schrieb "sherybedrock" : > Hi everyone > > 1191 How can i write this in cell if 1 is a subscript > > > > > -- > View this message in contex

Re: Reg: Compare two MS Word Document using Apache POI

Hi, I don't think there is something ready made as it depends a lot on what you see as "difference", i.e. only Text-Differences, or also Formatting? And what about footer/header, pictures, tables, lists, document settings like page-margins, BTW, for text it should be fairly easy to extract t

Re: How to hide formula bar on spreadsheet

Hi, I don't know of a ready-made interface being available right now, but you can likely set it via some of the lower-level APIs in POI. If yes I suggest you create two very similar files in Excel which just differ in this setting and save them as XLSX, then you can unzip both files (XLSX is actu

Re: Suggestion on how to read huge excel files.

Hi, I don't think we can replace the existing functionality immediately as other people will be relying on it. If you can polish the code up a bit more and add some JavaDoc and unit tests to describe how it can be used I can put it in some of the "contributed/incoming/incubating" areas of POI. D

Re: Protected view problem using apache poi .XLS spreadsheet generation

Hi, I believe this is something that Excel does and you will not be able to control this in the document as this is a "security" feature and it would be useless if you can simply disable it in the document. Dominik. On Fri, Jul 17, 2015 at 8:27 PM, nagarjuna.a wrote: > Hi, > I am using apache p

Re: Efficient way to read shared strings.

Hi, Sounds like a useful tool. I don't know of such a project already existing, but it should be quite straightforward with the POI interfaces. A related project is https://github.com/centic9/poi-mail-merge which does a similar thing for providing mail-merge for word-documents, although it needs

Re: Importing a ResultSet into xlsx using a template for formatting and column selection

Hi, Sounds like a useful tool. I don't know of such a project already existing, but it should be quite straightforward with the POI interfaces. A related project is https://github.com/centic9/poi-mail-merge which does a similar thing for providing mail-merge for word-documents, although it needs

Re: Efficient way to read shared strings.

you process with it, it will be hard to provide an efficient disk-based implementation for the general case ... Dominik. On Mon, Jul 27, 2015 at 5:10 PM, Dominik Stadler wrote: > Hi, > > Sounds like a useful tool. I don't know of such a project already > existing, but i

Re: How can I GET the diagonal border for a Cell?

Hi, It seems the POI interface does not provide this currently, can you create two very simple files that are very similar, only one without this and one with this formatting and then compare the XML-files inside the .XLSX? .xlsx-files are just ZIPs, so you can unpack them and compare the files in

Re: POI 3.9 and Java 8 issues

Ok, please report a bug together with a sample file (if needed) and sample code which allows to reproduce the problem. Maybe the unit test from the previous bug got removed/disabled and thus we miss the one CT class in the smaller jar. Also different Java versions can have subtle differences and we

Re: Re: How can I GET the diagonal border for a Cell?

r level API call look like to get those attributes? Thanks a > lot already for your help. > > Regards > > Gesendet: Montag, 27. Juli 2015 um 18:41 Uhr > Von: "Dominik Stadler" > An: "POI Users List" > Betreff: Re: How can I GET the diagonal border for a

Re: Zoom settings for XWPF?

Hi, FYI, I have just added setZoomPercent()/getZoomPercent() to XWPFDocument in the latest trunk version via r1697992. and fixed an NPE when no zoom value was defined before, so release 3.13 will allow to set this directly on the document. Dominik. On Wed, Aug 26, 2015 at 5:27 PM, Lucas Layman

Re: Java Dynamic Casting in Apache POI

Hi, I think you missed to attach the actual changed classes that you refer to, additionally a diff/patch file would be easier to look at as it will show what are the actual changes that you propose... Dominik. On Tue, Sep 1, 2015 at 1:01 PM, Nick Burch wrote: > On Mon, 31 Aug 2015, Mohamed Enna

Re: Set column width in sensible units

Hi, You should be able to use the following to set the width as double-value, however make sure to divide the original int-value by 256 here, and this is only available for XSSF, not for HSSF as there it is stored as int-value in the binary format: XSSFSheet.getColumnHelper().setColWidth(

Re: Java Dynamic Casting in Apache POI

ommit changes on SVN, but I am not allowed to. > > The changes are very minor. a setCellValue() method with an Object argument. > > > From: Dominik Stadler > To: POI Users List > Sent: Tuesday, September 1, 2015 1:17 PM > Subject: Re: Java Dynamic Casting in Apache POI

RE: Cannot see text in cell after F2

Hi, there is a similar bug related to background fill color at https://bz.apache.org/bugzilla/show_bug.cgi?id=56548 A workaround might be to set the background fill color of the cell style to 65 in this case, let us know if it works for you so we can note it in the bug report. Dominik Am 18.09.2

Re: Fill and Border efficiency for XSSF format

Hi, I think the main reason this is not done currently is that nobody spent enough time to do this cleanly. Not sure if comparing the single items of CellStyle would be a good idea, as this is likely to change at some point with new features being added, so you would probably compare the XML repr

Re: Diagonal border

Hi, There was a discussion about how to set diagonal border styling a few weeks ago, see http://mail-archives.apache.org/mod_mbox/poi-user/201508.mbox/browser, it describes how to set a diagonal border, maybe you can use some of this for reading the information in your case. Dominik. On Fri, Se

Re: setDeafultColumnStyle( ) for .xlsx doesn't wotk for new added cell.

Hi, welcome on the List! In fact this problem with setDefaultColumnStyle() is already discussed on the bug-tracker at https://bz.apache.org/bugzilla/show_bug.cgi?id=51037, unfortunately nobody yet found time to investigate in detail why it happens so the workarounds via autoSizeColumn() or Cell.s

Re: Excel TotalsRow

Hi, FYI, the CT... classes are actually automatically generated from parts of the specification from Microsoft, so nobody actually decided to add this method, it got added as part of converting the XML Schema into usable Java code automatically. There are likely a number of other areas where meth

Re: Problem replacing texts

Hi, I have a similar project at https://github.com/centic9/poi-mail-merge, it allows to do "mail merges", i.e. replace tags in a template document multiple times. Only it is based on XWPF not HWPF, so it will only be useful to you if you can switch to the newer docx-format. Dominik Am 20.10.2015 1

Re: POI XSSF and ClipBoard issue

Hi, I am still confused because the attachment you provided is in XSSF format, how did you produce this out of the Clipboard-Data when you state that you work with .xls/Biff8/HSSF formatted data? POI can read XSSF and HSSF just fine and as long as the data is a full spreadsheet file, it should no

Re: Query about WorkbookFactory.create(input)

Hi, WorkbookFactory can open both file formats and will use the correct specific implementation internally automatically. As long as you stick to the Workbook, Sheet, Row, Cell interfaces (in contrast to XSSFWorkbook/HSSFWorkbook and related implementations), you should be able to work with both

Re: Query about WorkbookFactory.create(input)

, Oct 29, 2015 at 1:26 PM, Dominik Stadler > wrote: > >> Hi, >> >> WorkbookFactory can open both file formats and will use the correct >> specific implementation internally automatically. >> >> As long as you stick to the Workbook, Sheet, Row, Cell int

  1   2   3   >