Excellon Drill File should contain drill sizes definition, either in the header or in the tool switch command.
However, sometimes a manual drill change schema is used instead. In this case, the sizes of the drills might not be present.
For example, this is the case when using Cadence Allegro default export settings.
Please change the settings - see
community.cadence.com post.