At this point, only the styling is preserved without the hyperlink itself. Implement logic to add the hyperlink to the generated PDF document.

Workaround: check the attached project.

When the Workbook has more than one sheet a localSheetId should be exported: 

<definedName name="xlnm.Print_Titles" localSheetId="0">Sheet1!$A$1</definedName>

localSheetId (from the OOXML specification): Specifies a boolean value that indicates whether the defined name is related to an external function, command, or other executable code.

In some cases when cells are merged the cell borders are not correctly imported.

Exporting sheet properties corrupts the file and it cannot be opened in Excel.

In the latest version we export: 

<sheetPr>
<pageSetUpPr fitToPage="true" />
<tabColor rgb="FF92D050" />
</sheetPr>

Excel cannot read this and tries to recover the file unsuccessfully. This works in R3 2020.