libname xlsx engine options

[bassrick]

Hello,

I am currently using the new xlsx engine to generate my spreadsheets.  Works pretty darn good.  However, I have one example where I want sas to generate the column headers using the labels in the sas dataset.  This is running on a Linux box, with 9.4,

NOTE: SAS (r) Proprietary Software 9.4 (TS1M3)

Linux LIN X64 2.6.32-642.13.1.el6.x86_64 #1 SMP Wed Nov 23 16:03:01 EST 2016 x86_64 Red Hat Enterprise Linux Server release 6.8
      (Santiago)

Here is my code:

%let myfile = Prod_code_XREF_Bus_Cnsmr_&mmmyyyy..xlsx;
%let mytarget = &folder./&myfile.;

libname xl XLSX "&mytarget";

data xl.Sheet1;
  set prodhier;
run;

libname xl clear;

***********

Is there an option that can be set to say "use the var labels for column names" as you could with proc export?

[art297]

Honestly, I don't know. However, you can use the LABEL option with proc export using the DBMS=XLSX option.

see: chrome-extension://oemmndcbldboiebfnladdacbdfmadadm/http://support.sas.com/documentation/cdl/en/acpcref/69731/PDF/default/acpcref.pdf

Art, CEO, AnalystFinder.com

[Reeza]

The usual option is DBLABEL which doesn't appear to work with XLSX engine as far as I can see. 

😞

I used to use this with EXCELCS and EXCEL via LIBNAME. 

http://support.sas.com/documentation/cdl/en/acreldb/69580/HTML/default/viewer.htm#p1aksmchxr4bekn1bd...