Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
cheolho Absent Member.
Absent Member.

Using export/import to EXCEL ??

       77 excel-app       handle of application.

       77 excel-doc       handle of workbook.

       77 excel-sheets    handle of sheets.

       77 excel-worksheet handle of worksheet.


       Main Section.

           create @Application of @Excel handle in excel-app.

           modify excel-app              @Workbooks::Add() giving excel-doc.

            inquire excel-doc sheets() in excel-sheets.

            inquire excel-sheets item(1) in excel-worksheet.

            inquire excel-worksheet cells in excel-range.

           MODIFY excel-worksheet Range("A1")::Value = "테스트". (Value = "TEST")


Cerate Excel Sheet.

Value = "테스트" -> A1 Text value : Å×½ºÆ®  

Value = "TEST" -> A1 Text value : TEST


Why, not support is Korea Language Code??

1 Reply
Micro Focus Expert
Micro Focus Expert

RE: Using export/import to EXCEL ??

The compiler has an option -Sc ... -Sc KSC

This -Sc option must be followed by one of the following encoding scheme identifiers: BIG5, DBC, EUC, GB, KSC, or SJC. When used, this option causes the compiler to assume that the input source is encoded using the specified encoding scheme. This allows the compiler to recognize double-byte characters used in string literals and comments.

The runtime has a configuration variable CODE_SYSTEM... although you may not need CODE_SYSTEM unless you plan to display double byte characters ... The runtime configuration variable CODE_SYSTEM tells the runtime if double-byte character data is being accepted or displayed, and which code system (that is, which standard for encoding Japanese and other Asian character sets, for example) is being used. Each code system has a range of values that it allows within each byte of a two-byte character, so identifying the code system allows the runtime to recognize character boundaries when it is processing double-byte data for ACCEPT and DISPLAY statements.

I do not know if this is true for Ecel, many programs like MSSQL / DB2 either use Locale or some environment setting to specify the types of characters that the table can have, so it may be the case where you cannot have English and Korean characters in the same table, or it may be that you need to change Locale in order to place Korean characters into the table.

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.