Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel tables and move rows
#1
Hey guys again,

so lets say we have an excel workbook with 12 worksheets. Each worksheet has two tables in it as you can see in the image below
[Image: capture-5]

Question one: Is it possible to get a row from the UNPAID table and move it to the PAID table?
Question two: If the former is possible, is it also possible to move the row from worksheet to worksheet?

This is what I have right now to just save. But I can't seem to be able to find the answer.
    writer= pd.ExcelWriter('Some.xlsx',engine='openpyxl', index=False)
    writer.book = load_workbook('Some.xlsx')
    writer.sheets=dict((ws.title,ws) for ws in writer.book.worksheets)
    reader = pd.read_excel(r'Some.xlsx',sheet_name=minas)
    print_together.insert(0,len(reader)+1)
    data = pd.DataFrame(data =print_together)
    data=data.transpose()
    data.to_excel(writer,sheet_name=minas,header=False, index = None,startrow=len(reader)+1)
    writer.save()
Reply


Messages In This Thread
Excel tables and move rows - by jdos - Jun-30-2020, 08:21 AM
RE: Excel tables and move rows - by Larz60+ - Jun-30-2020, 04:54 PM
RE: Excel tables and move rows - by jdos - Jun-30-2020, 05:31 PM
RE: Excel tables and move rows - by Larz60+ - Jun-30-2020, 06:46 PM
RE: Excel tables and move rows - by jdos - Jul-01-2020, 06:10 AM
RE: Excel tables and move rows - by Larz60+ - Jul-01-2020, 09:50 AM
RE: Excel tables and move rows - by jdos - Jul-02-2020, 05:52 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  tables in Excel MaartenRo 3 597 Jan-06-2024, 03:46 PM
Last Post: deanhystad
  How to properly format rows and columns in excel data from parsed .txt blocks jh67 7 2,014 Dec-12-2022, 08:22 PM
Last Post: jh67
  Deleting rows based on cell value in Excel azizrasul 11 2,847 Oct-19-2022, 02:38 AM
Last Post: azizrasul
  The code I have written removes the desired number of rows, but wrong rows Jdesi1983 0 1,667 Dec-08-2021, 04:42 AM
Last Post: Jdesi1983
  Slittping table into Multiple tables by rows drunkenneo 1 2,124 Oct-06-2021, 03:17 PM
Last Post: snippsat
  Pandas DataFrame combine rows by column value, where Date Rows are NULL rhat398 0 2,164 May-04-2021, 10:51 PM
Last Post: rhat398
  Indexing [::-1] to Reverse ALL 2D Array Rows, ALL 3D, 4D Array Columns & Rows Python Jeremy7 8 7,389 Mar-02-2021, 01:54 AM
Last Post: Jeremy7
  Python script to summarize excel tables, then output a composite table? i'm a total n surfer349 1 2,429 Feb-05-2021, 04:37 PM
Last Post: nilamo
  Write tables from Word (.docx) to Excel (.xlsx) using xlsxwriter jackie 1 3,272 May-27-2020, 11:47 PM
Last Post: mcmxl22
  Merging excel worksheets with balnk rows sauravksingh85 1 1,366 May-19-2020, 12:46 PM
Last Post: sauravksingh85

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020