You can't read your Excel table into a dataframe keeping format, a dataframe is an object in memory, not a visual representation of your data. Although, you can replicate the format while rendering the content of a dataframe into a table, there are several packages that allow you to format tables, if you need specific help, please provide a minimal REPRoducible EXample (reprex)