from simple_salesforce import Salesforce
import requests
import base64
import json
import sys

sf = Salesforce(username="userid"
            ,password="password"
            ,security_token="token")

#print "get sid " + str(sf.session_id)
sid = str(sf.session_id)
urlin = "https://na52.salesforce.com/" + sys.argv[1] + "?
view=d&snip&export=1&enc=UTF-8&xf=csv"

response = requests.get(urlin,
              headers = sf.headers, cookies = {'sid' : sid})

#response.contents
print response.content

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

nfilename = sys.argv[1]
print(nfilename)
nfilename2 = sys.argv[2]
print(nfilename2)

f = open(nfilename, 'r')

csv.register_dialect('commas', delimiter=',')

reader = csv.reader(f, dialect='commas')
#sys.argv[1]
wb = Workbook()
dest_filename = nfilename2

ws = wb.worksheets[0]
ws.title = "Sheet 1"

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

wb.save(filename = dest_filename)