Python Forum
How to copy work sheet data one workbook to other?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to copy work sheet data one workbook to other?
#1
I have a use case, in which I need to merge data from 100s of workbook to one major work book.
For this I need to copy the data from one worksheet of a workbook to the major workbook. How can I do that using the most efficient method, since the workbook will be having huge data.
Reply


Messages In This Thread
How to copy work sheet data one workbook to other? - by sayyedkamran - Oct-31-2023, 05:08 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Why is the copy method name in python list copy and not `__copy__`? YouHoGeon 2 334 Apr-04-2024, 01:18 AM
Last Post: YouHoGeon
  xlwings error when reading a workbook Mishal0488 1 1,176 Aug-01-2023, 02:05 AM
Last Post: deanhystad
  Copy data from Excel and paste into Discord (Midjourney) Joe_Wright 4 2,198 Jun-06-2023, 05:49 PM
Last Post: rajeshgk
  Help in opening and editing an excel workbook from a web-browser test 4 1,507 Aug-10-2022, 02:31 PM
Last Post: test
  Add a new column when I extract each sheet in an Excel workbook as a new csv file shantanu97 0 2,274 Mar-24-2021, 04:56 AM
Last Post: shantanu97
  how to work with SendGrid data aayushi98 0 1,333 Jan-26-2021, 10:31 AM
Last Post: aayushi98
  How to Copy Single Value From One Excel Sheet to Another SunWers 4 4,453 Dec-29-2020, 05:39 PM
Last Post: SunWers
  [split] openpyxl workbook module not callable yosoyebj 1 2,830 Sep-14-2020, 10:18 AM
Last Post: buran
  Facing issue while saving workbook Abhisht 3 5,683 Aug-19-2020, 11:44 AM
Last Post: Larz60+
  Copy certain cells into new workbook certain cells Kristenl2784 4 2,530 Jul-14-2020, 07:59 PM
Last Post: Kristenl2784

Forum Jump:

User Panel Messages

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