I would like to know if it is possible to copy a table from Excel with the configurations to Latex.
I use Microsoft Excel 2016 for Max OS X.
I think you are looking for a macro something like this Excel to Latex
But, please also see the following known issues ...
KNOWN ISSUES ~~~~~~~~~~~~ Office Mac: "Copy to clipboard" appends extra null (\0) characters. Office Mac: Performance is worse than in Windows, converting large ranges might take minutes or hours. Office Mac: The functionality is accessible only through the "Format" menu. Office Mac: The dialog is modal (Windows: modeless). All: Color not (yet) supported.
However, I am using the same, without any problem (but with an older version). Just copy the latex table and don't use "Copy to clipboard".
Just use this .xla file in your excel sheet, go to format option in excel and chose to convert table to latex.