Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 302 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Error Malformed URI is embedded as a hyperlink in the document when selecting excelsheet
Remco
Member Posts: 81
Hi, I have a report where you can choose an Excel file to import. The Excel file contains several sheets. So the user has the possibility to select one of the sheets.
I use the function SelectSheetsName from the table 370 Excel Buffer.
The C/AL code XlWrkBkReader := XlWrkBkReader.Open(FileName) gives the following error:
A call to Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookReader.Open failed with this message: The Microsoft Excel workbook cannot be opened. This may be caused by one of the following reasons:
1. The path to the file is a web address. You must navigate to the file by using the Open File dialog box, or you can save the file locally and then open it.
2. The workbook is not saved in the Open XML file format. In Microsoft Excel, save the workbook as an Excel workbook (.xlsx file), and then try your request again.
The following error occurred: Invalid Hyperlink: Malformed URI is embedded as a hyperlink in the document..
The Excel file contains different kind of e-mail adresses on some other worksheets. Unfortunately it is not possible to delete these worksheets. The customer needs them.
Who has an idea how to solve this issue, by using other code, perhaps with an excel dotnet variable.
I use the function SelectSheetsName from the table 370 Excel Buffer.
The C/AL code XlWrkBkReader := XlWrkBkReader.Open(FileName) gives the following error:
A call to Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookReader.Open failed with this message: The Microsoft Excel workbook cannot be opened. This may be caused by one of the following reasons:
1. The path to the file is a web address. You must navigate to the file by using the Open File dialog box, or you can save the file locally and then open it.
2. The workbook is not saved in the Open XML file format. In Microsoft Excel, save the workbook as an Excel workbook (.xlsx file), and then try your request again.
The following error occurred: Invalid Hyperlink: Malformed URI is embedded as a hyperlink in the document..
The Excel file contains different kind of e-mail adresses on some other worksheets. Unfortunately it is not possible to delete these worksheets. The customer needs them.
Who has an idea how to solve this issue, by using other code, perhaps with an excel dotnet variable.
0
Answers
Any solution ?
Thx