How do I import numbers from a text document to a cell or cell area in Libre Calc?

[binarygirl]

Hi all,
I have a lot of text documents to copy into Libre Calc sheets. I can’t do regular file import because there is other stuff in the sheet as well. I would like to have either each cell call numbers from the text document, or import the file into a certain cell range/area of the sheet. Is there a function for this? If not, a way to write a script that would do this? The text files are all organised into columns by being tab or space delimited.

Thank you very much!

[JohnSUN]

Select data in text document and copy it to clipboard.

Switch to workbook and select top-left cell of range to paste.

Use Paste Special - DDE Link

[binarygirl]

hi JohnSUN,
thank you a lot for the answer. i was looking for a solution that didn’t involve using copy/paste because this is very time consuming when there are a lot of sheets! do you know of anything more automated or command-like that lets you grab files? any idea if i can use a macro or something for this?
thank you!!