I have obtained a cursor (data recordset) from sql server using pypyodbc. I have xlwings library and have spawned a workbook. I can simply loop through each row of the cursor and write the fields of the records one by one to excel cells... I want to know if there is a better/faster way of getting this data onto the excel sheet.
With the immense number of python libraries and function I thought that there would be a better way to get data from the cursor to the excel sheet rather than loop cell by cell.
Any advice much appreciated.
Thanks.
I have tried looping for each row and for each column. Is there a better wa?