How to validate excel content via Upload widgets

Hi Experts,


Can anyone guide me on how can i validate the excel upon uploading, check if the cell are empty and in correct format.


Thanks and Best regards.

Hi Joshua Aquino,

You have to read each column to see if is empty. So convert the excel file into record list and iterate.

Also interesting for you to see what actions the excel forge extension can provide for you to use:

https://www.outsystems.com/forge/component-overview/3943/excel-package-extension

Regards,

Hi Joshua


Try also the following component

https://www.outsystems.com/forge/component-overview/355/advanced-excel

Regards,

Hi Joshua Aquino, you have to use the built-in logic's such as "Excel To Record List". 

This method already read the Excel file and if some data is in the wrong format (imputed numbers when is text, or others), it raises an exception.

For advanced kinds of Excel, you could use an C# Extension with the library EPPlus, or use options already built in Forge, such as: 

https://www.outsystems.com/forge/component-overview/355/advanced-excel

https://www.outsystems.com/forge/component-overview/687/officeutils 

https://www.outsystems.com/forge/component-overview/1044/excel-package

https://www.outsystems.com/forge/component-overview/731/excel2rlist

https://www.outsystems.com/forge/component-overview/355/advanced-excel


Any question, please let me know!

Have a nice day!

Paulo Rossi

Hi,


Thanks for the reply.

You can create a function and then use built-in function, like: 

SyntaxEditor Code Snippet

DecimalToIntegerValidate()

, etc.