I have one infragistics workbook with two worksheet. I need to upload data from two excel to two worksheets of workbook directly.
Hello,
I am just checking about the progress of this issue. Let me know if you need my further assistance on this issue.
Thank you for using Infragistics Components.
Sincerely, DimitarDeveloper Support EngineerInfragisticswww.infragistics.com/support
Hi,
Thank you for posting in our forums.
If I understand you correctly you want to merge two excel workbooks into one, by copying their worksheets. If that is the case, what you could do is to iterate the excel files that you need to merge, and then copy the information from their worksheets to the worksheets of the resulting file. For more information on how to do this, please visit the following link:
http://ko.infragistics.com/community/forums/p/21801/296717.aspx#296717
Alternatively, if you don’t want to do the copying manually, please log a new product idea for this feature from our product ideas site: http://ideas.infragistics.com/.
I have attached a sample demonstrating how to implement this feature manually. It gets the files from the Workbooks folder (it also works with more than 2 files, in case you need to merge more files) and then create one new workbook and saves it in the Result folder.
Please let me know if you have any additional questions.