Feb-25-2024, 12:23 PM
I'm sure there are a lot of people here who would like to help you, including me, but you really need to give us something to work with.
I don't want to guess what you have, where and how to get it, that makes it difficult to try things and difficult to help you.
People here have said they have 20GB Excel files to operate on! You don't need to post 20GB, even if you could!
You do not need to post 40000 rows, just enough for people to get a good idea of what you have. 100 rows is probably enough.
Help people to help you!
In openpyxl you just loop through the rows and columns searching for whatever it is you want and putting that data somewhere else. It's not rocket science!
I don't want to guess what you have, where and how to get it, that makes it difficult to try things and difficult to help you.
People here have said they have 20GB Excel files to operate on! You don't need to post 20GB, even if you could!
You do not need to post 40000 rows, just enough for people to get a good idea of what you have. 100 rows is probably enough.
Help people to help you!
In openpyxl you just loop through the rows and columns searching for whatever it is you want and putting that data somewhere else. It's not rocket science!