But who is writing the widget? If it's a programmer, then why is he using this tool when most of this stuff is one liners in code anyway? And if it's a non-programmer, he now can't do something that he may have still been able to do in excel.

A non-developer who has access to developers. A developer can be paid to write the widget, which would likely be cheaper, easier, and faster than paying a developer for every minor change. It really depends on context. In a larger organization, for example, the user might have access to plenty of developers but need to open a ticket and wait forever every time they need something.