At 15:45 07/08/2008 +0100, Christian Liebig wrote:
I am new to this list and I hope this is the right place for the
following problem:
Very probably!
I have several Excel files, each containing 1 sheet. I would like to
combine them to 1 spreadsheet document where each file should be
converted to a sheet in the new document. All original files are in
1 folder so my idea is to do some kind of batch import but I have no
idea how to do that.
I don't know any batch facility. Unless you have too many files, try
one of these:
o Open your first document in Calc.
For each subsequent document:
o Select a sheet adjacent to where you want the next one to appear.
o Go to Insert | Sheet From File... .
o Browse to the next document file.
o Select Before or After current sheet under Position.
o Under Sheet | From file, select the sheet(s) of the new document
that you wish to insert. (You can select multiple sheets using Ctrl+click.)
o Press OK.
Alternatively:
o Open your first document in Calc.
For each subsequent document:
o Open the document in Calc.
o Select the sheet you wish to copy.
o Go to Edit | Sheet > | Move/Copy... .
o Under "To document", select your main document.
o Under "Insert before", select your desired position for the insertion.
o Ensure that Copy (at the bottom of the panel) is ticked.
o Press OK.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
