Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
120
how to upload data from excel to directly into worksheet.
posted

I have one infragistics workbook with two worksheet. I need to upload data from two excel to two worksheets of workbook directly.

  • 23930
    Offline posted

    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,                                            
    Dimitar
    Developer Support Engineer
    Infragistics
    www.infragistics.com/support

  • 23930
    Offline posted

    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.

    WorkbooksToSheets.zip