You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Ashwini <as...@rubiconwater.com> on 2012/11/22 03:08:23 UTC
Creating a new Excel file from a template - copying the cellstyle
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
Re: Creating a new Excel file from a template - copying the cellstyle
Posted by 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