Menu

📰
0

I have messy excel sheets, there is cell merging and then in cell images and floating images, I want to clean it.

Reddit r/learnpython·u/virtualshivam·about 1 month ago
#wSHe8csC
Reading 0:00
15s threshold

I have messy excel sheets, there is cell merging and then in cell images and floating images, I want to clean it. Hi, I have excel sheets of the store keeper, and it is very messy. He has like 48 excel sheets in total and they all are messy. I want to be able to upload them on google sheets, but as they are quite big like 500 MB's. So google doesn't opens them. So, what I have thought is that First I will un-merge all the cells manually for each excel sheet. Then there will be some script, which will extract all the images, if they are in cell images then it will just return the row and col no and if they are floating images then it should return the coodinates so that I can calculate it's row and column using some algorithim. And then I will upload these images to S3 and create a csv with the image link and other headers data and then will give it to a human and he can highlight all the empty cells and then can manually fill it. I just want to minimise the errors.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.

Read More