Hey Beatriz Sabino,

Its Not Working Properly, when I upload Empty_Excel file it show the warning But Is Showing Data Will Added Successfully.

I Attach Excel file just see it.

Hi Sagar,

Ok, so the condition FileContent = NullBinary() won't work, because the file will never be exactly 0 bytes, even if it's completely empty. 

Before I provide a proper solution, could you confirm if the Excel file you sent is the only template you want to check for blank content? Will the Excel file always contain a header? 

Ya it is only template, and If Contains Any Header otherwise  no need. 

Thank you for the information.

I’ve updated the .oml again.

I used the Forge component Advanced Excel to retrieve the properties of the uploaded file and check if it contains more than one row (which would be the header). This logic is implemented in the server action ExcelFile_GetProperties.

Since it's best practice to have only one server action in a client action, I created a new server action called ExcelFile_Upload, which encapsulates the logic to check if the Excel file is empty and to create records in the database. 

In the client action UploadOnClick, I call the newly created server action. If the file is empty, a message is displayed to the user. I also kept the condition to check whether the user has uploaded a file, just to ensure that an actual file is selected. 

Dear Beatriz Sabino , I sincerely appreciate your help with this task. Your support was invaluable for me. Thank you...…