Karthik888 Posted May 29, 2010 Report Share Posted May 29, 2010 HI FRIENDS, I AM FACING ONE PROBLEM.I AM HAVING ONE EXCEL SHEET WHICH CONTAINS 11 SHEETS IN EACH SHEET EACH LANGUAGE STRINGS WILL BE AVAILABLE FOR EX : ENGLISH ,GERMAN,RUSSIAN,CHINESE.... etc.. NOW I AM TRYING TO READ THIS EXCEL SHEET AND TO LOAD THE CORRESPONDING DATAS IN A TABLE CONTROL.WHILE READING A RUSSIAN LANGUAGE I AM FACING A PROBLEM THE STRINGS WERE DISPLAYED AS"????".. EVEN I HAVE ENABLED USEUNICODE=TRUE IN LABVIEW.INI FILE TOO. BUT STILL I AM FACING THE SAME PROBLEM.. CAN ANY ONE PROVIDE A SOLUTION FOR THIS ........ REGARDS, KARTHIK Quote Link to comment
Ton Plomp Posted May 29, 2010 Report Share Posted May 29, 2010 Hi Karthik, check your keyboard, it looks like the shift key is stuck. On topic, go deep inside the Office Toolkit to find out which method is used to load the data from Excel into LabVIEW, perhaps there is a Uni-code aware method you can use. Keep us posted, Ton Quote Link to comment
Karthik888 Posted May 31, 2010 Author Report Share Posted May 31, 2010 Hii, No my shift key haven't struck .... still i am facing the problem while updating to Table.... Quote Link to comment
Ton Plomp Posted May 31, 2010 Report Share Posted May 31, 2010 Hii, No my shift key haven't struck .... still i am facing the problem while updating to Table.... What code do you use to get the data out of Excel? The NI office toolkit, or some other toolkit? Try to define which method is used to pump the data from Excel inot LabVIEW. Ton Quote Link to comment
daal Posted May 31, 2010 Report Share Posted May 31, 2010 Check this resource for more help : http://decibel.ni.co.../docs/DOC-10153 Dany Quote Link to comment
GoGators Posted June 2, 2010 Report Share Posted June 2, 2010 Hii, No my shift key haven't struck .... still i am facing the problem while updating to Table.... So I was playing around with Unicode in LabVIEW stuff, and for some controls and indicators you need to append the BOM to the front of the string. In LabVIEW that is typically 0xFFFE to the front of the string. It worked for the tree contro and table. Here is an example. Tell me if it works for you. UnicodeTable.vi Quote Link to comment
Liang Posted June 3, 2010 Report Share Posted June 3, 2010 So I was playing around with Unicode in LabVIEW stuff, and for some controls and indicators you need to append the BOM to the front of the string. In LabVIEW that is typically 0xFFFE to the front of the string. It worked for the tree contro and table. Here is an example. Tell me if it works for you. Hi GoGators, How did you make your string constant has "Force Unicode Text" item in right-click menu. Thanks Quote Link to comment
Karthik888 Posted June 3, 2010 Author Report Share Posted June 3, 2010 So I was playing around with Unicode in LabVIEW stuff, and for some controls and indicators you need to append the BOM to the front of the string. In LabVIEW that is typically 0xFFFE to the front of the string. It worked for the tree contro and table. Here is an example. Tell me if it works for you. Hey your Table Contol is working fine..... but i am facing a problem while reading from excel sheet and then loading to Table control............... Quote Link to comment
Ton Plomp Posted June 3, 2010 Report Share Posted June 3, 2010 On topic, go deep inside the Office Toolkit to find out which method is used to load the data from Excel into LabVIEW, perhaps there is a Uni-code aware method you can use. What code do you use to get the data out of Excel? The NI office toolkit, or some other toolkit? Try to define which method is used to pump the data from Excel inot LabVIEW. Hey your Table Contol is working fine..... but i am facing a problem while reading from excel sheet and then loading to Table control............... Karthik, could you please answer above question(s)? Then we can help you. Ton Quote Link to comment
Karthik888 Posted June 3, 2010 Author Report Share Posted June 3, 2010 Karthik, could you please answer above question(s)? Then we can help you. Ton ok i will list the things which i have done so for ,..... 1.I have LV 2009 2.I have enabled UseUnicode=TRUE in my LabVIEW.ini file. 3.In my control panal ->Regional Language->Language tab->I have enabled supplymentry language support. 4.I am having a excel sheet which contains russian language text. 5.I am using ActiveX for Excel read from LV and updating the datas in a Table Control.. 6.While reading the russian language text it displays ?????...... this the current problem i am facing can u suggest me the right path to read those datas and display it in a Table control........... Quote Link to comment
Ton Plomp Posted June 3, 2010 Report Share Posted June 3, 2010 5.I am using ActiveX for Excel read from LV and updating the datas in a Table Control.. Look we are getting closer, could you post a codeshot/snippet of the exact ActiveX call that loads the data into LabVIEW? Ton Quote Link to comment
Karthik888 Posted June 3, 2010 Author Report Share Posted June 3, 2010 Look we are getting closer, could you post a codeshot/snippet of the exact ActiveX call that loads the data into LabVIEW? Ton \ Hey Ton , Check my attached Pic like this only i am reading from XL sheet Using ActiveX......... Quote Link to comment
Karthik888 Posted June 4, 2010 Author Report Share Posted June 4, 2010 \ Hey Ton , Check my attached Pic like this only i am reading from XL sheet Using ActiveX......... Here is my code and XL Sheet in a image format .................... xl.vi Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.