I faced a critical problem, here are my requirements:
- I have a Dataset which contains all the required data coming from Database.
- It can contain dynamic row and dynamic column.
- Insert the dataset in the excel file.
- Format the data using Excel 2007 predefined table format styles ,like the following screenshot
image.png (2.2 KB)
- This things will go into a template file (.XLSX), which does not contain any Formula or Predefined table.
Can we actually do that ? Please help me out.