We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

HTML to Excel Worksheets

Sorry for my confusion. I mean the data of autofitler is like this in html,please prepare them.
We will support reading autofitler in the next version 23.1.

Thank you @simon.zhao!

You are welcome!
BTW, will you set the filter condition in html ? Now only “All” is supported .

Hi Simon, I want to make sure I am understanding correctly: Currently Aspose.cells does not have an option for x:autofilter=“custom”, but does have functionality for x:autofilter=“all”. When version 23.1 is available we will be have custom “Autofilter” in our reports if we include it in our report HTML, like the example you attached? I will have to test with the x:autofilter=“all” again because I was not able to achieve it.

“CELLSJAVA-45029” we did not get resolve on this issue, but I see its marked as “Resolved”. Can you communicate your determination on the issue? i.e. <x:WorksheetOptions> section where we can define the sheet zoom, freeze panes, and other information for the excel report is not being applied at all…


Both issues (logged as “CELLSJAVA-45029” and “CELLSJAVA-45034”) are resolved now. But the fixes/enhancements would be included in our upcoming release Aspose.Cells for Java v23.1 which will be published in the first half of January 2023.

Moreover, we will also shed lights and explain on what will be supported in upcoming release regarding both tickets.

Hi there, Happy New Year! Checking in on CELLS-JAVA-44907, any insight? Thank you so much!

Please wait for 23.1. We will release it in the next week.

The issues you have found earlier (filed as CELLSJAVA-45029,CELLSJAVA-45034) have been fixed in Aspose.Cells for Java 23.1.

Thank you for the update on the releases. CELLSJAVA-44907 Is an important feature because it allows redlining in cells, and would definitely motivate an upgrade. Any ETA on that yet?


No ETA on specific issue “CELLSJAVA-44907” yet but you may try latest version of the API which has enhancements. Anyways, please note, we already logged separate (relevant) sub tickets (filed as CELLSJAVA-45029, CELLSJAVA-45034) and fixed them already.

@afitz @mlyra
Have you tried 23.1?
If you still has issues , please share your sample project and files , we will check it soon.

Hello Simon, its been a busy few months. I hope all is well! This is a new question. When creating header and footer data, how should a line break be formatted within the mso-header-data or mso-footer-data string? For example I have line breaks formatted in “\000A” in my input, and I have tried lots of other character entities for line break but cannot get the line break to work:
{mso-header-data:"&L&10Left Top Row\000ALeft Middle Row\000A&11\000A&C&\0022-,Bold\0022Center Top Title\000ACenter Middle Title&R&10Right Top Row\000ARight Middle Row\000ARight Bottom Row";
mso-footer-data:"&L&10Left Top Footer \000ALeft Middle Footer \000ALeft Bottom Footer &C&\0022-,Bold\0022Center Footer&R&10Right Top Footer\000ARight Middle Footer\000ARight Bottom Footer";
margin:1.0in 1.0in 1.0in 1.0in;
But the line breaks do not happen in the output and the content overlaps in the header and footer. I have attached the expected output, the input file, and output file. Thank you for your help!
ExcelXLSXHeadersFooters.7z (13.6 KB)

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSJAVA-45249

We will fix this issue that NewLine does not work when converting mht to excel

Which version are you using?
It works fine with 23.3 with your input file, please check the attached file 23.3.zip (7.5 KB)
Workbook workbook = new Workbook(dir + “InputMHTMLfile.mht”);
workbook.save(dir +“23.3.xlsx”);

Hi, We have version 20.11 of Aspose.cells. I opened the file you attached and I see no header or footer data. Thank you for your help


Please open the Excel file into MS Excel manually. Now take the Print Preview of the sheet or open “Page Layout” view from View menu. You will find those headers and footer are sorted fine.

Thank you Amjad, I see them know, I was in Monday-mode and only looked at the second sheet. I see them on the first sheet. Alright, so we need version 23.3 of Aspose.cells for “\000A” to work as a line break. Thank you!


It is nice to know that you figured it out now. Should you have further queries or issue, feel free to write us back.