Sure.

In the Excel connection manager, change HDR=YES to HDR=NO. This means that the Exel file won't have a header row, so you read the first line as normal data. Use a conditional split to keep only the first line and discard everything else and then write the data to your dimension.