Read out multiple data in Excel


I need your help again. I have an Excel file in which I would like to read out the correct tax code for the country code and the tax rate.

For example, the invoice shows 00 (Germany) and 19%. So I need the indicator 10.


Hi @nina.wenner

Convert the data into Dictionary with key as 0-19 and values as 10.
The key is a combination of country code and tax rate with - in between and the value is tax code.
The key and value are of type String

I don’t really understand it. Can you give me an example? I haven’t worked with Dictionary yet. Thank you very much for your help.

Hi @nina.wenner

Check the xaml file attached

Tax Code.xaml (7.7 KB)

Thank you for the detailed example → it works!!!

That’s great to hear !! Don’t forget to mark your topic as solved so we don’t run into it while focusing on unresolved topics :wink:
Happy automation !

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.