CN102567019A - Method for supporting various character sets during application of EXCEL plug-in unit in WEB - Google Patents

Method for supporting various character sets during application of EXCEL plug-in unit in WEB Download PDF

Info

Publication number
CN102567019A
CN102567019A CN201110440882XA CN201110440882A CN102567019A CN 102567019 A CN102567019 A CN 102567019A CN 201110440882X A CN201110440882X A CN 201110440882XA CN 201110440882 A CN201110440882 A CN 201110440882A CN 102567019 A CN102567019 A CN 102567019A
Authority
CN
China
Prior art keywords
format
plug
unit
web
utf
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201110440882XA
Other languages
Chinese (zh)
Inventor
王柏华
张晖
匡立武
彭铸
单宝波
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Inspur Software Co Ltd
Original Assignee
Langchao Qilu Software Industry Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Langchao Qilu Software Industry Co Ltd filed Critical Langchao Qilu Software Industry Co Ltd
Priority to CN201110440882XA priority Critical patent/CN102567019A/en
Publication of CN102567019A publication Critical patent/CN102567019A/en
Pending legal-status Critical Current

Links

Landscapes

  • Document Processing Apparatus (AREA)
  • Information Transfer Between Computers (AREA)

Abstract

The invention discloses a method for supporting various character sets during application of EXCEL plug-in unit in WEB, and belongs to a processing method of a character code set. According to the method disclosed by the invention, after a plug-in unit program receives data of a server, the format of transmission data is firstly converted to UTF-8 (Unicode transformation format-8) format, and the UTF-8 format is further converted to the format of a target code character set. Compared with the prior art, the method disclosed by the invention can improve the compatibility and the stability of an information system, can improve the user experience, and further has great popularization and application values.

Description

A kind of WEB supports the method for multiple character set when using the EXCEL plug-in unit
 
Technical field
The present invention relates to a kind of character set disposal route, specifically a kind of WEB supports the method for multiple character set when using the EXCEL plug-in unit.
Background technology
At present, need become the Excel file to be saved on the client machine from the WEB conversion of page data of inquiry in many information-based products, make things convenient for the user that data are preserved and processed, use WEB application plug-in program to realize this function for this reason.WEB page data content has uncertainty; Mess code or loss of data can appear in the file content that present plug-in card program is derived when running into rare Chinese character; The problem analysis reason is the character set GB2312 that when exporting to the Excel file, only supports; Therefore the Chinese character beyond this character set can't be handled, and causes the file data mistake that generates.
Summary of the invention
Technical assignment of the present invention is the deficiency to above-mentioned prior art, supports the method for multiple character set when providing a kind of WEB to use the EXCEL plug-in unit.
Technical assignment of the present invention is realized by following mode: a kind of WEB supports the method for multiple character set when using the EXCEL plug-in unit; Be characterized in: after plug-in card program is received data in server; Become the UTF-8 form to the transmission Data Format Transform earlier, become target code character set form from the UTF-8 format conversion again.
Compared with prior art; In the inventive method; In program, increased the processing section of data character coded set, when client read the server end data, plug-in card program was through the character set processing section; Can change according to the coded character set of server data, be transferred to client after the conversion and show and derive.GB2312 can be supported in the character set processing section that increases, and GBK, GB18030 and UTF-8 character set also can and export to the Excel file in the client normal presentation thereby solved when containing rare Chinese character in the data.Through improvement to plug-in unit, improved the compatible and stable of infosystem, improved user experience, the problem the when user can worry the rare Chinese character derived data.
Embodiment
Support when WEB of the present invention being used the EXCEL plug-in unit with specific embodiment the method for multiple character set do below explanation at length.
Embodiment:
WEB of the present invention supports the method for multiple character set when using the EXCEL plug-in unit: after plug-in card program is received data in server; The encoding format information of reading of data at first; If not the UTF-8 form; Use the api function WideCharToMultiByte of Windows to convert binary data to the UTF-8 form, if the UTF-8 form is not changed; When client was output into the Excel file, the api function MultiByteToWideChar of use Windows became the Chinese character set form of client terminal local from the UTF-8 format conversion.For example server end GBK coded format data transmission is to the processing mode of client: the character set disposal route in the program becomes the UTF-8 form with the data-switching of server end earlier; After be transferred to client; Convert GB18030 in client to from UTF-8, and then realized the support of plug-in card program the GB18030 coded set.

Claims (1)

1. support the method for multiple character set when a WEB uses the EXCEL plug-in unit, it is characterized in that: after plug-in card program is received data in server, become the UTF-8 form to the transmission Data Format Transform earlier, become target code character set form from the UTF-8 format conversion again.
CN201110440882XA 2011-12-26 2011-12-26 Method for supporting various character sets during application of EXCEL plug-in unit in WEB Pending CN102567019A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201110440882XA CN102567019A (en) 2011-12-26 2011-12-26 Method for supporting various character sets during application of EXCEL plug-in unit in WEB

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201110440882XA CN102567019A (en) 2011-12-26 2011-12-26 Method for supporting various character sets during application of EXCEL plug-in unit in WEB

