| || |
QTP Datatable doesnt recognize Thai language chars
This is getting very weird to me.
I have an spreadsheet which along with English chars also contain some Thai language data. The Thai lang. data in spreadsheet can only be seen correctly if you have set the cell font to Courier Thai. Point noted here is that when this thai cell is selected, Fx(formula bar) for it shows some junk chars.
Now when I do ImportSheet method to import the sheet, I see the datatable displays junk chars same as the ones shown in Fx Thai part of the excel sheet.
Do we need any kind of a add-in?
I think there should be someting to edit the Formula Bar. If we can do it, problem will be solved.
Any wayouts for this will be appreciated.
Re: QTP Datatable doesnt recognize Thai language c
I would suggest you to rather use a external sheet and get the data using Excel COM API. for More details on the same search for Excel.Application on the forum