1.
# -*- coding: utf-8 -*-import xlrdimport csvfrom os import sysdef csv_from_excel(excel_file): workbook = xlrd.open_workbook(excel_file) all_worksheets = workbook.sheet_names() for worksheet_name in all_worksheets: worksheet = workbook.sheet_by_name(worksheet_name) your_csv_file = open(''.join([worksheet_name,'.csv']), 'wb') wr = csv.writer(your_csv_file, quoting=csv.QUOTE_ALL) for rownum in xrange(worksheet.nrows): wr.writerow([unicode(entry).encode("utf-8") for entry in worksheet.row_values(rownum)]) your_csv_file.close()if __name__ == "__main__": csv_from_excel(sys.argv[1])
2. 使用pandas
import pandas as pddata_xls = pd.read_excel('your_workbook.xls', 'Sheet1', index_col=None)data_xls.to_csv('your_csv.csv', encoding='utf-8')
3. csvkit