Copying Excel while maintaining borders and font formatting

Hi All- I am trying to copy data from an excel sheet and keep the table/font format for when it is pasted into another application. When I manually ctrl-c or right click to copy the data and manually paste it, the format is staying consistent. However when I program to copy the data and go to paste, it is removing the borders and changing the font. I tried to use hotkey to cntrl-c, copy sheet, and copy selected text and all are giving me the same outcome.

Any suggestions on how to copy but retain the borders and font in excel?