Hi,
Is there anyway to add dropdown list to the excel file using ods tagsets or any other ods engine which creates ods excel file.
Thank you,
Ananda
Thank you for your reply. I am talking about adding data validation list for a perticular cell.
Hi:
Oh, you mean using the DATA choice on the ribbon to pick Data Validation like this:
I do not think you can do that with ODS. That would be a question for Tech Support. I know you can interact with the print and margin settings on the ribbon, using ODS EXCEL and ODS TAGSETS.EXCELXP options, but I am not aware of any way to insert data validation control into an XLSX file created with ODS.
Cynthia
Thats right
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.