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);
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.
posted 2 years ago
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 :