def eachlineof(filename):
''' éè¡è¯»åç»å®çææ¬æ件ï¼è¿åè¡å·ãåé¤æ«å°¾ç©ºå符çè¡å
容 '''
with open(filename) as handle:
for lno, line in enumerate(handle):
yield lno+1, line.strip()
å¦å¤: 读åexceléè¦ç¬¬ä¸æ¹ç±»åºï¼å¯ä»¥èèä¸è½½å®è£
xlrd, xlwt
åexcel表
åexcel表è¦ç¨å°xlwt模åï¼å®ç½ä¸è½½ï¼
http://pypi.python.org/pypi/xlwtï¼ã大è´ä½¿ç¨æµç¨å¦ä¸ï¼
1ã导å
¥æ¨¡å
å¤å¶ä»£ç 代ç å¦ä¸:
import xlwt
2ãå建workbookï¼å
¶å®å°±æ¯excelï¼åæ¥ä¿åä¸ä¸å°±è¡ï¼
å¤å¶ä»£ç 代ç å¦ä¸:
workbook = xlwt.Workbook(encoding = 'ascii')
3ãå建表
å¤å¶ä»£ç 代ç å¦ä¸:
worksheet = workbook.add_sheet('My Worksheet')
4ãå¾åå
æ ¼å
åå
¥å
容
å¤å¶ä»£ç 代ç å¦ä¸:
worksheet.write(0, 0, label = 'Row 0, Column 0 Value')
5ãä¿å
å¤å¶ä»£ç 代ç å¦ä¸:
workbook.save('Excel_Workbook.xls')
ç±äºæçéæ±æ¯è¾ç®åï¼æ以è¿ä¸é¢æ²¡éå°ä»ä¹é®é¢ï¼å¯ä¸çå°±æ¯å»ºè®®è¿æ¯ç¨asciiç¼ç ï¼ä¸ç¶å¯è½ä¼æä¸äºè¯¡å¼çç°è±¡ã
å½ç¶xlwtåè½è¿è¿ä¸æ¢è¿äºï¼ä»çè³å¯ä»¥è®¾ç½®åç§æ ·å¼ä¹ç±»çãéä¸ä¸ç¹ä¾å
å¤å¶ä»£ç 代ç å¦ä¸:
Examples Generating Excel Documents Using Python's xlwt
Here are some simple examples using Python's xlwt library to dynamically generate Excel documents.
Please note a useful alternative may be ezodf, which allows you to generate ODS (Open Document Spreadsheet) files for LibreOffi