I have made some examples I hope they help you with your project
Example_Flow_DataExtraction.zip (545.9 KB)
I will give it a try. Thanks alot!
Hi, your example stores normal string text to be extracted out and use as input to a webpage. Is it possible to store inside your excel file eg. “Belgium” as “Belgium+ intCounter+Environment.NewLine” inside a cell and when we extract it out it can be use directly in other steps?
Hi, data from an excel file will all ways be stored as an String variables in your UiPath project. If you have a column “Counter” for example and you want to type it in together with your String variable you have to parse it like this for example: int32.Parse(strCounter) it depends on the accuracy of your value if it is an value like 20,2 you are better of using it with Double.Parse or decimal for further accuracy. But the intCounter I had implemented in the example I gave you is meant for looping through your data but if you want to have it together with your text just parse it to an String like intCounter.ToString and it will look something like this: "Belgium " + intCount.ToString + Enviroment.NewLine or “Belgium” + " " + intCount.ToString + Enviroment.NewLine otherwise you will have your String value and the counter value smashed together. If you use an for each to store your variables in something like an queue you can implement the index of your row as well and just extract it from your stored data to use it further down your project because every time you loop trough your datatable where your excel data is stored in is an different index. I hope this helps!
noted, thanks alot for the advice. Will do some workarounds for my design.