Karthik888 Posted May 29, 2010 Report 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
Ton Plomp Posted May 29, 2010 Report 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
Karthik888 Posted May 31, 2010 Author Report Posted May 31, 2010 Hii, No my shift key haven't struck .... still i am facing the problem while updating to Table.... Quote
Ton Plomp Posted May 31, 2010 Report Posted May 31, 2010 On 5/31/2010 at 4:00 AM, Karthik888 said: 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
daal Posted May 31, 2010 Report Posted May 31, 2010 Check this resource for more help : http://decibel.ni.co.../docs/DOC-10153 Dany Quote
GoGators Posted June 2, 2010 Report Posted June 2, 2010 On 5/31/2010 at 4:00 AM, Karthik888 said: 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.viFetching info... Quote
Liang Posted June 3, 2010 Report Posted June 3, 2010 On 6/2/2010 at 9:54 PM, GoGators said: 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
Karthik888 Posted June 3, 2010 Author Report Posted June 3, 2010 On 6/2/2010 at 9:54 PM, GoGators said: 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
Ton Plomp Posted June 3, 2010 Report Posted June 3, 2010 On 5/29/2010 at 7:28 PM, Ton Plomp said: 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. On 5/31/2010 at 7:03 AM, Ton Plomp said: 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. On 6/3/2010 at 4:59 AM, Karthik888 said: 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
Karthik888 Posted June 3, 2010 Author Report Posted June 3, 2010 On 6/3/2010 at 6:33 AM, Ton Plomp said: 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
Ton Plomp Posted June 3, 2010 Report Posted June 3, 2010 On 6/3/2010 at 7:24 AM, Karthik888 said: 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
Karthik888 Posted June 3, 2010 Author Report Posted June 3, 2010 On 6/3/2010 at 12:37 PM, Ton Plomp said: 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
Karthik888 Posted June 4, 2010 Author Report Posted June 4, 2010 On 6/3/2010 at 12:51 PM, Karthik888 said: \ 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.viFetching info... Quote
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.