I have a datatable which i need to split into multiple data tables using empty row as seperator
it is calculating the row indexes for the blank rows and is slicing the datablocks with the help of skip() and Take() method.
Let us know your feedback
can we take each splitted table’s first row as header?
the splitted datatable already should have same column headers as the datatable from it was split.
Just check it within a debug run, setting a breakpoint inspect it within, locals, watch or immediate panel
actually my input scenario is given in excel sheet i need to read them as different tables. there rows dynamically changes depending on the input. columns varies from table to table.
Can we do this type of problem
was not provided in your requirement description. Here was only mentioned that it is to split on empty rows.
In such case
- we do write a correction run, will use first line for header name reseting/adoptions
- we do the slicing on a different strategy and try to calculate the different excel ranges for readin
splitting is limited in input sheet is it possible ?
To read them from excel to different tables using empty row as seperator??
If possible can you please suggest me a way out