Publications (1)

Publication Number Publication Date
CN102567019A true CN102567019A (en) 2012-07-11

Family

ID=46412530

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201110440882XA Pending CN102567019A (en) 2011-12-26 2011-12-26 Method for supporting various character sets during application of EXCEL plug-in unit in WEB

Country Status (1)

Country Link
CN (1) CN102567019A (en)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103714128A (en) * 2013-12-11 2014-04-09 金蝶软件(中国)有限公司 Method and system for switching language types of display information
CN105243168A (en) * 2015-11-11 2016-01-13 中国建设银行股份有限公司 Data migration method and system
CN105740367A (en) * 2016-01-27 2016-07-06 青岛海尔智能家电科技有限公司 Multi-application integration method and device based on different character sets
CN106650090A (en) * 2016-12-21 2017-05-10 深圳市安冠科技有限公司 Method for quickly generating engineering terminal table, box diagram and system diagram based on data sharing
CN107209672A (en) * 2015-01-28 2017-09-26 日立公共系统有限公司 Information processor and information processing method

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030182128A1 (en) * 2002-03-08 2003-09-25 Katie Kuwata Method of encoding and decoding for multi-language applications
CN1664817A (en) * 2005-03-24 2005-09-07 上海全富汉得软件技术有限公司 Method for automatically switching between Oracle Form 9i and Microsoft Excel perspective charts
CN101034385A (en) * 2007-04-20 2007-09-12 松讯达中科电子(深圳)有限公司 Method for inputting information into computer via touching screen handset

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030182128A1 (en) * 2002-03-08 2003-09-25 Katie Kuwata Method of encoding and decoding for multi-language applications
CN1664817A (en) * 2005-03-24 2005-09-07 上海全富汉得软件技术有限公司 Method for automatically switching between Oracle Form 9i and Microsoft Excel perspective charts
CN101034385A (en) * 2007-04-20 2007-09-12 松讯达中科电子(深圳)有限公司 Method for inputting information into computer via touching screen handset

Cited By (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103714128A (en) * 2013-12-11 2014-04-09 金蝶软件(中国)有限公司 Method and system for switching language types of display information
CN107209672A (en) * 2015-01-28 2017-09-26 日立公共系统有限公司 Information processor and information processing method
CN107209672B (en) * 2015-01-28 2020-08-14 日立社会信息服务有限公司 Information processing apparatus and information processing method
CN105243168A (en) * 2015-11-11 2016-01-13 中国建设银行股份有限公司 Data migration method and system
CN105740367A (en) * 2016-01-27 2016-07-06 青岛海尔智能家电科技有限公司 Multi-application integration method and device based on different character sets
CN106650090A (en) * 2016-12-21 2017-05-10 深圳市安冠科技有限公司 Method for quickly generating engineering terminal table, box diagram and system diagram based on data sharing
CN106650090B (en) * 2016-12-21 2019-12-24 深圳市安冠科技有限公司 Method for quickly generating engineering terminal dial table, box diagram and system diagram based on data sharing

Similar Documents

Publication Publication Date Title
CN102567019A (en) Method for supporting various character sets during application of EXCEL plug-in unit in WEB
CN101459492A (en) Data transmission method and system, data sending terminal
CN101075910B (en) Method and device for quickly registering
KR101780905B1 (en) Method and apparatus for establishing ultra-large character library and method and apparatus for displaying character
CN103488732A (en) Generation method and device of static pages
CN101916293B (en) Introduce the method and apparatus of media information in a document
CN106227575B (en) Method for generating and analyzing text file
CN103532984A (en) Data transmission method, device and system of websocket protocol
KR101568947B1 (en) Method and system for downloading font file
CN102724122A (en) Reliable serial port transmission method and device based on hardware system
CN106452607A (en) Method and device for transmitting and resolving information
CN103605730A (en) XML (extensible markup language) compressing method and device based on flexible-length identification codes
US20130024765A1 (en) Processing rich text data for storing as legacy data records in a data storage system
CN105721402A (en) Method and apparatus for analyzing SITA message
CN105635182B (en) A kind of data compression transmission method and system
CN102904796A (en) Mailbox sharing method and mail server
CN106484661A (en) A kind of method of EBCDIC coding extension
CN101841514A (en) Mail handing method and device
CN103297471A (en) Method and device for mentioning multi-user in microblog
CN103778117B (en) A kind of method and system of information of mobile terminal load
CN102253983A (en) Method and system for identifying Chinese high-risk words
CN103092922A (en) Post-coding automatic decoding method aiming at uniform resource locator (URL) comprising special characters
CN102541903A (en) Comma separated value (CSV) to microsoft excel (XLS) format conversion mode
CN105183750B (en) Close-coupled XML resolution system
CN107037992B (en) Printing bar code method, data processing equipment and print system

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C02 Deemed withdrawal of patent application after publication (patent law 2001)
WD01 Invention patent application deemed withdrawn after publication

Application publication date: 20120711