aspose file tools*
The moose likes Other Open Source Projects and the fly likes Xssf Merging[POI] Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Xssf Merging[POI]" Watch "Xssf Merging[POI]" New topic
Author

Xssf Merging[POI]

Shuvradeep Sengupta
Greenhorn

Joined: Sep 18, 2013
Posts: 1
I am able to work fine with xssf for a particular cell in terms of value addition , applying style sheet.

cs.setAlignment(cs.ALIGN_LEFT);
sheet.getRow(mainlastrow).createCell(1).setCellValue("FileStore ::"+RscBundle.getString(Code+"_"+cmdCount));
sheet.getRow(mainlastrow).getCell(1).setCellStyle(cs);

But i need to do this style sheet , put values part in terms of a xssf merged region :: CellRangeAddress(28,28,5,9)
XSSFWorkbook workbook1=new XSSFWorkbook(inputStream);
XSSFSheet sheet = workbook1.getSheetAt(1);
sheet.addMergedRegion(new CellRangeAddress(28,28,5,9));

Till the creation of this merged xssf region , it is working fine. What i am not getting how to put values and apply style sheet for the merged region.

Thanks in advance.
Olivier Rihoux
Greenhorn

Joined: Jun 03, 2013
Posts: 8
simply you have to create the Row and the left-upper cell in your range (if not existing yet), otherwise, just assign value to that cell :
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Xssf Merging[POI]