Re: Creating a new Excel file from a template - copying the cellstyle

[XSSF <cz...@bellsouth.net>]

On 11/21/2012 9:08 PM, Ashwini wrote:
> Hi,
>   I am a newbie to POI.
>
> I am trying to create a new excel from an existing Excel used as template
> (has graphs derived out of the data). We know what is the template because
> we will tell the customer to create the template.
> I will be replacing data in the new sheet and graphs get auto generated too
> (using dynamic excel).
> After going through lot of things in the POI forum, I tried something very
> simple :
>
> Workbook myWorkBook = new XSSFWorkbook(new FileInputStream("Book4.xlsx"));
> Sheet s = myWorkBook.getSheetAt(0); // I know this is the data sheet
>
> Row r = s.createRow(6); // Adding row
> Cell c = r.createCell(0); // Adding col - I know the number of columns
> c.setCellValue("june");
> ....
>        
>   FileOutputStream bos = new FileOutputStream("Book6.xlsx");
>   myWorkBook.write(bos);
>   bos.close();
>
> I have 2 questions :
> 1. I want to make sure if the way I am doing is ok to do since I am able to
> generate new excel with new data and graphs updated.
>
> 2. I want to set the timestamp format of a particular column. I am able to
> get the cellstyle from known data column from template and set the same to
> all the same columns like :
> //Getting the style from existing  cell
> if (r.getCell(cellnum) != null) {
>        c = r.getCell(cellnum);
>        stylesMap.put(cellnum, c.getCellStyle());
>   }
>
> //Setting the cellstyle to a new cell
> if (stylesMap.get(cellnum) != null) {
>       c.setCellStyle(stylesMap.get(cellnum));
>     }
>
> Is this ok to do or do I have to clone the style ? Or since I already know
> the date/time format , set it newly from the code?
>
> Thanks for any help.
>
>
>
>
>
> --
> View this message in context: http://apache-poi.1045710.n5.nabble.com/Creating-a-new-Excel-file-from-a-template-copying-the-cellstyle-tp5711530.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
Ashwin,

Take a look at this link: 
https://issues.apache.org/bugzilla/show_bug.cgi?id=51634

-Craig

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org