![]() ![]() If you'd like to remove the evaluation message from the generated documents, or to get rid of the function limitations, please request a 30-day trial license for yourself. Thats why I moved to some 3rd party library (GemBox.Spreadsheet for Java) and Im generating a real Excel file (as shown here). Workbook.saveToFile("ExcelDropdownList2.xlsx", ExcelVersion.Version2013) BalusC shed some light to my problem, saving HTML into a file with '.xls' extension can work in some Excel versions, but in others itll prompt a warning. ![]() Sheet.getCellRange("C2").getDataValidation().isSuppressDropDownArrow(false) Create a drop-down list in the specified cell Sheet.getCellRange("C2").getDataValidation().setValues(new String) Sheet.getCellRange("B2").getStyle().setKnownColor(ExcelColors.LightTurquoise) Sheet.getCellRange("B2").getStyle().getFont().isBold(true) Sheet.getCellRange("B2").setValue("Country") ![]() Add text to cell B2 and set its font style
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |