import csv
from openpyxl import Workbook
from openpyxl.cell import get_column_letter

def ConvertCSVToXLS(CSVFile, XLSFile):
    f = open(CSVFile)
    
    csv.register_dialect('colons', delimiter=',', lineterminator = "\n", quoting=csv.QUOTE_NONE)
    
    reader = csv.reader(f, dialect='colons')
    
    wb = Workbook(encoding='cp1251')
    dest_filename = XLSFile
    
    ws = wb.worksheets[0]
    ws.title = "Title"

    
    for row_index, row in enumerate(reader):
        for column_index, cell in enumerate(row):
            column_letter = get_column_letter((column_index + 1))
	    if column_index == 16:
		ws.cell('%s%s'%(column_letter, (row_index + 1))).set_value_explicit(cell, 's')
	    else:
            	ws.cell('%s%s'%(column_letter, (row_index + 1))).value = cell

    ws.column_dimensions[get_column_letter(16)].width = 16
    ws.column_dimensions[get_column_letter(6)].width = 18
    ws.column_dimensions[get_column_letter(7)].width = 18
    ws.column_dimensions[get_column_letter(8)].width = 18
    ws.column_dimensions[get_column_letter(9)].width = 18
    wb.save(filename = dest_filename)