Thank you for using Syncfusion products.
We are unable to reproduce the issue at our end. So we have provided the simplified sample for importing data with named range using XlsIO in the following link. Kindly refer to this and share us the screenshot for the scenario you are expecting or modify the provided sample for your requirement if possible, to assist you with a prompt solution.
Please let us know if you need any clarification.
From: Karl Hauschildt [mailto:email@example.com]
Sent: Friday, March 06, 2015 6:30 AM
To: Syncfusion Support; Karl@TheSoftwareCafe.com
Subject: RE: Syncfusion support community forum 118386, I need something like the native Excel insert cells using a named range., has been updated.
Your solution uses ImportDataTable and it’s behavior will be to overwrite any cells in the range and that is the behavior I have to prevent. It needs to insert new cells within the range and push down.
The InsertRows method does the push down and preserves any formula but there is not concept of a range.
We were able to reproduce the problem and have logged defect report regarding this. A support incident to track the status of this defect has been created under your account. Please log on to our support website to check for further updates
Please let me know if you have any questions.