fail to import define from xlsx

Internal error

"Internal error" (the garbage can of error messages ...). That can be anything ...
Anything in the log file that gives more information?
BTW, there is also a lot of GUI-based, very user-friendly, software available on the market for generating define.xml, that doesn't use these awful Excel spreadsheets.

Thank Jozef. Unfortunately,…

Thank Jozef. Unfortunately, I didn't find any log for this.

I was trying to use Pinnacle 21 to do SDTM data validation. I used a program to replace my original sheet of Valuelevel and Codelists in my original data spec excel file with both sheets generated by Pinnacle 21 based on my SDTM data. This error came out when I imported the updated spec excel file. It doesn't have any issue when I try to import my original data spec excel file. I can fix it if I can learn what cause the issue. Just like you said, this error message is garbage can of error message. I have no idea what I can do for it unless I have to manually copy past to update both sheets. Which is not what I want as a programmer.    

I tried both libname and proc export to output updated excel in my program.  

Matt

on May 30, 2024

P21

Hi Zhongqing,   Based on…

Hi Zhongqing,

Based on your screenshot this does not relate to P21 Community. I will follow up with you via our Enterprise Support Desk to review further.

Kind regards,

Matt

thank you

thank you