I am writing a program which compares many excelsheets (up to 500) with each other. To each of these tables a new one is to be created which can contain data from several of the read in tables.
I need help to initialize the array.Maybe I can better use a list. I have not worked with that yet.
The number of tables to read in is variable. The tables all have a fixed header but a variable number of entries.
the new datatable within the array/list would then be extended with the command merge datatable
i hope that i have described a problem in an understandable way