On 8/21/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Are you reading in a spreadsheet then modifying it and writing it out? If > so, make sure
Exactly, and the file that I try to modify has the current selection set on an empty cell. Opening that file with poi 3.0.1 I get the InvocationTargetException. >that the cell that is selected when you save your original document is not a "drop-down" or >"select" type cell. If that is the case, there is a fix for it. Let me know if that is the >problem and I will share it with you. Is there some other kind of fix or workaround I have to apply? Thanks -- Paolo Sacconier > > > ---- Paolo Sacconier <[EMAIL PROTECTED]> wrote: > > Hi everybody, > > I need to use poi to generate excel files with two sheets, filling the > > first one with data and keeping the second one that contains a pivot > > table (that points to the newly inserted data) auto updated on file > > open using a macro. > > > > As reported here: http://poi.apache.org/hssf/limitations.html I know > > that under some circumstances rewriting files with pivot tables with > > poi works. > > > > But as I keep getting an InvocationTargetException caused by an > > ArrayIndexOutOfBoundsException while creating my HSSFWorkbook, I was > > wondering how I have to create my template file with the pivot table > > to make it readable with poi. > > > > I'm using poi 3.0.1 (same problem with 2.5.1), using a newly created > > excel file saved in excel97 format. > > > > Searching with google and in this list I couldn't find any further advice. > > > > Can anybody point me to a working example? Is there anybody that > > successfully read xls with pivot tables? > > > > TIA for your help! > > -- > > Paolo Sacconier > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
