200821877 九、·發明說明·· 【發明所屬之技術領域】 本發明涉及一種數據轉換系統及方法。 【先前技術】 在數據處理軟體發展中，最困難的是快速準確的獲取 準格據，以及將其轉化爲軟體發展過程中所需的標 據表原:客戶原始數_中的數 於特定)據透過軟體程式讀取，存放 、、七式檔案或者糸統中。 =往軟體設計者僅提供—些面 本:底夂層數據轉換方法與介面： 底層數據轉換二门::式碼的原據時，要重新編寫大量 取，這樣不僅择女 ‘子數據檔案逐條進行數據讀 容易產生軟體=伐寫軟體的整體規模與卫作量，同時 【發明内容】 鑒於上述内容，有必 元’-個參數设定/二個二據轉換模組包建立單 其中:該數據轉換模組包建立單單元’ -個數據轉換模叙包;:數據存儲方法封裝爲 >數3又疋早凡設定進行數據檔案格 6 ZUU6Z16// 式轉換所需的參數，該夫 據槽案中有效數據的選括肩始數據播案位址，該數 換後所生成的數據檔案的’數據槽案的轉換方式及轉 建立的數據轉換模組包，將位址；調用單元調用上述所 據轉換模組包；執行單元利，所設定的參數傳送至該數 換模組包中的各種方法，自 傳送的參數執行該數據轉 數據的筛選及轉存轉換後的數ς成原始數據的讀取、有欸 本發月還提供一種數據轉換 據的批量存取與存館格式…’以實現不同格式數 該數據轉換方法包括步驟:將 法，數據讀取方法，數據：各，式槽案的定位方 一個數據轉換模組包；設定進行翁=據存儲方法封裝爲 數，該參數包括原始數據槽案 §案袼式轉換所需參 據的選取範圍，數據播案的轉換方:該數據槽案中有效數 據播案的存取位址；調用上、J及轉換後所生成的數 將所設定的參數傳遞至 _ ^數據轉換模組包， 傳送的參數執行該數據轉換模組包中用ΐ:所 理細上::若干種不同數據格式繁項的底層數據處 ^ ” ^"、爲一個整體的數據處理模組，以方便快捷 、^丁、、充&數據存取與格式轉換，避免大量底層細節處 理厂馬的、扁寫’ 1能縮減軟體發展的規模與工作量及降低 了軟體缺陷産生的機率。 、 【實施方式】 200821877 _參閱圖1所示，是本發明數據轉換系統較佳實施例的 應用環境圖。該應用環境由一個基本的電腦系統組成。該 電腦系統包括中央處理器11，記憶體13，輸入設備14，輸 出設備15。其中該中央處理器11由運算器和控制器組成， 是電腦的控制中心，提供了運算、判斷等處理能力。 記憶體13是電腦中用來存放程式和數據（包括文字、 圖像、聲音等）的記憶裝置。程式和數據是兩種不同的資 訊，應放在不同的地方。記憶體13分爲内部記憶體和外部 記憶體兩大類。其中，内部記憶體指ROM、RAM，特點是 隨機存取，速度快，容量小；外部記憶體指磁片、光碟、 隨身碟，特點是順序存取/塊存取，速度慢，容量大。外部 記憶體作爲一種輔助存儲設備，主要用來存放一些暫時不 用而又需要長期保存的程式和數據。當需要執行外部記憶 體中的程式或處理外部記憶體中的數據時，必須透過中央 處理器11輸入/輸出指令，將其調入RAM中才能被中央處 、 理器11執行處理，所以外部記憶體實際上屬於輸入/輸出 設備。在本發明中，所需轉換格式的數據檔案存儲在外部 記憶體中，進行格式轉換後所生成的暫存檔案也可以存放 在外部記憶體中。 輸入設備14是用來輸入程式和數據的部件。常見的輸 入設備有：鍵盤、滑鼠、麥克風、掃描器、手寫板、數位 相機、攝影機等。 輸出設備15是用來輸出結果的部件。要求輸出設備能 以人們所能接受的形式輸出資訊，如以文字、圖形的形式 8 200821877 在顯.示器上輸出。除顯示器外，常用的輸出設備還有音箱、 印表機；、繪圖儀等。磁碟機、磁帶機等存儲設備既是輸入 設備，又是輸出設備。 在本發明的較佳實施例中，該數據轉換系統2可存儲 在電腦的外部記憶體中，當需要進行數據轉換時，由中央 處理器11透過輸入/輸出指令，將該數據轉換系統2及需轉 換的數據檔案調入RAM中執行處理，進行數據檔案格式的 轉換。 在本發明的其他實施例中，該數據轉換系統2還可以 存儲在移動磁片中，透過内部網路或網際網路將該數據轉 換系統2傳輸到一台電腦中，由該電腦的中央處理器11透過 輸入/輸出指令將其調入RAM中執行，進行數據檔案格式的 轉換。 參閱圖2所示，是本發明數據轉換系統的功能模組 圖。該數據轉換系統2包括一個數據轉換模組包建立單元 , 20，一個參數設定單元22，一個調用單元24及一個執行單 元26。 其中，該數據轉換模組包建立單元20將檔案定位方 法、數據讀取方法、數據分段方法、數據存儲方法封裝爲 一個數據轉換模組包。檔案定位方法是指各種格式數據檔 案處理中涉及到的不同的查找某種格式檔案中指定數據位 置的程式方法；數據讀取方法是指讀取某種格式檔案中指 定位置的數據的程式方法；數據分段方法是指將連續數據 透過設定分割符等方式進行數據篩選的程式方法；數據存 9 200821877 所述的槽案定位方法如：Exeem#，指定數據所在的 sheet、订、列，文本格式標案，指定從某個特殊搁位，如： <#####>開始的連續數據。 所述的數據續取方法如：讀SExcel槽案指定單元 據，讀取文字檔案指定單元數據。 α所述的數據分段方法如：對連續數據流程根據特殊符 號分段成多個數據段，該特殊符號如“I”。 所述的數據存儲方法如：將數據單元存儲於Exeel檀案 心疋位置:將數據單元存儲於文字槽案指定位置，增加相 應分割標示符號，該分割標示符號如“丨”。 所述參數设定單元22用於在進行數據檔案格式轉換 別，進行參數設定。其所設定的參數包括；所需要轉換的 原始數據位址，若原始數據存儲於檔案中，則需要設定原 始數據標案的完整存儲路徑；設定該原始數據播案中有效 數據的選取範圍，指定選取的部分數據或者全部數據，該 選取範圍如對於Excel檔案，有用的數據放在sheetl中的第5 行到第8行’對於文字檔案，有用的數據放在標杀符號 <#####>之後直到檔案未尾；設定該數據檔案的轉換方 式，指定數據從一種格式轉換爲另一種格式，例如，從Excel 槽案數據格式轉換至文字槽案數據格式，參數設爲1，文字 槽案數據格式轉換至Excel檔案數據格式，參數設爲2， Excel槽案數據格式轉換至程式陣列數據格式，參數設爲 200821877 3，程式陣列數據格式轉換至Exc 爲4,文字檑案數據格H據格式，參數設 爲5,程式陣列數據格式轉換至文據格式，參數設 爲6;設定轉換後數據的 數據格式，參數設 在記憶體巾被其絲‘ 右轉純數據不是直接 需要設定轉換後數據槽案 所述調用單元抑於調用上述所建^㈣據轉㈣ 組包，將所技的參數傳遞至該數據轉換模組&巾的各種 方法。 所述執行單元26利用所傳送的參數執行該數據轉換 相:組包中的方法’從所设定的原始數據槽案位址讀取需轉 換的Excel檔案數據，利用數據轉換模組包裏的檔案定位方 法、數據讀取方法、數據分段方法在上述Excel槽案數據中 根據所設定的有效數據的選取範圍，篩選出有效數據，再 根據該原始數據稽案的類型及所要轉換後的類型對應的表 數，利用數據轉換模組包中的數據存儲方法將該有效數據 轉換成所需要的數據格式，也即是將所篩選出的有效數據 存儲於指定格式檔案的指定位置，之後將該轉換成的暫存 檔案存放在所設定的存取位址中，以便後續程式使用。該 轉換後的數據也可以在記憶體中被其他程式直接讀取。 參閱圖3所示’是本發明數據轉換方法車父佳實施例的 流程圖。 步驟S200，在進行數據檔案轉換之前，首先要將各種 通用格式數據檔案處理中涉及到的不同的檔案定位方法、 11 200821877 數據讀取方法、數據分段方法及數據存 數據轉換模組包。 '去封骏爲一個 步驟S202 ’設定該所需進行數據槽案格 數據檔案的位址。若該原始數據存儲於槽/轉換的原始 原始數據㈣的完整存儲路徑。該縣_^需要設定 儲於電腦的硬碟中的數據檔案，也可以是存^案可以是存 設備如USB、光碟、軟碟、ΜΡ3中的數據=案於外部存儲 實施例中，假如需要將Excel檔案數據轉換成，本較佳 « 〇 、文字稽案數 步驟S204，設定該原始數據檔案中有效卷 τ 3欢數據的選取範 圍。一個原始數據檔案一般由有用數據及解釋、 子、^注性的 數據組成。在該步驟中，根據原始數據檔案的格式，叫八 原始數據檔案中的有用數據範圍和解釋、標注性數據 圍。如指定sheetl中的第5行到第8行爲有用數據範圍。 步驟S206，設定原始數據檔案的轉換方式。在本發明 較佳實施例中，將由Excel檔案數據轉換至文字檔案數據的 參數設爲1，將由文字檀案數據轉換至Excel檔案數據的參 數設爲2，將由Excel檔案數據轉換至程式陣列數據的參數 設爲3，將由程式陣列數據轉換至Excel檔案數據的參數設 爲4，將由文字檀案數據轉換至程式陣列數據的參數設爲 5，將由程式陣列數據轉換至文字檔案數據的參數設爲6。 本較佳實施例中所用到的轉換方式爲由Excel檔案數據轉 換至文字檔案數據，參數爲1 ° 步驟S208，設定轉換後的數據的存取位址。該轉換後 12 200821877 所生.成的數據檔案是一個暫存檔案。該暫存槽案可以存儲 程式所讀取。若轉換二數據不是 而是存儲於數據樓 匕貝!而要^轉換後數據槽案的完整存儲路徑，宜可以 存儲=硬碟上，還可以存儲在其他存儲設備中。- 設定的各個參數傳遞至數據轉換換拉組包，將上述所 步_，執行單元包中㈣^ 轉換模組包中的方法，從所」:::送的參數執行該數據 需轉換的趾_案數據，利數據播案位址讀取 位方法、㈣據轉換模組包裏的標案定 Μ Ψ iP it ^ I /數據分段方法在上述Excel檔案數 的有效數據的選取範圍，筛選出有效數 據2根據該原始數據槽案的類型及所㈣ 換Γ數據轉換模組包中的數據存儲方法將該有 效ff:換成所需要的數據格式，也即是將所筛選出的有 ==Γ式槽案的指定位置，之後將該轉換成 的暫存樯案存放在所設定的存取位址中，以便後續程式使 =該轉換後的數據也可以在記憶體中被其他程式直接讀 本發明雖以較佳實施例揭露如上，然其並非用 本發明。任何熟悉此項技藝者，在不脫離本發明之: 範圍内’當可做更動與潤飾，因此本發明之保護範圍 後附之申請專利範圍所界定者為準。 田 【圖式簡單說明】 13 200821877 .圖1爲本發明數據轉換系統的較佳實施例的應用環境 圖。. 圖2爲本發明數據轉換系統的功能模組圖。 圖3爲本發明數據轉換方法較佳實施例的流程圖。 【主要元件符號說明】 中央處理器 11 記憶體 13 輸入設備 14 輸出設備 15 數據轉換系統 2 數據轉換模組包建立單元 20 參數設定单元 22 調用單元 24 執行單元 26 14200821877 IX. INTRODUCTION OF THE INVENTION · Technical Field of the Invention The present invention relates to a data conversion system and method. [Prior Art] In the development of data processing software, the most difficult is to obtain accurate and accurate data quickly and accurately, and convert it into the standard table required in the software development process: the number of customers in the original number _ is specific) According to the software program to read, store, seven files or in the system. = to the software designer only provide some of the face: the bottom layer data conversion method and interface: the underlying data conversion two:: the original code of the code, you have to rewrite a lot of fetch, so that not only the female 'child data file The data reading is easy to generate software = the overall size and the amount of software written by the software, and [invention content] In view of the above, there is a certain parameter set--two parameter conversion module package: The data conversion module package establishes a single unit '- a data conversion module package; the data storage method is packaged as > number 3 and the parameters required for the data file grid 6 ZUU6Z16// conversion are set early, the husband According to the valid data in the slot case, the data address of the data file is selected, the data file generated by the data file is converted and the data conversion module package is transferred, and the address is called; Calling the above-mentioned data conversion module package; executing the unit, the set parameters are transmitted to various methods in the number conversion module package, and the data transmission data is filtered and the converted data is converted from the transmitted parameters. Raw data The reading, the 欸 发 还 also provides a data conversion data for the bulk access and deposit library format ... 'to achieve different format number of the data conversion method including steps: method, data reading method, data: each, The positioning unit of the slot case is a data conversion module package; the setting is carried out according to the storage method, and the parameter includes the selection range of the reference data required for the conversion of the original data slot case, and the conversion party of the data broadcast case: The access address of the valid data broadcast in the data slot case; the number generated by calling the upper, J, and the conversion passes the set parameter to the _ ^ data conversion module package, and the transmitted parameter executes the data conversion module The use of the package: the details:: a number of different data formats of the underlying data ^ " ^ ", an overall data processing module, to facilitate fast, ^ D,, charge & data storage Take the format conversion, avoid a lot of low-level details processing factory, flat write '1 can reduce the scale and workload of software development and reduce the probability of software defects. [Embodiment] 200821877 _ See Figure 1, is An application environment diagram of a preferred embodiment of the data conversion system of the present invention consists of a basic computer system comprising a central processing unit 11, a memory 13, an input device 14, and an output device 15. wherein the central processing The device 11 is composed of an arithmetic unit and a controller, and is a control center of the computer, and provides processing functions such as calculation, judgment, etc. The memory 13 is a memory device for storing programs and data (including text, images, sounds, etc.) in the computer. Program and data are two different kinds of information, which should be placed in different places. Memory 13 is divided into internal memory and external memory. Among them, internal memory refers to ROM and RAM, which is characterized by random access and speed. Fast, small capacity; external memory refers to disk, CD, and flash drive, featuring sequential access/block access, slow speed, and large capacity. As an auxiliary storage device, external memory is mainly used to store programs and data that are temporarily unused and need to be stored for a long time. When it is necessary to execute a program in the external memory or process the data in the external memory, it is necessary to input/output the command through the central processing unit 11 and transfer it to the RAM to be processed by the central processing unit 11, so that the external memory The body actually belongs to the input/output device. In the present invention, the data file of the required conversion format is stored in the external memory, and the temporary file generated after the format conversion can also be stored in the external memory. Input device 14 is a component for inputting programs and data. Common input devices are: keyboard, mouse, microphone, scanner, tablet, digital camera, camera, etc. The output device 15 is a component for outputting a result. The output device is required to output information in a form acceptable to humans, such as in the form of text or graphics 8 200821877 output on the display. In addition to the display, commonly used output devices are speakers, printers; plotters. Storage devices such as disk drives and tape drives are both input devices and output devices. In a preferred embodiment of the present invention, the data conversion system 2 can be stored in an external memory of the computer. When data conversion is required, the central processing unit 11 transmits the data conversion system 2 through input/output commands. The data file to be converted is transferred to the RAM for processing, and the data file format is converted. In other embodiments of the present invention, the data conversion system 2 can also be stored in a mobile magnetic disk, and the data conversion system 2 can be transmitted to a computer through an internal network or an Internet, and processed by the central processing of the computer. The device 11 transfers it to the RAM through an input/output command to perform data file format conversion. Referring to Figure 2, it is a functional block diagram of the data conversion system of the present invention. The data conversion system 2 includes a data conversion module package establishing unit, 20, a parameter setting unit 22, a calling unit 24, and an executing unit 26. The data conversion module package establishing unit 20 encapsulates the file positioning method, the data reading method, the data segmentation method, and the data storage method into one data conversion module package. The file positioning method refers to different program methods for searching for a specified data position in a format file involved in data format processing of various formats; the data reading method refers to a program method for reading data of a specified position in a format file; The data segmentation method refers to a program method for filtering continuous data by setting a separator or the like; the data storage method described in 200821877 is as follows: Exeem#, specifying the sheet, order, column, and text format in which the data is located A standard that specifies continuous data starting from a particular position, such as: <#####>. The data renewal method is as follows: reading the SExcel slot specified unit data, and reading the text file specifying unit data. The data segmentation method described by α is such that the continuous data flow is segmented into a plurality of data segments according to special symbols, such as "I". The data storage method is as follows: storing the data unit in the Exeel Tanchi heart position: storing the data unit in a specified position of the text slot, and adding a corresponding divided indicator symbol, such as “丨”. The parameter setting unit 22 is configured to perform parameter setting when performing data file format conversion. The parameters set include: the original data address to be converted, if the original data is stored in the file, the complete storage path of the original data standard needs to be set; the selection range of the valid data in the original data broadcast is set, and the specified Partial data or all data selected, the selection range is as for Excel file, useful data is placed in line 5 to line 8 of sheetl. For text files, useful data is placed in the markup symbol <#### #>After the file is not finished; set the conversion mode of the data file, specify the data to be converted from one format to another format, for example, from the Excel slot data format to the text slot data format, the parameter is set to 1, the text The slot data format is converted to the Excel file data format, the parameter is set to 2, the Excel slot data format is converted to the program array data format, the parameter is set to 200821877 3, the program array data format is converted to Exc 4, and the text file data is H. According to the format, the parameter is set to 5, the program array data format is converted to the document format, the parameter is set to 6; the data format of the converted data is set, The parameter is set in the memory towel by its silk 'right turn pure data is not directly need to set the converted data slot case, the call unit is called to call the above-mentioned built (4) data transfer (four) group package, the parameters of the technology are passed to the data Various methods of converting modules & towels. The execution unit 26 performs the data conversion phase using the transmitted parameters: the method in the group package reads the Excel file data to be converted from the set original data slot address, and uses the data conversion module package. The file positioning method, the data reading method, and the data segmentation method filter out valid data according to the selected range of the valid data in the Excel slot data, and then according to the type of the original data file and the type to be converted. Corresponding number of tables, using the data storage method in the data conversion module package to convert the valid data into a required data format, that is, storing the filtered valid data in a specified position of the specified format file, and then The converted temporary file is stored in the set access address for subsequent programs to use. The converted data can also be read directly by other programs in the memory. Referring to Figure 3, there is shown a flow chart of a preferred embodiment of the data conversion method of the present invention. In step S200, before performing data file conversion, firstly, different file positioning methods involved in various general format data file processing, 11 200821877 data reading method, data segmentation method, and data storage data conversion module package are required. 'Go to Feng Jun for a step S202' to set the address of the data slot file data file. If the raw data is stored in the slot/converted raw raw data (four) the full storage path. The county _^ needs to set the data file stored in the hard disk of the computer, or it can be the storage device such as USB, CD, floppy disk, ΜΡ3 data = case in the external storage embodiment, if needed The Excel file data is converted into the preferred « 〇, text number of records step S204, the selection range of the effective volume τ 3 数据 data in the original data file is set. A raw data file is generally composed of useful data and interpretation, sub-injection data. In this step, according to the format of the original data file, the useful data range and interpretation and annotation data in the eight original data files are called. For example, the 5th to 8th lines in the sheetl are useful data ranges. Step S206, setting a conversion mode of the original data file. In a preferred embodiment of the present invention, the parameter for converting the Excel file data to the text file data is set to 1, and the parameter for converting the text file data to the Excel file data is set to 2, and the Excel file data is converted to the program array data. The parameter is set to 3, the parameter for converting the program array data to the Excel file data is set to 4, the parameter for converting the text file data to the program array data is set to 5, and the parameter for converting the program array data to the text file data is set to 6 . The conversion method used in the preferred embodiment is to convert the Excel file data to the text file data, and the parameter is 1 °, step S208, to set the access address of the converted data. The data file generated after the conversion 12 200821877 is a temporary file. The scratch slot can be read by the storage program. If the conversion data is not stored in the data building, the complete storage path of the data slot should be stored on the hard disk or stored in other storage devices. - The set parameters are passed to the data conversion and change group package, and the method in the above-mentioned step _, execution unit package (4) ^ conversion module package, the parameter to be converted from the parameter sent by ":::: _ case data, profit data broadcast address read bit method, (4) according to the standard definition in the conversion module package Ψ iP it ^ I / data segmentation method in the above Excel file number of valid data selection range, sieve Selecting valid data 2 according to the type of the original data slot and (4) changing the data storage method in the data conversion module package, the effective ff: is replaced by the required data format, that is, the selected ones are = = The specified location of the slot type, and then the converted temporary file is stored in the set access address, so that the subsequent program can make the converted data directly in the memory by other programs. The invention has been described above by way of a preferred embodiment, but it is not intended to be used. Any person skilled in the art will be able to make changes and refinements without departing from the scope of the invention, and therefore the scope of the invention is defined by the scope of the appended claims. [Simplified illustration of the drawings] 13 200821877. Fig. 1 is an application environment diagram of a preferred embodiment of the data conversion system of the present invention. 2 is a functional block diagram of a data conversion system of the present invention. 3 is a flow chart of a preferred embodiment of a data conversion method of the present invention. [Description of main component symbols] CPU 11 Memory 13 Input device 14 Output device 15 Data conversion system 2 Data conversion module package creation unit 20 Parameter setting unit 22 Call unit 24 Execution unit 26 14