Background is to create a server action to upload, read and save the excel file to database without considering file name & sheet name and read all the data of the sheet using advance excel worksheet get properties component on outsystems developer cloud. When reading the excel file, it should start from row 6 and from columns A to Z.Currently I am stuck at assignment of output for Worksheet_GetProperties. (Refer to Pg 8 of pdf).I am not sure why cannot directly assign output by using the assign node. This situation happen for the assignment of output for the Workbook_Open as well but I just use a binary data to text for conversion so that I can have the output for Workbook_Open as Workbook_Open.ExcelFile.
Is there any additional/recommended step to be performed to assign the output for Worksheet_GetProperties? Suggestion from AI model to assign directly a local variable (WorksheetProps) with list of predefined structure data type to the output (Properties) of the Worksheet_GetProperties seems like do not work.
Hi @Yan Xu Tan ,
I can see that WorksheetProps is a list, but you are trying to assign a single Worksheet record to it.
If you need a list, use ListAppend to add the record. Otherwise, change the variable’s data type to the same Worksheet data type returned by Worksheet_GetProperties.
Please check the start index, as I’m also facing the same kind of issue.