Well, I think you may consider using Smart Markers feature for your
task, Using smart markers, you can try to import data from your data source. You
may set IDataReader as data source, see the API:
This feature is available in later version e.g v5.1.4. We have supported IDataReader as the data source of smart marker. So, you may place smart markers in a template file for your need and can use the method i.e…, WorkbookDesigner.SetDataSource(string name,IDataReader dataReader, int rowCount) to specify IDataReader for your data source.