How to validate excel content via Upload widgets

Joshua Aquino

Question

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.

17 May 2019

Marco Arede

MVP

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:

Regards,

17 May 2019

Alberto Ferreira

Hi Joshua

Try also the following component

Regards,

17 May 2019

Rossi

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:

Any question, please let me know!

Have a nice day!

Paulo Rossi

17 May 2019

Jay-jay

Hi,

Thanks for the reply.

20 May 2019

IQ78

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

SyntaxEditor Code Snippet

DecimalToIntegerValidate()

, etc.

20 May 2019

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.