Python Forum
comparison of two xlsx files
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
comparison of two xlsx files
#5
(Sep-10-2021, 08:51 AM)Larz60+ Wrote: you don't need package xlsxwriter as openpyxl van both read and write.

your goal is unclear to me, and code is difficult to follow.
Please show step by step the goal, and give me a few hours to respond.

Sorry for the long answer. The goal of my program is to create a third xlsx file with products and prices. In first xlsx file I have list of products that I need to buy. In second xlsx file I have list of all products of shop with prices. I need to automate search process because it take a lot of time to find products by ctrl+f in xlsx file.

Do you need that I describe my code more accurately? If my problem can still be solved))))

When I use search with 1 repetition, program find a lot of unnecessary lines. The problem is that when the number of repetitions is increased, it does not work correctly.
Reply


Messages In This Thread
comparison of two xlsx files - by Jlyk - Sep-07-2021, 09:55 AM
RE: comparison of two xlsx files - by Larz60+ - Sep-07-2021, 11:27 AM
RE: comparison of two xlsx files - by Jlyk - Sep-07-2021, 01:52 PM
RE: comparison of two xlsx files - by Larz60+ - Sep-10-2021, 08:51 AM
RE: comparison of two xlsx files - by Jlyk - Sep-20-2021, 07:13 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  .py pandas matplotlib .xlsx files QubeStory 1 823 Mar-23-2023, 09:38 AM
Last Post: buran
  Extracting information from .xlsx files hobbyist 0 1,623 Jan-06-2021, 07:20 PM
Last Post: hobbyist
  How can I speed up my openpyxl program reading Excel .xlsx files? deac33 0 3,433 May-04-2020, 08:02 PM
Last Post: deac33
  How to access all xlsx files in all subdirectories? Krszt 2 5,476 Mar-19-2019, 11:00 AM
Last Post: DeaD_EyE
  reading .xls files and saving as .xlsx jon0852 1 6,926 Oct-17-2017, 08:32 PM
Last Post: buran
  Looping .xlsx files in folder/subfolders copy pasting currentregion HarrisQ 4 5,599 Apr-17-2017, 06:35 AM
Last Post: HarrisQ

Forum Jump:

User Panel Messages

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