Reading Korean and Spanish data from excel

Question

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?

GauravSingh · Answer

Hi, 
 
 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