On 8/22/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > If the cell that is selected is an empty cell then I do not have a solution > for you. Sorry.
Thanks anyway. I worked around this problem using a file without the pivot table inside but with a macro that creates the pivot table on the workbook open event, after the file is filled with data trough poi. I hope this can be helpful to anybody experiencing the same issue until poi's hssf pivot support improves. Bye! -- Paolo Sacconier > ---- Paolo Sacconier <[EMAIL PROTECTED]> wrote: > > 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] > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
