how to I copy a range of cells to a new range? using the ExcelWorkbook object.
Hello,
Thank you for posting in our community.
My suggestion is to take a look at the Populating a Worksheet from a DataSet help topic in order to achieve your requirement. It will show you how to create a DataSet from database tables and then how to copy the data from that DataSet to a workbook. You can control how many rows and cells are copied when iterating the DataSet. Please let me know if you need any further assistance with this matter.