[Solved] Connecting data in python to spreadsheets

by


Are you trying to write your dictionary in a Excel Spreadsheet?
In this case, you could use win32com library:

 import win32com.client
 xlApp = win32com.client.DispatchEx('Excel.Application')
 xlApp.Visible = 0
 xlBook = xlApp.Workbooks.Open(my_filename)
 sht = xlBook.Worksheets(my_sheet)
 row = 1
 for element in dict.keys():
     sht.Cells(row, 1).Value = element
     sht.Cells(row, 2).Value = dict[element]
     row += 1
 xlBook.Save()
 xlBook.Close()

Note that this code will work just if the workbook already exists.
Otherwise:

 import win32com.client
 xlApp = win32com.client.DispatchEx('Excel.Application')
 xlApp.Visible = 0
 xlBook = xlApp.Workbooks.Add()
 sht = xlBook.Worksheets(my_sheet)
 row = 1
 for element in dict.keys():
     sht.Cells(row, 1).Value = element
     sht.Cells(row, 2).Value = dict[element]
     row += 1
 xlBook.SaveAs(mw_filename)
 xlBook.Close()

I hope it will be the right answer to your question.

2

solved Connecting data in python to spreadsheets