Ask Your Question
1

binding a range of cells to simple csv data file

asked 2017-01-10 01:53:35 +0100

jjj4 gravatar image

This really is so simple but I can't figure it out. I have a simple text file with a 3x3 matrix of csv numbers i.e.

2,7,5
9,9,0
3,2,1

I want to bind a grid of nine cells on my spreadsheet (say A1:C3) to that file.

if the file changes, i refresh the spreadsheet, the spread sheet changes. simple. i can do this all day long in *xcel.

this should be so simple its ridiculous but "sheet"->"link to external data" doesnt work.

edit retag flag offensive close merge delete

4 Answers

Sort by » oldest newest most voted
1

answered 2017-01-11 00:37:50 +0100

karolus gravatar image

updated 2017-01-11 18:08:14 +0100

David gravatar image

It is possible to link the .csv into one sheet, via → Sheet → insert Sheet from file[1] with [x] Link option in Import-dialog.

To refresh the sheet after changing the CSV file, use → Fiile → Reload

[1] In prior Versions of LO it was → insert → insert Sheet from File

edit flag offensive delete link more
0

answered 2017-01-10 18:48:20 +0100

pierre-yves samyn gravatar image

Hi

Sorry, I only have a short connection time and could not explain in detail but what is requested is possible...

  • Follow the FAQ I've created showing how to link a text file to a database.
  • Register the database: ToolsOptionsLibreOffice BaseDatabasesNew (select the database)
  • Then, in the spreadsheet, ViewData Sources
  • Unfold the Database▸Tables▸Click at the intersection of the row and column headers to select all data
  • Click Data to Text in the Table Data toolbar: data is inserted into the sheet and one database range is created (default Import1) as you can see in the navigator.

Then just do DataRefresh Range to update the data

Longer to explain than to do ... :)

Regards

edit flag offensive delete link more
0

answered 2017-01-10 14:55:26 +0100

Lupp gravatar image

I don't think there ever was an option to link in a csv as a table (data source).
You can link to tables contained in spreadsheets of Calc or Excel style or those contained in HTML files.

edit flag offensive delete link more
0

answered 2017-01-10 22:51:08 +0100

m.a.riosv gravatar image

You can link to the csv file as it was a spreadsheet.

Opening both files it's easier, and you can see how the sheet name it's assigned.

edit flag offensive delete link more

Comments

Yes of course, but the question was not how to link a range of cells?

pierre-yves samyn gravatar imagepierre-yves samyn ( 2017-01-12 07:18:53 +0100 )edit

I'm not sure, but anyway with this method there is no limit on the range (sheet limits), it's easier using arrays to link.

m.a.riosv gravatar imagem.a.riosv ( 2017-01-13 03:49:05 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-01-10 01:53:35 +0100

Seen: 382 times

Last updated: Jan 11 '17