美文网首页
excel gbk等编码解码库

excel gbk等编码解码库

作者: 江水流白 | 来源:发表于2022-07-11 08:50 被阅读0次

    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

    895NLSKamenický (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

    相关文章

      网友评论

          本文标题:excel gbk等编码解码库

          本文链接:https://www.haomeiwen.com/subject/kbagbrtx.html