Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
Exchange rate National Bank of the Republic of Belarus in Google Sheets
=IMPORTXML(CONCATENATE("", TEXT(A1,"mm/dd/yyyy")),"/DailyExRates/Currency[@Id='145']/Rate/text()")
Нужно заменить A1 ячейкой с датой.
145 - USD
292 - EUR
298 - RUB
Остальные коды валют можно посмотреть в оригинальном xml:
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment