excel gbk等編碼解碼庫

js-codepage

Codepages?are character encodings. In many contexts, single- or double-byte character sets are used in lieu of Unicode encodings. The codepages map between characters and numbers.

Setup

In node:

varcptable=require('codepage');

In the browser:

<scriptsrc="cptable.js"></script><scriptsrc="cputils.js"></script>

Alternatively, use the full version in the dist folder:

<scriptsrc="cptable.full.js"></script>

The complete set of codepages is large due to some Double Byte Character Set encodings. A much smaller file that only includes SBCS codepages is provided in this repo (sbcs.js), as well as a file for other projects (cpexcel.js)

If you know which codepages you need, you can include individual scripts for each codepage. The individual files are provided in the?bits/?directory. For example, to include only the Mac codepages:

<scriptsrc="bits/10000.js"></script><scriptsrc="bits/10006.js"></script><scriptsrc="bits/10007.js"></script><scriptsrc="bits/10029.js"></script><scriptsrc="bits/10079.js"></script><scriptsrc="bits/10081.js"></script>

All of the browser scripts define and append to the?cptable?object. To rename the object, edit the?JSVAR?shell variable in?make.sh?and run the script.

The utilities functions are contained in?cputils.js, which assumes that the appropriate codepage scripts were loaded.

The script will manipulate?module.exports?if available . This is not always desirable. To prevent the behavior, define?DO_NOT_EXPORT_CODEPAGE.

Usage

Most codepages are indexed by number. To get the Unicode character for a given codepoint, use the?dec?property:

varunicode_cp10000_255=cptable[10000].dec[255];// ˇ

To get the codepoint for a given character, use the?enc?property:

varcp10000_711=cptable[10000].enc[String.fromCharCode(711)];// 255

There are a few utilities that deal with strings and buffers:

var匯總=cptable.utils.decode(936,[0xbb,0xe3,0xd7,0xdc]);varbuf=cptable.utils.encode(936,匯總);varsushi=cptable.utils.decode(65001,[0xf0,0x9f,0x8d,0xa3]);// ??varsbuf=cptable.utils.encode(65001,sushi);

cptable.utils.encode(CP, data, ofmt)?accepts a String or Array of characters and returns a representation controlled by?ofmt:

Default output is a Buffer (or Array) of bytes (integers between 0 and 255)

If?ofmt == 'str', return a binary String (byte?i?is?o.charCodeAt(i))

If?ofmt == 'arr', return an Array of bytes

cptable.utils.decode(CP, data)?accepts a byte String or Array of numbers or Buffer and returns a JS string.

Known Excel Codepages

A much smaller script, including only the codepages known to be used in Excel, is available under the name?cpexcel. It exposes the same variable?cptable?and is suitable as a drop-in replacement when the full codepage tables are not needed.

In node:

varcptable=require('codepage/dist/cpexcel.full');

Rolling your own script

The?make.sh?script in the repo can take a manifest and generate JS source.

Usage:

$ bash make.sh path_to_manifest output_file_name JSVAR

where

JSVAR?is the name of the exported variable (generally?cptable)

output_file_name?is the output file (cpexcel.js,?cptable.js, ...)

path_to_manifest?is the path to the manifest file.

The manifest file is expected to be a CSV with 3 columns:

<codepage number>,<source>,<size>

If a source is specified, it will try to download the specified file and parse. The file format is expected to follow the format from the unicode.org site. The size should be?1?for a single-byte codepage and?2?for a double-byte codepage. For mixed codepages (which use some single- and some double-byte codes), the script assumes the mapping is a prefix code and generates efficient JS code.

Generated scripts only include the mapping.?cat?a mapping with?cputils.js?to produce a complete script like?cpexcel.full.js.

Building the complete script

This script uses?voc. The script to build the codepage tables and the JS source is?codepage.md, so building involves?voc codepage.md.

Generated Codepages

The complete list of codepages can be found in the file?pages.csv.

Some codepages are easier to implement algorithmically. Since those character tables are not generated, there is no corresponding entry (they are "magic").

CP#SourceDescription

37unicode.orgIBM EBCDIC US-Canada

437unicode.orgOEM United States

500unicode.orgIBM EBCDIC International

620NLSMazovia (Polish) MS-DOS

708Windows 7Arabic (ASMO 708)

720Windows 7Arabic (Transparent ASMO); Arabic (DOS)

737unicode.orgOEM Greek (formerly 437G); Greek (DOS)

775unicode.orgOEM Baltic; Baltic (DOS)

808unicode.orgOEM Russian; Cyrillic + Euro symbol

850unicode.orgOEM Multilingual Latin 1; Western European (DOS)

852unicode.orgOEM Latin 2; Central European (DOS)

855unicode.orgOEM Cyrillic (primarily Russian)

857unicode.orgOEM Turkish; Turkish (DOS)

858Windows 7OEM Multilingual Latin 1 + Euro symbol

