Loading

Invalid URI: The hostname could not be parsed.

Cien System

13y8.1k.NET

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Amit Choudhary13y ago
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("G12,J12",missing);
if(range2!=null && range2.Hyperlinks.Count > 0)
{
//Remove hyperlink from the sub range
range2.ClearHyperlinks ();
}