Question: how to copy excel sheet in gmail?
Answer: Copy from Excel, then Paste into Word, then Copy from Word and Paste into gmail. ... 
Copy as a picture from Excel, and paste into gmail. ... 
Write some VBA to loop over the cells of the source range, and build up some inline-css HTML to make the table, and then put that string onto the clipboard.