I am using a template excel, in which there is this fixed sheet let’s say “Credit” and in this sheet, there is an existing excel table named “table1” , so I have to append data in this sheet and whenever I am doing so the data is appended but the data is no included in the table and it is important that the appended data should be in the table because it is used in many other sheets and formula are written in the table.
P.s I cant use insert row because I have to append large datatable
I have used excel scope it does add the data in excel table but The format of data is changed so its not an option
Please find the ss below
whenever I insert data after 302 till any n rows eg. till 355 the size of the table should change to =$A$1:$K$355
Please suggest a solution through vbnet or c# code or else I can manual keep the resize formula once in excel itself and thereafter it shall increase any of the solutions is welcomed but without uiautomation or short cut key.