Export to Excel - fixing formatting, branding and other issues

Miscellaneous
,
#1

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.

4 Likes
#2

I would be interested in this. Can you give more info about it?

#3

@CAllen, basically, you set up the commands that you want to run for each particular board. You can also have commands that run on all boards. Once the set is done it can be edited but does not need to be touched again.

When a board is exported and opened in Excel, you click one button to run the commands. It’s working very well for us. At this point, I’m just looking for feedback on how other companies like it and what else they would like it to do.

I’ll try and put together a video to show how it works in the next couple of day.

3 Likes
#4

Loving this. I’ll be waiting for that video!

#5

Love this idea as I have most of the same issues as you mentioned.

#6

@Adrian, @Emil, @CAllen,

Okay, sorry it took me so long, I got sidetracked a bit by work…

Here are a couple of quick videos showing the processor.


3 Likes
#7

@JCorrell I am definitely interested in this! How can I set this up/edit the commands? I am not super familiar with creating stuff like this in excel but the commands you had looked simple enough to follow and edit for what I need.

#8

@CWaxman, direct message me with your email address and I’ll send you the files.

#9

Wow! Can’t wait to try it out. I’ll dm you.

#10

I was unable to try this out due to our internal restrictions with Excel macros. :frowning_face:

I’m not really very technical. But, is there any way to get the macros “signed”?