Hi Diogo,

Please share the OML so that I can analyze your problem and will give you a perfect solution of your problem.

Thanks,

Sudip Pal

Hello Diogo,

I need more clarification in the requirement.. What exactly you want to do.

Do you want to create or update the data of a specific worksheet  to an entity?  

Because in the above flow you are copying the worksheet to new excel file and one more question after excel to record list what functionality you are performing?

Regards,

Pavan R

Hey Diogo ,

I am attaching a small demo of the thing that you want to achieve.If your problem will still not resolved then please share your OML and describe your problem little bit more.

Thanks ,

Sudip Pal

Hi everyone!

Thanks for your help @Sudip Pal and time! Sorry also for not responding earlier, but i was with a short time to deliver, but i want to share some important points that were raised in this discussion and also my solution for the problem.

1. Updating the component - before anything else i updated the component Advance Excel and retested every hints the were given to me.
2. Every possible solution presented here was ok for a simple excel with minimal configuration. And here is where i determined that was the problem. No matter what i did i couldn't make it work until the end because it gives some kind of error that could be the cell, the column, or some kind of filter. This file had 40+ columns and it is supposed to have 1000+ records so its a terrible time consuming process to figure out everything, specially if you don't have all the requirements defined.
3. I didn't know because I never paid attention because I never need it until today or is something that OutSystems add it meanwhile, but the excel widget from OutSystems allows you to select the sheet, which means that you don't need advance excel to select a different sheet from the first as long as the file configuration is equal to what OutSystems needs to import to a list.

SOLUTION:

1. I first imported the binary file to an entity so I can processed the file in the background using a LBPT.
2. In the process I checked the first cell (I know which row and column to start) with the Read_Cell action from the Advanced Excel. This action retrieves the value of cell and then i assign to a structure that is the same type that I need to create or update my db.
3. I cycle for every columns by incrementing the number columns with a local variable (i also know when is the last column.
4. When the last column is read then I create or update the entire row with the the columns values in db and then I do the same for the other rows by incrementing the rows with a local variable.
5. I know that the first column is a code and is mandatory, so when is empty i finish the importation.
6. At the end I delete the binary data from the entity I created.

I hope this help for someone with similar problem. The read cell is very good for retrieving the values when the excel file is complex. From my testing, importing 2000+ data it takes me 1min to import in the background.