how to display the order of the sheets as they are in xlsx file?

[tianerhu]

libname te xlsx 'C:\practice everyday\input\input01.xlsx';
proc contents data = te._all_;
run;

output:

order : SHEET BB SHEETA SHEETC  ,

but in xlsx file , order is following:

[ballardw · Accepted solution]

SAS doesn't "care" about the "order" of data sets in any library. Proc Contents reports on them alphabetically by name. If you must have one procedure, Proc Contents, report them in a specific order, then name the sheets alphabetically.

Please describe the "need" for matching the order in the Xlsx file. What process are you attempting that will fail if not processed in that manner?

[tianerhu]

Thank you for your help.