|
|||||
|
|
| 用Python语言跨平台分析处理电子表格 | |
| 引用本文： | 何惠英,王兆合,王小宇,纪蕾.用Python语言跨平台分析处理电子表格[J].电子设计工程,2011,19(9):67-70. |
| 作者姓名： | 何惠英 王兆合 王小宇 纪蕾 |
| 作者单位： | 1. 军事交通学院,天津,300161 2. 南京合荣欣业信息技术有限公司,江苏,南京,211100 3. 天津市电力公司东丽供电分公司,天津,300000 4. 天津市电力公司城东供电分公司,天津,300000 |
| 摘 要： | 在日常工作中经常需要分析和处理电子表格,这就容易涉及很多重复性的工作。有时还要求软件能在不同操作系统下使用。鉴于此背景,基于降低手工处理复杂电子表格重复性操作强度,且不用更改代码便可以在不同操作系统(Windows、Linux、MAC等等)上运行的目的,采用目前流行的动态语言Python编程的方式实现了电子表格的处理任务。通过实际分析几十万条客服工单电子表格,得出了通过编写程序可以大幅度降低人工操作强度,减少工作时间,且能跨平台使用的结论。 |
| 关 键 词： | Python 电子表格 跨平台 脚本编程 |
Analyzing and processing worksheet on multi-platform based on Python |
|
| HE Hui-ying,WANG Zhao-he,WANG Xiao-yu,JI Lei.Analyzing and processing worksheet on multi-platform based on Python[J].Electronic Design Engineering,2011,19(9):67-70. | |
| Authors: | HE Hui-ying WANG Zhao-he WANG Xiao-yu JI Lei |
| Affiliation: | 1.Academy of Military Transportation,Tianjin 300161,China; 2.Nanjing Hiaward Technology Co.Ltd,Nanjing 211100,China; 3.Tianjin Electricity Company DongLi Power Supply Subsidiary,Tianjin 300000,China; 4.Tianjin Electricity Company Chengdong Power Supply Subsidiary,Tianjin 300000,China) |
| Abstract: | That is often needed analyzing and processing worksheets in daily work,so it is easy to involve much repetitive works.Sometimes it is also required that the software can be used in different operating systems.In view of this background,this paper based on lowering repeatability operating intensity of manual processing complex worksheets,and running in different operating system(Windows,Linux,MAC,etc.) without changing its codes,adopts popular dynamic programe languages Python to realize the worksheets processing tasks.Through the practical analysis about hundred thousand customer service worksheets,it is concluded that using the program described can lower operating intensity,reduce working hours,and can be used in different platforms. |
| Keywords: | |
| 本文献已被 CNKI 万方数据 等数据库收录！ | |