I use the code fragment below to copy data to an excel file using openpyxl.

      for i, j in enumerate(fint):
       _= ws1.cell(column=i +1, row=globdat.cycle, value=j)

   wb.save(filename = dest_filename)


after doing so I have found the code to become very slow. is there a better way of doing this ?

globdat.cycle is a count for each iteration.

'fint' is a row vector with an unknown number of entries in each iteration.

Nb- I am working with large amounts of data so only openpyxl seem to work.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.