We're pleased to announce the release of Spire.XLS for Java 15.11.3. This version supports converting between Excel and Markdown formats, setting text box paragraphs to right-to-left. Besides, several issues that occurred when converting Excel to PDF/HTML and merging files have been successfully fixed. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| New feature | SPIREXLS-5882 | Added support for converting between Excel and Markdown formats.
//Markdown to Excel
Workbook workbook=new Workbook();
workbook.loadFromMarkdown(inputFile);
workbook.saveToFile("out.xlsx", FileFormat.Version2013);
//Excel to Markdown
Workbook workbook=new Workbook();
workbook.loadFromFile("in.xlsx");
workbook.saveToFile("out.md", FileFormat.Markdown);
workbook.dispose();
|
| New feature | SPIREXLS-5943 | Added support for setting text box paragraphs to right-to-left.
Workbook workbook = new Workbook();
Worksheet sheet = workbook.getWorksheets().get(0);
XlsTextBoxShape textbox = (XlsTextBoxShape) sheet.getTextBoxes().addTextBox(4, 2, 100, 300);
textbox.setText("مبرمج , اختبار .");
textbox.setHAlignment(CommentHAlignType.Left);
textbox.setInnerLeftMargin(1);
textbox.setInnerRightMargin(3);
textbox.setInnerTopMargin(1);
textbox.setInnerBottomMargin(1);
textbox.setTextDirection(TextDirectionType.RightToLeft);
String result = "setInternalMarginOfTextbox_result.xlsx";
workbook.saveToFile(result, ExcelVersion.Version2013);
|
| New feature | SPIREXLS-6003 | Added support for setting table styles in the body when converting Excel to HTML.
Workbook workbook = new Workbook();
workbook.loadFromFile("input.xlsx");
Worksheet sheet = workbook.getWorksheets().get(0);
HTMLOptions options = new HTMLOptions();
options.setImageEmbedded(true);
//Setting "HTMLOptions.StyleDefineType.Inline"
options.setStyleDefine(HTMLOptions.StyleDefineType.Inline);
sheet.saveToHtml("out.html",options);
|
| Bug | SPIREXLS-5993 SPIREXLS-6010 SPIREXLS-6019 | Fixed the issue where incorrect output occurred when converting Excel to PDF. |
| Bug | SPIREXLS-6013 | Fixed the issue where content overflowed cells when converting Excel to HTML. |
| Bug | SPIREXLS-6015 | Fixed the issue where incorrect output occurred when merging Excel documents. |
| Bug | SPIREXLS-6028 | Fixed the issue where a "NullPointerException" was thrown when loading and saving Excel documents. |
Click the link to download Spire.XLS for Java 15.11.3:
