I have a requirement that requires generation of an Excel document programmatically in SharePoint. I need to use an Excel template that has labels like
Name: Designation: Email:
I have a list with the same columns. I need to fetch data from this list and populate instances of the aforesaid template and save it.
Name : XYZ Designation : ABC Email : firstname.lastname@example.org
This has to be done programmatically. Any idea how I do it?