Excitement of any kind is a state of arousal. Arousal means that the heart rate increases, the sympathetic nervous system increases activity, and the brain begins to signal the increased production of hormones. When a person is excited, their emotions become more powerful and can affect their decision-making abilities.

"With excitement" describes an action. "In excitement" describes a person's mental state, though I would probably simply say that the person was excited.