4

I have a problem to import into LibreOffice an external csv . enter image description here

I press OK, and everything is formatted correctly

enter image description here

After the "ok" button is disabled and I can not continue..

enter image description here

Any suggestion?

Fr4ncx
  • 356
  • 6
  • 22
  • 2
    As far as i see, you can't use csv as source for external data. Only html, xls and ods are supported. Alternatively, you may try Menu `Insert` -> `Sheet from file` (see [this Q/A from ask.lo](https://ask.libreoffice.org/en/question/27063/external-data-source-with-csv/)) – tohuwawohu Dec 03 '15 at 10:43

1 Answers1

0

I had the same problem. Calc can't import CSV from external data source, only HTML, ODF, and a few others.

If you need to import the file just once, download the CSV, then use the 'Insert Sheet' option.

You don't mention what OS you're using. I needed to do the same thing as you and managed it on ubuntu linux.

I needed it to update every 't' seconds, so I wrote a bash script with wget to download (and replace) the CSV file on a loop, and added a CSV to HTML converter script to the end of my own, replacing "Medical.csv" with the file previously downloaded. All the "echo"s were piped to a output.html

Now I have an HTML being regularly updated with the values of the CSV from the website

Community
  • 1
  • 1
Rocchi
  • 26
  • 1
  • 5