The Hyperlink Testing.xlsx is the Excel file, and the PDF created from it with the same name. Notice that from the Table of Contents, you should be able to click on the page names to jump to those locations in the report. The excel files Im generating are from a template I read the excel template file, write changes, and save as new excel file. Here are three files to refer to: The SAMPLE ANNUAL is last year's file. How can I convert/save excel file to pdfIm using java play framework to generate some excel files and now the requirement changes to pdf.I dont want to recode everything. ![]() do the manipulation save the file using EPPlus then save it in Excel then run the process without saving it. None of these hyperlinks work when the file is PDFed! Please help! These worked fine for the last year, I don't see why Excel 2016 would lose this functionality! So, theres a workaround which is impractical, i.e. Via Insert Link / Place in this Document / Named Location I suggest you convert it to pdf and then print it and To convert the worksheet in an Excel file into a PDF file, you can use the EPPlus library that enables you to export the page as a PDF file, using the WorksheetToPdfConverter function that converts the page into a PDF file and saves it to the hard disk. Via Insert Link / Place in this Document / "Sheetname!A1" ![]() Via the HYPERLINK formula (I know this does not work, tested it just for confirmation) Alternatively, you can go to Export > Export to XPS/PDF. I have tried creating the hyperlinks three different ways: To save the file as a PDF in Excel, open the Save As dialog, and select PDF from the 'Save as type' dropdown menu. Workbook workbook new Workbook () workbook.LoadFromFile ('D:test.xlsx') PdfDocument pdfDocument new PdfDocument () PdfPageOrientation. I have confirmed that "Add Links" is checked in Preferences. Can you confirm which library you were using If its Spire.XLS, then you can try to set the height of the PDF page like below code. Spire.Office has the DLLs compiled for multiple versions. (From the Table of Contents to other pages, and from the page titles back to the ToC, etc.) These worked fine in Excel 2007 when I used "Create PDF", but now that I'm remaking this file in Excel 2016, the hyperlinks do not come across in the PDF creation process. Method 1: Download Spire.Office (hotfix version is recommended) and unzip the package somewhere on your disk to find the BIN folder. ![]() I have a workbook created to be a PDF report when complete, with hyperlinks to various points inside the file itself.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |