| 基于Excel的测量数据格式转换方法 |
| |
| 引用本文： | 谯生有,邹文雄,赵立学.基于Excel的测量数据格式转换方法[J].城市勘测,2008(6):137-140. |
| |
| 作者姓名： | 谯生有 邹文雄 赵立学 |
| |
| 作者单位： | 1. 中铁一局集团第五工程有限公司,陕西,宝鸡,721006
2. 济南市历下区城市建设综合开发公司,山东,济南,250013 |
| |
| 摘 要： | 以常用办公软件Excel电子表格为工具，提出了基于Excel电子表格转换数据格式的整列变换法、行号取余筛选法、序列置换公式法，通过对SV300数据格式与CASS数据格式的相互转换，介绍了应用Excel对文本数据格式进行转换的基本步骤和方法。
|
| 关 键 词： | Excel 测量数据 格式转换 |
Survey Data Format Conversion Method Based on Excel |
| |
| Qiao ShengYou,Zou WenXiong,Zhao LiXue.Survey Data Format Conversion Method Based on Excel[J].Urban Geotechnical Investigation & Surveying,2008(6):137-140. |
| |
| Authors: | Qiao ShengYou Zou WenXiong Zhao LiXue |
| |
| Affiliation: | Qiao ShengYou1,Zou WenXiong2,Zhao LiXue2(1.The Fifth Engineering Co.,Ltd.Of China Railway First Group,Baoji 721006,China,2.Jinan Lixia Urban Construction Comprehensive Development Co.,Jinan 250013,China) |
| |
| Abstract: | Using popular office software Excel spreadsheet as a tool, the data format conversion method of whole column transformation, seeking the remainder of row number and screening, serial replacement formula based on Excel spreadsheet are brought forward, and the basic steps and means of applying Excel to convert survey text data formats are introduced through the example of data format conversion between SV300 and CASS. |
| |
| Keywords: | Excel |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
