Currently you'd need to do this manually. You'd iterate through the cells and get the HSSFStyle instances and mark the cells in your new row with the same instances.
-Andy JR Ruggentaler wrote: >Hi, > I am new to POI so bear with me. I created a Excel template (.xlt with MS >Excel) which contains all my formatting. I want to write an app which uses >POI, my template and data from a database to create a Excel report. The >template has one row that has all the formatting for my data and I can set >the values for that row and save the report using POI without any problems! >What I would like to do is duplicate the formatting in my data row for each >row of data I retrieve from the database. So my question is how can I >duplicate the formatting from a row to a new row? I looked at the HSSFSheet >and HSSFRow API docs but the only thing I noticed is HSSFRow(Workbook book, >Sheet sheet, RowRecord record) but HSSFRow.getRowRecord() is protected. > >Thanks in advance! >J.R. > >-- >To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
