Quote:
I use open XML library
Sorry, but you're wrong. You're using
EPPlus, because
OpenXml does not have built-in
LoadFromDataTable
method.
All you have to do is:
1. create Excel file (workbook)
2. loop through the
DataRows
collection of
DataTable
a) check if sheet with name corresponding to the name of Module exists:
- NO - create new one
- YES - refer to existsing one
b) find first empty cell(row)
c) insert data into that row
3. save Excel file