Data in excel sheet is not in English and header is making errors

[SaraNof]

I have Data in excel sheet are not in english, they have been shown as question marks

how to let this data be shown as readable form?

another issue that the header in the excel sheet is making this error, I believe it is the same issue above, about the language

------------------------------
Sara Nof
------------------------------

[Dexter_Whelan_SAS]

what are the headers of your excel sheet in question what do they actually say?

------------------------------
Dexter Whelan
Senior Developer/Mentor
SAS
Europe/London
------------------------------

[zdenek.kabatek]

Hi, Sara,

it is due to non unicode support in your excel VBO. Search the code stage for following string "Clipboard.GetDataObject().GetData(DataFormats.Text, True)" and change it to "Clipboard.GetDataObject().GetData(DataFormats.UnicodeText, True)" that should fix your issue.

Regards

Zdenek

------------------------------
Zdeněk Kabátek
Head of Professional Services
NEOOPS
http://www.neoops.com/
Europe/Prague
------------------------------

[SaraNof]

Hi Zdenek, 

Where to search?

------------------------------
Sara Nof
------------------------------

[zdenek.kabatek]

Hi, Sara,

it depends on VBO you use. It may be in the action (Code stage) you call or in Initialise action/page. When you click on big rectangle to get to Business Object properties window and then you choose Global code tab you should find it there.

Regards

Zdenek

------------------------------
Zdeněk Kabátek
Head of Professional Services
NEOOPS
http://www.neoops.com/
Europe/Prague
------------------------------