Python Forum
Manipulating an Excel Workbook
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Manipulating an Excel Workbook
#1
Hello! I currently have an excel spreadsheet that is showing me data but I need to be able to manipulate that data, find exceptions, and suggest corrections. From what I can tell, I am not sure I can do it in excel itself. My question is, can I write a code in python that will interact with that spreadsheet in the way I need it to? I used to have a basic understanding of python but have since gotten rusty. Is it worth re-learning python to be able to manipulate my spreadsheet? Any suggestions or help is appreciated! Thank you!
Reply


Messages In This Thread
Manipulating an Excel Workbook - by Stanimal - Jan-18-2019, 06:49 PM
RE: Manipulating an Excel Workbook - by Larz60+ - Jan-18-2019, 07:27 PM
RE: Manipulating an Excel Workbook - by Stanimal - Jan-18-2019, 08:04 PM
RE: Manipulating an Excel Workbook - by Larz60+ - Jan-18-2019, 10:51 PM
RE: Manipulating an Excel Workbook - by Stanimal - Jan-18-2019, 11:03 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How to copy work sheet data one workbook to other? sayyedkamran 2 733 Nov-03-2023, 09:10 AM
Last Post: Larz60+
  xlwings error when reading a workbook Mishal0488 1 1,163 Aug-01-2023, 02:05 AM
Last Post: deanhystad
  Help in opening and editing an excel workbook from a web-browser test 4 1,496 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,268 Mar-24-2021, 04:56 AM
Last Post: shantanu97
  [split] openpyxl workbook module not callable yosoyebj 1 2,820 Sep-14-2020, 10:18 AM
Last Post: buran
  Facing issue while saving workbook Abhisht 3 5,664 Aug-19-2020, 11:44 AM
Last Post: Larz60+
  Manipulating data from a CSV EvanS1 5 2,772 Jun-12-2020, 05:59 PM
Last Post: perfringo
  Saving Excel workbook file with dataframe names Biplab1985 0 2,054 Jun-07-2020, 12:25 PM
Last Post: Biplab1985
  manipulating two lists rancans 8 3,294 Apr-16-2020, 06:00 PM
Last Post: deanhystad
  Need to identify sheet color in excel workbook chewy1418 2 2,570 Feb-14-2020, 03:26 PM
Last Post: chewy1418

Forum Jump:

User Panel Messages

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