Import Excel and get checkbox status

[heffo]

Hi,

I have an Excel file what has a tickbox/checkbox that I would like to get the status from (ticked or not). 

When I do the normal proc import, the column is just empty for both these rows. 

proc import datafile="&file"
		dbms=xlsx
		out=import_1_1 
		replace;
		range="1.1$P13:W15" ;
run;

Does anyone have any idea on how to get the tickbox value? 

Thanks,

Henrik 

[ballardw]

Save the XLSX to CSV. See what value is created.

Read it with a data step.

Proc Import and XLSX is just waiting to be problem in so many ways...

Since you are using macro variables one has to guess you are going to do this with multiple files. If they are all supposed to be of similar structure it is almost certain that you will have some problem with Imported data being different in some way that causes problems later.