860unicode.orgOEM Portuguese; Portuguese (DOS)

861unicode.orgOEM Icelandic; Icelandic (DOS)

862unicode.orgOEM Hebrew; Hebrew (DOS)

863unicode.orgOEM French Canadian; French Canadian (DOS)

864unicode.orgOEM Arabic; Arabic (864)

865unicode.orgOEM Nordic; Nordic (DOS)

866unicode.orgOEM Russian; Cyrillic (DOS)

869unicode.orgOEM Modern Greek; Greek, Modern (DOS)

870Windows 7IBM EBCDIC Multilingual/ROECE (Latin 2)

872unicode.orgOEM Cyrillic (primarily Russian) + Euro Symbol

874unicode.orgWindows Thai

875unicode.orgIBM EBCDIC Greek Modern

895NLSKamenicky (Czech) MS-DOS

932unicode.orgJapanese Shift-JIS

936unicode.orgSimplified Chinese GBK

949unicode.orgKorean

950unicode.orgTraditional Chinese Big5

1010IBMIBM EBCDIC French

1026unicode.orgIBM EBCDIC Turkish (Latin 5)

1047Windows 7IBM EBCDIC Latin 1/Open System

1132IBMIBM EBCDIC Lao (1132 / 1133 / 1341)

1140Windows 7IBM EBCDIC US-Canada (037 + Euro symbol)

1141Windows 7IBM EBCDIC Germany (20273 + Euro symbol)

1142Windows 7IBM EBCDIC Denmark-Norway (20277 + Euro symbol)

1143Windows 7IBM EBCDIC Finland-Sweden (20278 + Euro symbol)

1144Windows 7IBM EBCDIC Italy (20280 + Euro symbol)

1145Windows 7IBM EBCDIC Latin America-Spain (20284 + Euro symbol)

1146Windows 7IBM EBCDIC United Kingdom (20285 + Euro symbol)

1147Windows 7IBM EBCDIC France (20297 + Euro symbol)

1148Windows 7IBM EBCDIC International (500 + Euro symbol)

1149Windows 7IBM EBCDIC Icelandic (20871 + Euro symbol)

1200magicUnicode UTF-16, little endian (BMP of ISO 10646)

1201magicUnicode UTF-16, big endian

1250unicode.orgWindows Central Europe

1251unicode.orgWindows Cyrillic

1252unicode.orgWindows Latin I

1253unicode.orgWindows Greek

1254unicode.orgWindows Turkish

1255unicode.orgWindows Hebrew

1256unicode.orgWindows Arabic

1257unicode.orgWindows Baltic

1258unicode.orgWindows Vietnam

1361Windows 7Korean (Johab)

10000unicode.orgMAC Roman

10001Windows 7Japanese (Mac)

10002Windows 7MAC Traditional Chinese (Big5)

10003Windows 7Korean (Mac)

10004Windows 7Arabic (Mac)

10005Windows 7Hebrew (Mac)

10006unicode.orgGreek (Mac)

10007unicode.orgCyrillic (Mac)

10008Windows 7MAC Simplified Chinese (GB 2312)

10010Windows 7Romanian (Mac)

10017Windows 7Ukrainian (Mac)

10021Windows 7Thai (Mac)

10029unicode.orgMAC Latin 2 (Central European)

10079unicode.orgIcelandic (Mac)

10081unicode.orgTurkish (Mac)

10082Windows 7Croatian (Mac)

12000magicUnicode UTF-32, little endian byte order

12001magicUnicode UTF-32, big endian byte order

20000Windows 7CNS Taiwan (Chinese Traditional)

20001Windows 7TCA Taiwan

20002Windows 7ETEN Taiwan (Chinese Traditional)

20003Windows 7IBM5550 Taiwan

20004Windows 7TeleText Taiwan

20005Windows 7Wang Taiwan

20105Windows 7Western European IA5 (IRV International Alphabet 5)

20106Windows 7IA5 German (7-bit)

20107Windows 7IA5 Swedish (7-bit)

20108Windows 7IA5 Norwegian (7-bit)

20127magicUS-ASCII (7-bit)

20261Windows 7T.61

20269Windows 7ISO 6937 Non-Spacing Accent

20273Windows 7IBM EBCDIC Germany

20277Windows 7IBM EBCDIC Denmark-Norway

20278Windows 7IBM EBCDIC Finland-Sweden

20280Windows 7IBM EBCDIC Italy

20284Windows 7IBM EBCDIC Latin America-Spain

20285Windows 7IBM EBCDIC United Kingdom

20290Windows 7IBM EBCDIC Japanese Katakana Extended

20297Windows 7IBM EBCDIC France

20420Windows 7IBM EBCDIC Arabic

20423Windows 7IBM EBCDIC Greek

20424Windows 7IBM EBCDIC Hebrew

20833Windows 7IBM EBCDIC Korean Extended

20838Windows 7IBM EBCDIC Thai

