Stephen Chung

Results 546 comments of Stephen Chung

I would start by finding out why it is so large in the first place. You most likely duplicated formatting styles over all 17000+ rows. Maybe you should just make...

[Vendor_Details.xlsx](https://github.com/user-attachments/files/17320258/Vendor_Details.xlsx) Try this one instead.

> All the blank rows are gone now. Please share the steps to do this for any other files in future. Simple. Select all the blank columns up to the...

> Thanks for the update. I am aware of manual steps to remove blank rows. Is there any way programmatically remove them? There is API to delete rows and columns...

> I mean, i need a way to remove/delete all empty rows for given input file programmatically with rust. I believe you can loop through the Excel sheet data structures...

I would like everybody to try out my PR on: https://github.com/MathNya/umya-spreadsheet/pull/242 Let me know if memory requirements drop.

How do you know your memory is not released? Sometimes processes do not release memory back to the OS for a while and this may be the reason. If the...

> Thanks for the quick response. I am monitoring memory using process id, for every run, consumed memory is not being released. Can you please help me to fix the...

> I observed even after couple of hours memory is not released. The only point I can say is try to stress the system to see if the OS reclaims...

But I do see a number of `drop` calls... Why do you need them? I have never need to call `drop` myself... Rust usually cleans up itself.