Calc import txt script

[Mekemba]

I would like to know if a macro exists so that Calc it inserts the content of an archive of simple .txt text in a specific cell.
I would like that it made this when opening automatically the spread sheet.
Thanks.

[Villeroy]

Yes, there is. And guess where you can find it: It's all in your head already.

[Mekemba]

I do not know what you wanted to say…
But I need that somebody gives script to me

[Villeroy]

... inserts the content of an archive of simple .txt text in a specific cell.

You are so unspecific that you want us to read your mind. Do you really want to read a whole text file with line-breaks and everything into a single spreadsheet cell? Never seen such a thing.

[Villeroy]

Code: Select all

Sub Main
oCell = thisComponent.Sheets.getByIndex(0).getCellByPosition(0,0)
iNumber = freefile()
open "/tmp/dummy.txt" for input as iNumber
While not eof(iNumber)
Line Input #iNumber, sLine
If sLine <>"" then
	sMsg = sMsg & sLine & chr(10)
end if
wend
Close #iNumber
oCell.setString(sMsg)
End Sub

Most of it copied from the Basic help.

[Ronaldwin]

Hi All,

I copy the script on Calc. Try to run it. Nothing is seen.

I rename the txt file path to d:\tmp\dummy.txt

Please help me how to run

Also, the dummy.txt contain about 360,000 data record. Is it work?

Wait for your return.

Mr. Ronald

[probe1]

Welcome to the forum.

contain about 360,000 data record. Is it work?

You are kidding: 360K records into one cell?

[Ronaldwin]

To Probe 1,

My objective is to insert one data record to one cell in Calc. However, the txt database contain 360K data records.

When I use the posted script, I did not see any response. Please let me know how to get the result/response

2). When I import the .txt database by Calc (Open Office 3.0) import function, the Calc response that it is over 65536 row limit.

Please help me.

Wait for your return.

[Villeroy]

Put your txt file in it's own directory.
File>New>Database...
[X] Connect to existing database
Type: Text
Specify the directory of your text database.
Specify details of your text file (and other files that may be in the same directory as well)
[X] Register database (for further use in Writer or Calc)
Store the database document.