Hi team,
im trying to write some content to excel using ADO connection.
can any one help me in achieving the same.
im using Python and below is the sample code where i m trying to write the content to excel.
def writeDataToExcel():
strSheet = 'over'
filepath = r'C:\Users\sathishkumark\Desktop\Test.xlsx'
ConnectionString = 'Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ='+filepath+';ReadOnly=0;Extended Properties=Excel 12.0 Macro;HDR=YES;'
objExcel = ADO.CreateConnection()
objExcel.ConnectionString = ConnectionString
objExcel.Open()
objRS = ADO.CreateRecordset()
strQuery = "update ["+strSheet+"$] set col1 = 'sda';"
objRS.Open (strQuery, objExcel, 3, 3)
objExcel.Close()
objExcel.Close()
Kind Regards,
Sathish Kumar K
