Invalid URI: The hostname could not be parsed.

Question

Hi I am getting following error: Invalid URI: The hostname could not be parsed. When reading excel file using following code ExcelWorksheet worksheet = xlPackage.Workbook.Worksheets[@Sheet1]; and that file have a cell which have email ids with mail to link. Is there any code to remove link ? Please help me how to resolve that error. Best regards Cien System

Amit Choudhary · Answer

You can use range object to remove the hyplinks Range.ClearHyperlinks sample code: Excel.WorkSheet sheet; // initialize sheet and other stuff .... .... Excel.Range range2 = sheet.get_Range(G12J12missing); if(range2!=null && range2.Hyperlinks.Count > 0) { //Remove hyperlink from the sub range range2.ClearHyperlinks (); }