OiO.lk Community platform!

Oio.lk is an excellent forum for developers, providing a wide range of resources, discussions, and support for those in the developer community. Join oio.lk today to connect with like-minded professionals, share insights, and stay updated on the latest trends and technologies in the development field.
  You need to log in or register to access the solved answers to this problem.
  • You have reached the maximum number of guest views allowed
  • Please register below to remove this limitation

How to copy over an Excel sheet to another workbook in Python

  • Thread starter Thread starter KaliMa
  • Start date Start date
K

KaliMa

Guest
I have a string with a sourcefile path and another string with a destfile path, both pointing to Excel workbooks.

I want to take the first sheet of the sourcefile and copy it as a new tab to the destfile (doesn't matter where in the destfile), then save it.

Couldn't find an easy way in xlrd or xlwt or xlutils to do this. Am I missing something?
<p>I have a string with a sourcefile path and another string with a destfile path, both pointing to Excel workbooks.</p>

<p>I want to take the first sheet of the sourcefile and copy it as a new tab to the destfile (doesn't matter where in the destfile), then save it.</p>

<p>Couldn't find an easy way in <code>xlrd</code> or <code>xlwt</code> or <code>xlutils</code> to do this. Am I missing something?</p>
 
Top