importing multiple excel files

Posted by: franz on 8 September 2017, 12:52 pm EST

  • Posted 8 September 2017, 12:52 pm EST


    how can I compose one big spreadsheet with the data of several excel files.

    All the excel files are identically formatted, i.e. they have the same columns. Only the number of rows can differ.

    I want to add the content of the newly opened excel file to the data of the allready openend excel files into the spread.

    Is this possible, because I tried working with a main and temporary sheet, opening the new excel files in the temporary before adding them to the main using  <FONT size=2><FONT size=3>ClipboardPaste</FONT>, <FONT size=3>but I cannot define from where (a row) the paste operation has to start, it allways pasts over the old content, and so it replaces instead off adding new rows.</FONT></FONT>

    <FONT size=2>What am I doing wrong?</FONT>

    <FONT size=2>Thanks in advance,</FONT>

    <FONT size=2>frank

  • Replied 8 September 2017, 12:52 pm EST

    Frank -

    If you already have data in the main spread and want to paste data from another sheet I would use the GetLastNonEmptyRow method to return the last row with data from the main spread.  You could then use the <span id="pagetitle">ClipboardPaste(ClipboardPasteOptions,IDataObject,CellRange) method(after copying the data from the other spread) to paste the data into the cell range that starts in the row after the row returned by the GetLastNonEmptyRow method.  Or you can just select a range of cells in the main spread after the last row with data and paste into those.  Just a few suggestions to get you started.
Need extra support?

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

Learn More

Forum Channels