Exporting to Excel - Table (keep formatting in place)

Please post entire screen

I think this list covers all possible options for working with tables

• Create new file
• Add data to the exiting file

If table exits

• Delete table and create new one at the same location
• Delete table and create new one at the following cell
• Clear table data
• Do Nothing

Add data starting from

•   the first row
•   the following cell
•   after last row

 Hide create header. 
The header will be always created for new tables anyway so there is no need for it 

One of the core purposes of adding to tables was to preserve all the existing styles and colour schemes including ability to have hidden columns. See my example below 
 

Deleting tables and recreating might beat the above purpose as the table will be created again but completely blank, which is as good as ignoring tables. 

With the assumption that table must exists aka HEADERS AND 1 blank row MINIMUM, so first assumption is File exists , table exists. AKA Template Exists

1.Clear table data - so clear everything but headers 
2. Do Nothing 

Add Data from 

•   the first row - So First Row after headers , it assumes that data table is empty like above screenshot otherwise if user has not chosen Clear Table data, will this mean you will overwrite data ??
•   the following cell - I don't know how you will figure this out , table location could be anywhere on the sheet
•   after last row - Yes , technically we will be appending the table

--
If you are to create new file and delete tables (either on same location or other) - User need to understand that 
1. Your table will have blank styling (styling is a whole different can of worms, far easier to have a template)

Yes that does make sense, I think we are overengineering it. 

Overengineering is underated  

Overengineering is under rated