I use poi to read the content of an excel file,the excel file is follows:
This is a test! //I set the font and color,such as 'is' is green and
'test' is red color
My java code is follows:
InputStream inp = new FileInputStream("demo.xlsx");
Workbook wb = WorkbookFactory.create(inp);
Sheet sheet = wb.getSheetAt(0);
org.apache.poi.ss.usermodel.Row row = sheet.getRow(0);
row = sheet.getRow(0);
title=row.getCell(0).getRichStringCellValue().getString();
System.out.println(title);
When I run above code,I only get the plain text "This is a test!" ,the font and
color is missing,how can I get the text with font and color?
Thanks!
---------------------------------------------------------------------------------------------------
Confidentiality Notice: The information contained in this e-mail and any
accompanying attachment(s)
is intended only for the use of the intended recipient and may be confidential
and/or privileged of
Neusoft Corporation, its subsidiaries and/or its affiliates. If any reader of
this communication is
not the intended recipient, unauthorized use, forwarding, printing, storing,
disclosure or copying
is strictly prohibited, and may be unlawful.If you have received this
communication in error,please
immediately notify the sender by return e-mail, and delete the original message
and all copies from
your system. Thank you.
---------------------------------------------------------------------------------------------------
