vendredi 7 avril 2023

I have an enormous Excel file with hundreds of checkboxes - what can I do?

One of our former colleagues created a big Excel with many items and multiple checkboxes (kind of a checklist), one for each item, even some of them have multiple checkboxes, grouped visually with merging cells, formats etc. but nothing standard.

The issue comes when, now, we need to manipulate that file, we need to delete some tables, because we need to adapt that Excel and share it with other employees that do not need to know the other part of the document, but this would be done dynamically, let's say that the document that we already have it's the base and from that one many will be derived each of one with a slightly different content.

The issue comes when we try to manipulate that file, there is no way to keep that checkboxes working outside that document. We have tried using openpyxl with Python we manage to copy everything except for the checkboxes, we have tried exporting the file to html and managing and editing that file, but the checkboxes are exported as images and obviously not working.

We run out of ideas and we do not know which approach would let us do what we are looking for.

I would like to point that redoing the file would not be an option, we are talking about thousands of items and that would be too time consuming. We know that doing this as an Excel have been a mistake but now it is too late to change it :_)

Thank you for your time and help, really appreciate it.




Aucun commentaire:

Enregistrer un commentaire