Skip to content

Instantly share code, notes, and snippets.

@dangtrinhnt
Created September 26, 2014 08:03
Show Gist options
  • Select an option

  • Save dangtrinhnt/c72437f625bbb3fc3c60 to your computer and use it in GitHub Desktop.

Select an option

Save dangtrinhnt/c72437f625bbb3fc3c60 to your computer and use it in GitHub Desktop.
Convert csv to excel
import os
import glob
import csv
import sys
from xlsxwriter.workbook import Workbook
import xlwt
def csv_to_excelX(csv_path):
workbook = Workbook(csv_path + '.xls')
worksheet = workbook.add_worksheet()
with open(csv_path, 'rb') as f:
reader = csv.reader(f)
for r, row in enumerate(reader):
for c, col in enumerate(row):
worksheet.write(r, c, col)
workbook.close()
def csv_to_excel(csv_path):
wb = xlwt.Workbook()
ws = wb.add_sheet('data')
with open(csv_path, 'rb') as f:
reader = csv.reader(f)
for r, row in enumerate(reader):
for c, val in enumerate(row):
ws.write(r, c, val)
wb.save(csv_path + '.xls')
if __name__ == "__main__":
csv_path = sys.argv[1]
csv_to_excel(csv_path)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment