We have had difficulty working with Excel sheets exported from monday.
I finally put together a set of table-driven macros for Excel that can perform the following functions:
- Remove Branding, Add a Logo
- Change Fonts
- Set Number Format, Fix Dates
- Delete Columns
- Set Alignments, Column Widths, Row Heights, Wrap Text
I’m looking to see if there is any interest in the community. It’s been an interesting project and I might considering putting in more.
If you are interested and trying what I have so far, let me know a little bit of what you are looking for and I’ll give a few out.