I can not import two sheet which are included in each file.

Posted by: jaehan on 8 September 2017, 1:40 pm EST

  • Posted 8 September 2017, 1:40 pm EST


    hi,



    I am using FarPoint_Spread_WinForms_V2_5_2008_VS2005.


    now I try to import two sheets of the excel.


    I can Import one file through Excel.Opeon function.


    also I can merge two files in the excel.


    but I want to import two sheet of the excel files


    in the excel, I was using someting like below.


     xSheet.UsedRange.Copy(targetSheet.UsedRange.get_Range(targetSheet.Cells[iRowCount,1],targetSheet.Cells[iRowCount]


     but I can not using usedrange and get_range.


    becose the farpoint is different with excel function and instance.


    how can I import two excel files to farpoint sheet?


    p.s It is second project with using spread sheet . may be there are many way  which I don't know.


    let me know about that.   


     jaehan.

  • Replied 8 September 2017, 1:40 pm EST

    jaehan,


    There is not a way to bring in two Excel files into one Spread. However, you can use a second 'hidden' Spread to bring in the second Excel file. Then, you can use the Sheets.Add method of the first Spread to load the sheet from the second Spread to the first.

  • Replied 8 September 2017, 1:40 pm EST

    hi scotts,


    thank for your help.


    first, I execute your advice.


    and if I need more your help.


    I ask you about this subject again.


    thank to you again.


    have good day.


     jaehan.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels