Write data into existing excel file and making summary table
<p>I have to write some data into existing xls file.(i should say that im working on unix and couldnt use windows)<br>
I prefer work with python and have tried some libraries like xlwt, openpyxl, xlutils. </p>

<p>Its not working, cause there is some filter in my xls file. After rewriting this file filter is dissapearing. But i still need this filter.</p>

<p>Could some one tell me about options that i have.
help, please! </p>

<p>Example:</p>

<pre><code>from xlutils.copy import copy
from xlrd import open_workbook
from xlwt import easyxf
start_row=0
rb=open_workbook('file.xls')
r_sheet=rb.sheet_by_index(1)

wb=copy(rb)
w_sheet=wb.get_sheet(1)
for row_index in range(start_row, r_sheet.nrows):
    row=r_sheet.row_values(row_index)
    call_index=0
    for c_el in row:
        value=r_sheet.cell(row_index, call_index).value
        w_sheet.write(row_index, call_index, value)
        call_index+=1
wb.save('file.out.xls');
</code></pre>

<p>I also tried:
    import xlrd
    from openpyxl import Workbook
    import unicodedata</p>

<pre><code>rb=xlrd.open_workbook('file.xls')
sheet=rb.sheet_by_index(0)
wb=Workbook()
ws1=wb.create_sheet("Results", 0)

for rownum in range(sheet.nrows):
    row=sheet.row_values(rownum)
    arr=[]
    for c_el in row:
        arr.append(c_el)
    ws1.append(arr)

ws2=wb.create_sheet("Common", 1)
sheet=rb.sheet_by_index(1)

for rownum in range(sheet.nrows):
    row=sheet.row_values(rownum)
    arr=[]
    for c_el in row:
        arr.append(c_el)

    ws2.append(arr)


ws2.auto_filter.ref=["A1:A15", "B1:B15"]
#ws['A1']=42

#ws.append([1,2,3])

wb.save('sample.xls')
</code></pre>

<p>The problem is still exist. Ok, ill try to find machine running on windows, but i have to admit something else: 
There is some rows like this:</p>

<p><a href="https://i.stack.imgur.com/Zu5Jn.jpg" rel="nofollow noreferrer">enter image description here</a></p>

<p>Ive understood what i was doing wrong, but i still need help. 
First of all, i have one sheet that contains some values
Second sheet contains summary table!!!
If i try to copy this worksheet it did wrong. </p>

<p>So, the question is : how could i make summary table from first sheet?</p>