用Python3 编写excel和txt的转换工具

前段时间为了给一个程序做语言包自动导入导出工具，发现Python做工具还是挺好用的，尤其是对各种编码的支持。

安装xlwt3和xlrd3，它们是针对Python3的版本。

将lang下的日文语言包导出到一个excel里：

点击(此处)折叠或打开

1. import os
   
2. import glob
   
3. path = os.getcwd()
   
4. files = glob.glob('../trunk/Resource/lang/ja/*.txt')
   
5. import xlwt3
   
6. 
   
7. if len(files) > 0:
   
8.     wb = xlwt3.Workbook()
   
9.     for file in files:
   
10. 
    
11.         fileName = file.split('\\')[1].split('.')[0]
    
12.         print(fileName)
    
13.         ws = wb.add_sheet(fileName)
    
14.         with open(file, encoding='utf-8') as a_file:
    
15.             line_number = 0
    
16.             for a_line in a_file:
    
17.                 a_line = a_line.rstrip()
    
18.                 mark = a_line.find("=")
    
19.                 ws.write(line_number, 0, a_line[0:mark])
    
20.                 ws.write(line_number, 1, a_line[mark+1:])
    
21.                 ws.col(0).width = 8000
    
22.                 ws.col(1).width = 40000
    
23.                 line_number += 1
    
24.             a_file.close()
    
25. 
    
26.     wb.save('langPack_ja.xls')

将sourceExcel下的excel文件导出为各txt文件：

点击(此处)折叠或打开

1. import os
   
2. import glob
   
3. import xlrd3 as xlrd
   
4. import re
   
5. 
   
6. path = os.getcwd()
   
7. files = glob.glob('sourceExcel/*')
   
8. 
   
9. for file in files:
   
10.     wb = xlrd.open_workbook(file)
    
11. 
    
12.     for sheetName in wb.sheet_names():
    
13.         txtFile = open('outputTxts/' + sheetName + '.txt', mode='w', encoding='utf-8')
    
14.         sheet = wb.sheet_by_name(sheetName)
    
15.         for rownum in range(sheet.nrows):
    
16.             v1 = sheet.cell(rownum, 0).value
    
17.             if (type(v1) == float):
    
18.                 v1 = str(v1)
    
19.                 v1 = re.sub('\.0*$', "", v1)
    
20.             v1 = v1.rstrip()
    
21.             v2 = sheet.cell(rownum, 1).value
    
22.             if (type(v2) == float):
    
23.                 v2 = str(v2)
    
24.                 v2 = re.sub('\.0*$', "", v2)
    
25.             v2 = v2.rstrip()
    
26.             dataStr = v1 + '=' + v2 + '\n'
    
27.             txtFile.write(dataStr)
    
28.         txtFile.close()

http://blog.chinaunix.net/uid-20593721-id-3228789.html