【正文】 ............................................................................................... 5 復(fù)合文檔文件（ BIFF5BIFF8） ............................................................................. 5 工作表流、工作簿流、工作域流 ............................................................................. 6 BIFF 記錄結(jié)構(gòu) ................................................................................................................ 6 3 程序語言概述 .......................................................................................................................... 7 4 生成 EXCEL文件的方法及原理 ........................................................................................... 8 利用 OLE 技術(shù)，生成 Excel 文件 ................................................................................... 8 OLE 技術(shù)簡(jiǎn)介 ............................................................................................................. 8 應(yīng)用 OLE 的基本要求 ............................................................................................... 9 鏈接與嵌入 ................................................................................................................. 9 OLE 類、文件、項(xiàng)目 ................................................................................................. 9 VB 中的 OLE 技術(shù)和 OLE 控制 .............................................................................. 10 Excel 可編程對(duì)象模型介紹 ..................................................................................... 11 Excel 對(duì)象的接口結(jié)構(gòu) .............................................................................................. 11 VB 讀寫 Excel 表 ...................................................................................................... 12 由特定組件讀取文本文件，生成 Excel 文件 .............................................................. 13 基本理論 ................................................................................................................... 13 Cell 組件 .................................................................................................................... 13 Cell 組件功能 ............................................................................................................ 14 Cell 組件的方法、屬性和事件 ................................................................................ 15 直接讀寫 Excel 文件 ...................................................................................................... 17 BOF(文件開頭 ).......................................................................................................... 18 有關(guān)電子表格單元格的記錄數(shù)據(jù)字節(jié) ................................................................... 18 標(biāo)準(zhǔn)文件記錄順序 ................................................................................................... 19 字符串字節(jié)（ BIFF2BIFF5） ................................................................................. 20 Unicode 字符串（ BIFF8） ....................................................................................... 20 常數(shù)組 ....................................................................................................................... 21 5 程序設(shè)計(jì) ................................................................................................................................ 22 利用 OLE 技術(shù)，生成 Excel 文件方案程序設(shè)計(jì) ......................................................... 23 程序設(shè)計(jì)的基本流程 ............................................................................................... 23 用戶界面和對(duì)象屬性設(shè)置 ....................................................................................... 23 程序編碼與說明： .................................................................................................... 24 通過 Cell 組件生成 Excel 文件程序設(shè)計(jì) ...................................................................... 27 程序設(shè)計(jì)基本流程 ................................................................................................... 27 用戶界面和對(duì)象屬性設(shè)置 ....................................................................................... 29 程序編碼與說明： ................................................................................................... 29 直接讀寫 Excel 文件的程序設(shè)計(jì) .................................................................................. 30 程序設(shè)計(jì)的基本流程 ............................................................................................... 30 用戶界面和對(duì)象屬性設(shè)置 ....................................................................................... 31 程序編碼與說明： ................................................................................................... 32 6 總結(jié) ........................................................................................................................................ 36 致謝 ............................................................................................................................................ 37 參考文獻(xiàn) .................................................................................................................................... 38 1 1 緒論 研究背景 隨著科學(xué)技術(shù)的不斷發(fā)展，計(jì)算機(jī)技術(shù)在現(xiàn)代測(cè)繪科學(xué)中的應(yīng)用越來越廣泛，已經(jīng)深入到測(cè)繪理論研究和測(cè)繪生產(chǎn)的各個(gè)方面，如坐標(biāo)解算、數(shù)據(jù)處理、施工放樣、遙感影像處理、計(jì)算機(jī)輔助制圖、地理信息數(shù)據(jù)加工和管理等等。 關(guān)鍵 詞 ： OLE， VB， Cell 組件， Excel，文件格式轉(zhuǎn)換， BIFF Subject： Excel format file data analysis and measurement applications in engineering Specialty： Geodetic engineering Name: Kong Lijiang Signature： Instructor: Zhu Xuejun Signature： Abstract Excel is an application of a wide range of dataprocessing software that has a strong data processing ability and a strong ability to form processing. For our measurements, the most plicated one is the data processing, which requires the data into Excel file to deal with. We need to know how fast the data into Excel in. Each input data have to open Excel and then input to a stepbystep operation, it is cumbersome. We hope that through a simple process the data directly into Excel files so that