Charge Compensation Mechanism of Lithium-Excess Metal Oxides with Different Covalent and Ionic Characters Revealed by Operando Soft and Hard X-ray Absorption Spectroscopy