I'd be surprised if shitRows work. A chart, AFAIK, isnt placed as a value in a cell. You'll somehow need to get the anchor/location information from the chart, and update that. Not sure if POI exports that information....
The other option is to place the chart in a sheet of its own.... On Wednesday 13 September 2006 22:36, Tenzer, Jennifer (IT) wrote: > Hi, > > I am using POI 2.5.1 and read in an Excel file containing a chart. I am > adding data to the workbook (number of rows can vary), and would like to > move down the chart. I have tried to use he shiftRows method, but that > does not seem to work for the chart: > > sheet.shiftRows(CHART_AREA_START_ROW, CHART_AREA_END_ROW, > rowsInSection); > > Any other ideas of what I could try? > > Thanks! > Jennifer > -------------------------------------------------------- > > NOTICE: If received in error, please destroy and notify sender. Sender does > not intend to waive confidentiality or privilege. Use of this email is > prohibited when received in error. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
