Excitation spectrum of vortex lattices in rotating Bose-Einstein condensates