Hi,
We have a requirement to read Spanish and Korean data from an excel file, uploaded in Appian as input.
We need to display that data and use it for some calculations, but all in English.
Is there any plugin or function to do the full translation to English, after getting the file in Appian?
Discussion posts and replies are publicly visible
Not sure if this helps, but can we try extracting the data from an Excel sheet using the available plugins, and then use the data to be translated using the Google translate APIs and display the data in the Screen in English ?
Yes, I would agree with harshav here, the Google Translate API is very powerful. You can even use it to detect the language in the excel file and then run the API to translate it if you needed to.
I have used one workaround in my application where the row header was in Korean while data was in number and English
Steps:
1: Read the full excel file:
local!filedata: readExcelSheet(
file: ri!file,
startRow:1
)
2: Flatten the first row data:
local!header: a!flatten(local!filedata.values[1])
3: get the index of column from where to read data
local!pos1: tointeger( wherecontain( cons!KOREAN_DATA1, local!header)
local!pos2: tointeger( wherecontain( cons!KOREAN_DATA2, local!header)
4:convert the data in your cdt type:
a!foreach(
item: index( fn!readExcelSheet(file: ri!file, startRow: 2),"values",{} ),
expresssion: type!CDT(
val1: fv!item.[ local!pos1 ],
val2: fv!item.[ local!pos2 ]
This CDT you can pass through rule input.
Thanks,
Gaurav Singh