topic Re: Unicode error while upgrading from 4.6 to ECC 6.0 in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/unicode-error-while-upgrading-from-4-6-to-ecc-6-0/m-p/3596423#M866095 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>In the OPEN DATASET STATEMENT ADD THE ENCODING ADDITION IN TEXT MODE.</P><P></P><P></P><P>Regards,</P><P>Balakumar.G</P><P>Reward Points if helpful.</P></BODY></HTML> Tue, 25 Mar 2008 08:23:30 GMT Former Member 2008-03-25T08:23:30Z Unicode error while upgrading from 4.6 to ECC 6.0 https://community.sap.com/t5/application-development-and-automation-discussions/unicode-error-while-upgrading-from-4-6-to-ecc-6-0/m-p/3596421#M866093 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I am getting unicode errror while upgrading from 4.6 to ECC 6.0, when iam trying to open downloaded file in excel.</P><P>In debugging, error occurs while executing statment "CALL METHOD OF obj_ex_sheet " in the code given below:</P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P>FORM open_downloaded_file_in_excel *</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>FORM open_downloaded_file_in_excel.</P><P> DATA:</P><P> lv_ole_books TYPE ole2_object,</P><P> lv_ole_sheets TYPE ole2_object,</P><P> lv_subrc LIKE sy-subrc,</P><P> lv_title(70) TYPE c,</P><P> lv_text1(70) TYPE c,</P><P> lv_text2(70) TYPE c.</P><P></P><UL><LI level="1" type="ul"><P>start excel</P></LI></UL><P> CREATE OBJECT obj_ex_sheet 'EXCEL.SHEET'.</P><P> IF sy-subrc NE 0.</P><P> lv_subrc = sy-subrc.</P><P> FREE OBJECT obj_ex_sheet.</P><P> PERFORM error_handling_ms_excel USING lv_subrc.</P><P> ENDIF.</P><P></P><P> CALL METHOD OF obj_ex_sheet 'Application' = obj_ex_app.</P><P> IF sy-subrc NE 0.</P><P> lv_subrc = sy-subrc.</P><P> FREE OBJECT obj_ex_app.</P><P> FREE OBJECT obj_ex_sheet.</P><P> PERFORM error_handling_ms_excel USING lv_subrc.</P><P> ENDIF.</P><P> SET PROPERTY OF obj_ex_app 'Visible' = 1.</P><P></P><UL><LI level="1" type="ul"><P>open data file: main file</P></LI></UL><P> CALL METHOD OF obj_ex_app 'Workbooks' = lv_ole_books.</P><P> CALL METHOD OF lv_ole_books 'Open' = obj_ex_wbook</P><P> EXPORTING #1 = gv_filename</P><P> #2 = 2</P><P> #3 = 0</P><P> #4 = 1</P><P> #5 = 0</P><P> #6 = 0</P><P> #7 = 1.</P><P> IF sy-subrc NE 0.</P><P> lv_subrc = sy-subrc.</P><P> FREE OBJECT obj_ex_wbook.</P><P> FREE OBJECT obj_ex_app.</P><P> FREE OBJECT obj_ex_sheet.</P><P> PERFORM error_handling_ms_excel USING lv_subrc.</P><P> ENDIF.</P><P> FREE OBJECT lv_ole_books.</P><P></P><P> CALL METHOD OF obj_ex_wbook 'Worksheets' = lv_ole_sheets.</P><P> CALL METHOD OF lv_ole_sheets 'Item' = obj_ex_wsheet</P><P> EXPORTING #1 = 1.</P><P> FREE OBJECT lv_ole_sheets.</P><P></P><P> GET PROPERTY OF obj_ex_wsheet 'UsedRange' = obj_ex_usedrange.</P><P> CALL METHOD OF obj_ex_usedrange 'AutoFormat'</P><P> EXPORTING #1 = 18.</P><P> SET PROPERTY OF obj_ex_wsheet 'Name' = sy-tcode.</P><P> FREE OBJECT obj_ex_usedrange.</P><P></P><P> PERFORM free_ole_objects.</P><P></P><P> CALL FUNCTION 'FLUSH'</P><P> EXCEPTIONS</P><P> OTHERS = 0.</P><P></P><P>ENDFORM. </P><P></P><P>regards,</P><P>Divya</P></BODY></HTML> Tue, 25 Mar 2008 08:08:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/unicode-error-while-upgrading-from-4-6-to-ecc-6-0/m-p/3596421#M866093 Former Member 2008-03-25T08:08:17Z Re: Unicode error while upgrading from 4.6 to ECC 6.0 https://community.sap.com/t5/application-development-and-automation-discussions/unicode-error-while-upgrading-from-4-6-to-ecc-6-0/m-p/3596422#M866094 <HTML><HEAD></HEAD><BODY><P>HI,</P><P>GO TO THE ATTRIBUTES OF UR PROGRAM,IN THAT CHECK THE CHECK BOX WHICH HAS UNICODE AND THE ACTIVATE.</P><P></P><P>Reward if helpful</P><P>Regards</P><P>Vodka.</P></BODY></HTML> Tue, 25 Mar 2008 08:16:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/unicode-error-while-upgrading-from-4-6-to-ecc-6-0/m-p/3596422#M866094 Former Member 2008-03-25T08:16:36Z Re: Unicode error while upgrading from 4.6 to ECC 6.0 https://community.sap.com/t5/application-development-and-automation-discussions/unicode-error-while-upgrading-from-4-6-to-ecc-6-0/m-p/3596423#M866095 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>In the OPEN DATASET STATEMENT ADD THE ENCODING ADDITION IN TEXT MODE.</P><P></P><P></P><P>Regards,</P><P>Balakumar.G</P><P>Reward Points if helpful.</P></BODY></HTML> Tue, 25 Mar 2008 08:23:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/unicode-error-while-upgrading-from-4-6-to-ecc-6-0/m-p/3596423#M866095 Former Member 2008-03-25T08:23:30Z Re: Unicode error while upgrading from 4.6 to ECC 6.0 https://community.sap.com/t5/application-development-and-automation-discussions/unicode-error-while-upgrading-from-4-6-to-ecc-6-0/m-p/3596424#M866096 <HTML><HEAD></HEAD><BODY><P>I hv tried both the solutions given above but my problem has not yet solved.</P></BODY></HTML> Tue, 25 Mar 2008 09:21:39 GMT https://community.sap.com/t5/application-development-and-automation-discussions/unicode-error-while-upgrading-from-4-6-to-ecc-6-0/m-p/3596424#M866096 Former Member 2008-03-25T09:21:39Z Re: Unicode error while upgrading from 4.6 to ECC 6.0 https://community.sap.com/t5/application-development-and-automation-discussions/unicode-error-while-upgrading-from-4-6-to-ecc-6-0/m-p/3596425#M866097 <HTML><HEAD></HEAD><BODY><P>Hi Divya,</P><P>I am facing the same issue.</P><P>Have you found a solution to the problem?</P><P></P><P>Regards,</P><P>Garima.</P></BODY></HTML> Tue, 03 Nov 2009 15:18:33 GMT https://community.sap.com/t5/application-development-and-automation-discussions/unicode-error-while-upgrading-from-4-6-to-ecc-6-0/m-p/3596425#M866097 Former Member 2009-11-03T15:18:33Z