20866Windows 7Russian Cyrillic (KOI8-R)

20871Windows 7IBM EBCDIC Icelandic

20880Windows 7IBM EBCDIC Cyrillic Russian

20905Windows 7IBM EBCDIC Turkish

20924Windows 7IBM EBCDIC Latin 1/Open System (1047 + Euro symbol)

20932Windows 7Japanese (JIS 0208-1990 and 0212-1990)

20936Windows 7Simplified Chinese (GB2312-80)

20949Windows 7Korean Wansung

21025Windows 7IBM EBCDIC Cyrillic Serbian-Bulgarian

21027NLSExtended/Ext Alpha Lowercase

21866Windows 7Ukrainian Cyrillic (KOI8-U)

28591unicode.orgISO 8859-1 Latin 1 (Western European)

28592unicode.orgISO 8859-2 Latin 2 (Central European)

28593unicode.orgISO 8859-3 Latin 3

28594unicode.orgISO 8859-4 Baltic

28595unicode.orgISO 8859-5 Cyrillic

28596unicode.orgISO 8859-6 Arabic

28597unicode.orgISO 8859-7 Greek

28598unicode.orgISO 8859-8 Hebrew (ISO-Visual)

28599unicode.orgISO 8859-9 Turkish

28600unicode.orgISO 8859-10 Latin 6

28601unicode.orgISO 8859-11 Latin (Thai)

28603unicode.orgISO 8859-13 Latin 7 (Estonian)

28604unicode.orgISO 8859-14 Latin 8 (Celtic)

28605unicode.orgISO 8859-15 Latin 9

28606unicode.orgISO 8859-15 Latin 10

29001Windows 7Europa 3

38598Windows 7ISO 8859-8 Hebrew (ISO-Logical)

47451unicode.orgAtari ST/TT

50220magicISO 2022 JIS Japanese with no halfwidth Katakana

50221magicISO 2022 JIS Japanese with halfwidth Katakana

50222magicISO 2022 Japanese JIS X 0201-1989 (1 byte Kana-SO/SI)

50225magicISO 2022 Korean

50227magicISO 2022 Simplified Chinese

51932Windows 7EUC Japanese

51936Windows 7EUC Simplified Chinese

51949Windows 7EUC Korean

52936Windows 7HZ-GB2312 Simplified Chinese

54936Windows 7GB18030 Simplified Chinese (4 byte)

57002Windows 7ISCII Devanagari

57003Windows 7ISCII Bengali

57004Windows 7ISCII Tamil

57005Windows 7ISCII Telugu

57006Windows 7ISCII Assamese

57007Windows 7ISCII Oriya

57008Windows 7ISCII Kannada

57009Windows 7ISCII Malayalam

57010Windows 7ISCII Gujarati

57011Windows 7ISCII Punjabi

65000magicUnicode (UTF-7)

65001magicUnicode (UTF-8)

unicode.org?refers to the Unicode Consortium Public Mappings, a database of various mappings between Unicode characters and respective character sets. The tables are processed by a few scripts in the build process.

IBM?refers to the IBM coded character set database. Even though IBM uses a different numbering scheme from Windows, the IBM numbers are used when there is no conflict. The tables are manually generated from the symbol manifests.

Windows 7?refers to direct inspection of Windows 7 machines using .NET class?System.Text.Encoding. The enclosed?MakeEncoding.cs?C# program brute-forces code pages.?MakeEncoding.cs?deviates from unicode.org in some cases. When they map a given code to different characters, unicode.org value is used. When unicode.org does not prescribe a value,?MakeEncoding.cs?value is used.

NLS?refers to the National Language Support files supplied in various versions of Windows. In older versions of Windows (like Windows 98) these files followed the name pattern?CP_#.NLS, but newer versions use the name pattern?C_#.NLS.

Testing

make test?will run the nodejs-based test.

To run the in-browser tests, run a local server and go to the?ctest?directory.?make ctestserv?will start a python?SimpleHTTPServer?server on port 8000.

To update the browser artifacts, run?make ctest.

Sources

Unicode Consortium Public Mappings

Windows Code Page Enumeration

Windows Code Page Identifiers

IBM Coded Character Sets

ISO/IEC 2022 / ECMA-35

International Register of Coded Character Sets To Be Used With Escape Sequences

Japanese Character Encoding for Internet Messages

?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請聯(lián)系作者
【社區(qū)內(nèi)容提示】社區(qū)部分內(nèi)容疑似由AI輔助生成,瀏覽時請結(jié)合常識與多方信息審慎甄別。
平臺聲明:文章內(nèi)容(如有圖片或視頻亦包括在內(nèi))由作者上傳并發(fā)布,文章內(nèi)容僅代表作者本人觀點,簡書系信息發(fā)布平臺,僅提供信息存儲服務(wù)。

相關(guān)閱讀更多精彩內(nèi)容

友情鏈接更多精彩內(nèi)容