If the cell that is selected is an empty cell then I do not have a solution for you. Sorry. ---- 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]
