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

Exporting dataframe with xlwings without having a index column

  • Thread starter Thread starter PythonBestie007
  • Start date Start date
P

PythonBestie007

Guest
I have following code:

Code:
import xlwings as xw

wb = xw.Book('Test.xlsx')
sht1 = wb.sheets['Testsheet']
sht1.range('A8').value = df1

I have want to export my df1 but without column1 (index column). how do i do this?

Right now it looks like this:

Code:
Column1 A B C

What I want is this:

Code:
A B C
<p>I have following code: </p>

<pre><code>import xlwings as xw

wb = xw.Book('Test.xlsx')
sht1 = wb.sheets['Testsheet']
sht1.range('A8').value = df1
</code></pre>

<p>I have want to export my df1 but without column1 (index column). how do i do this?</p>

<p>Right now it looks like this:</p>

<pre><code>Column1 A B C
</code></pre>

<p>What I want is this:</p>

<pre><code>A B C
</code></pre>
 

Latest posts

B
Replies
0
Views
1
Blundering Ecologist
B
Top