Hi,
I am using Vaadin Spreadsheet to show an excel on the UI, I added some color using below code:
Sheet in UI looks like (attached) SheetInBrowser.PNG
// Create cell style
cellStyleItem = sheet.getWorkbook().createCellStyle();
// add color
cellStyleItem.setFillForegroundColor(HSSFColor.YELLOW.index);
// set cell value
sheet.createCell(startRow, 0, lstSnd.get(0).getPartNo().trim());
// set cell style
sheet.getCell(startRow, 0).setCellStyle(cellStyleItem);
I have added a button for a user to download the excel with below code:
StreamResource.StreamSource streamSource = new StreamResource.StreamSource() {
@Override
public InputStream getStream() {
ByteArrayOutputStream outputStream = null;
try {
hideShowComments(true);
//sheet.reloadActiveSheetStyles(); ← Tried this as well but it it did not work
outputStream = new ByteArrayOutputStream();
sheet.getWorkbook().write(outputStream);
return new ByteArrayInputStream(outputStream.toByteArray());
} catch (Exception e) { e.printStackTrace(); return null;
} finally { try { if(outputStream != null) outputStream.close(); } catch (IOException e) { e.printStackTrace(); } }
}
};
After downloading, all the cell styles does not appear (but the cell values are still there)
Downloaded file looks like (attached) sheetDownloaded.PNG
Any help would be appreciated. Thanks.
