We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

ExceL sheet mail merge with Database fields

Hi , I have an ms excel template and it contains some dynamic fields that I have to merge with database table.
So using aspose how can we implement that.

For Ms word we used=> Aspose.Words.Document.MailMerge.Execute(Dataset)

For Ms excel what to used?



Thanks for your query.

Well, I think you may make use of Smart Markers feature provided by Aspose.Cells product. Smart markers behaves like pointers and you will insert them into your template file first, extract data from your data source (database) to fill a DataSet/DataTable using your own code via e.g., ADO.NET etc. or even use variables / arrays, objects etc. For the purpose, set markers’ datasource for the WorkbookDesigner object and finally process it and you will see the data is extracted/replaced or merged for the markers i.e…, data is displayed in the cells (in the worksheet) against your inserted markers.

Please see the topic for your complete reference for your needs:

Hope, this helps a bit.

Thank you.