PROC IMPORT Excel hyperlink to a SAS data set

[Dick_Pickett]

Is this possible?

Example: An Excel cell contains: =HYPERLINK("[mailto:[email protected]]", "[email protected]")

PROC IMPORT does not import the cell contents.

PROC IMPORT datafile = "report" out = &tabnamecon
dbms = XLSX REPLACE ;

sheet = "&tabname" ;
getnames = NO ;
%IF &columnheadline = NA %THEN %DO ;
datarow = 1
%END ;
%IF &columnheadline ^= NA %THEN %DO ;
datarow=&columnheadline
%END ;
;
RUN ;

[Reeza · Accepted solution]

When importing from Excel, it reads the value of the cell, not the formulas of the cell.
I'm not aware of any method to retrieving the formulas beyond parsing the XML file which is very cumbersome.