cancel
Showing results for 
Search instead for 
Did you mean: 

Excel Download (chinese Charaters) in Webdynpro Java

Former Member
0 Kudos

Hi Experts,

I have implemented webdynpro Java program to download the data from Webdynpro Java table to MS Excel, but it is unable to download the Chinese Characters from the Webdynpro app Table to Excel? Wondering if there is any Unicode issue (english-english download) is working fine.

Currently we are on WAS 7.0,

NWDS Version: 7.0.18

Netweaver 04s.

Would really appreciate if you could let me know if there is any Java api / Java class in any package which does not have Unicode limitation, and can handle Chinese Characters?

Currently i am using

com.sap.tc.webdynpro.progmodel.api.IWDModifiableBinaryType;

com.sap.tc.webdynpro.services.sal.url.api.WDWebResourceType;

Awaiting for your reply.

Thanks in advance.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

yes it does, I found the Java package which supports download Excel from Web dynpro java application is org.apache.poi.hssf.usermodel.HSSFWorkbook, but just wondering how to check the Java package version from NWDS which is there on a Webdynpro Java DC? any ideas? and also If I want to updated/replace  the existing Java package from NWDS (from a Webdynpro DC) how can I do that . Please help resolving the issue

swapnil_shelke
Explorer
0 Kudos

Does the issue resolved or not?

If not please let us know what code you are doing for the Excel download from Table and also let us know code for Data assignment to the Table Column?

Kindly check whether Cell Data type has General Format of Text Format while downloading?

junwu
Active Contributor
0 Kudos

can your system display chinese?

Former Member
0 Kudos

Hi Jun Wu,

Yes the system displays in Chinese. and I see that you have replied to other similar thread about downloading the data from Web dynpro Java to Excel, the fact is that we are using Apache poi, poi2.5.jar and it is unable to read Chinese characters and download to Excel and still we are in Netweaver 7.0 and running NWDI with Java 1.4.2 (JDK1.4), so wondering is there any other .jar file to download the Chinese characters? I see people using Jxl.jar. but still not sure if it can handle Chinese Characters. Can you please take a look and help in resolving this issue. I did so much of analysis, did not get any solution in SCN or Google search.

Thank you so much in advance.

junwu
Active Contributor
0 Kudos

try some new version of poi,

before poi 3.5, it can run on jdk1.4