How to import an excel file without xlsx or excel engine?

[PSARAVANAN]

How to import an excel file without xlsx or excel engine? Is there any alternative for it?

[Patrick]

Save it as a .csv and then import the .csv.

If you're working in a Windows environment and need to automate things then you could write a vb script and call the vb script for saving the excel as .csv (if the SAS option is set to XCMD and not NOXCMD)

[PSARAVANAN]

Hi Patrick,

Thanks for your response.

1. Can you please explain the procedure if I have to do the same in UNIX environment?
2. And also, is it possible to convert the file directly from excel to SAS dataset instead of going through the .csv conversion?

[Kurt_Bremser]

AFAIK, Libreoffice is available on Linux and can be run in batch mode from the commandline to do such conversions.

[andreas_lds]

To the second question: no, afaik this is not possible. There could be a way involving java objects and and some fancy stuff from Apache, but I never did this, but I heard some people use this on Solaris to create and update Excel files.

[ed_sas_member]

Hi @PSARAVANAN 

Have you tried to run a proc import:

proc import datafile="&path/your_file.xlsx"
			dbms=xlsx
			out=work.mydata
			replace;
	sheet=/*put sheet name*/;
run;

[Kurt_Bremser]

---

@ed_sas_member wrote:

Hi @PSARAVANAN 

Have you tried to run a proc import:

proc import datafile="&path/your_file.xlsx"
			dbms=xlsx
			out=work.mydata
			replace;
	sheet=/*put sheet name*/;
run;

---

I think that the OP's problem is that they do not have ACCESS to PC Files licensed, so that won't work.