LibreOffice链接到外部数据 [英] LibreOffice Link to external data

问题描述

我在将外部csv导入LibreOffice时遇到问题.

I have a problem to import into LibreOffice an external csv .

我按OK，一切都正确格式化

I press OK, and everything is formatted correctly

禁用确定"按钮后，我无法继续..

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

有什么建议吗?

推荐答案

我遇到了同样的问题. Calc无法从外部数据源(仅HTML，ODF和其他一些数据)导入CSV.

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

如果您只需要导入一次文件，请下载CSV，然后使用插入工作表"选项.

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

您没有提及正在使用的操作系统.我需要做与您相同的事情，并在ubuntu linux上进行管理.

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

我需要它每隔't'秒更新一次，因此我编写了一个带wget的bash脚本，以循环下载(并替换)CSV文件，并添加了

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

现在我有一个HTML，该HTML会定期用网站上的CSV值进行更新

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

这篇关于LibreOffice链接到外部数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！