Spectroscopic Fingerprint of Electronic Excitations in Nanoporous Frameworks and Transition Metal Complexes