Read cells of the Excel file uploaded using file upload

Back to Forums

Suprio Roy

Solved

Question

Hi All,

I have an upload file widget in my screen where user can upload an Excel file with 1 mandatory field.

1. How to read the contents of the Excel file and store in an entity.

2. I am trying to use a for each loop on the column of the content to check for the mandatory field having data. Is that the approach correct one ?

09 Apr 2019

Amit Verma

Solution

Suprio Roy wrote:

Hi All,

I have an upload file widget in my screen where user can upload an Excel file with 1 mandatory field.

1. How to read the contents of the Excel file and store in an entity.

2. I am trying to use a for each loop on the column of the content to check for the mandatory field having data. Is that the approach correct one ?

Hi Suprio,

No need for Excel Package. Just use Excel To Record List Widget and loop on the column of the content to check for the mandatory field having data and also insert record into DataBase.

Thanks,

See solution in context

09 Apr 2019

1 reply

11 Apr 2019

Show thread

Hide thread

Suprio Roy

Amit Verma wrote:

Suprio Roy wrote:

Hi All,

I have an upload file widget in my screen where user can upload an Excel file with 1 mandatory field.

1. How to read the contents of the Excel file and store in an entity.

2. I am trying to use a for each loop on the column of the content to check for the mandatory field having data. Is that the approach correct one ?

Hi Suprio,

No need for Excel Package. Just use Excel To Record List Widget and loop on the column of the content to check for the mandatory field having data and also insert record into DataBase.

Thanks,

Hi Amit,

Thanks for your help. But the way you mentioned, can I check the no rows columns in the file uploaded by the user cause I want the user to have all the 18 columns(with data or without data)in the excel sheet in the defined arrangement.

11 Apr 2019

Sravan Vanteru

Hi Suprio Roy,

Use Excel Package component, you will get below built functions to manage excel file.

Sravan

09 Apr 2019

Amit Verma

Solution

Suprio Roy wrote:

Hi All,

I have an upload file widget in my screen where user can upload an Excel file with 1 mandatory field.

1. How to read the contents of the Excel file and store in an entity.

2. I am trying to use a for each loop on the column of the content to check for the mandatory field having data. Is that the approach correct one ?

Hi Suprio,

No need for Excel Package. Just use Excel To Record List Widget and loop on the column of the content to check for the mandatory field having data and also insert record into DataBase.

Thanks,

09 Apr 2019

1 reply

11 Apr 2019

Show thread

Hide thread

Suprio Roy

Amit Verma wrote:

Suprio Roy wrote:

Hi All,

I have an upload file widget in my screen where user can upload an Excel file with 1 mandatory field.

1. How to read the contents of the Excel file and store in an entity.

2. I am trying to use a for each loop on the column of the content to check for the mandatory field having data. Is that the approach correct one ?

Hi Suprio,

No need for Excel Package. Just use Excel To Record List Widget and loop on the column of the content to check for the mandatory field having data and also insert record into DataBase.

Thanks,

Hi Amit,

11 Apr 2019

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

See the full guidelines