All geek questions in one place

Excel file open under Ubuntu, read R, OpenOffice

I have a bunch of Excel files that are updated daily on a Windows computer. I transfer them to an Ubuntu machine and want to open them there. In particular, I want to read files as a database under R.

A few years ago, I used ODBC under a Windows machine to open Excel files through R. Is there any way I can do this with R under Ubuntu?

I can make a .ODB database file for the corresponding XLS files using OpenOffice, but I don't know how to connect to the .ODB database. OpenOffice has ways to connect to TO databases, but there is no way to connect to ODB.

Thanks for any possible solutions.

+3
source share
4 answers

, xls2csv apt-get install catdoc, Excel CSV. , , . read.csv.sql sqldf , SQL.

+4

xlsx , ( xlsReadWrite ), Linux. ( ) xlsx.

read.xls gdata, xls csv . Perl xls2csv, Linux.

+2

ODBC Linux, uniXODBC ( unixODBC-devel, RODBC) RODBC R. Gabor @daroczig , RODBC linux; , Linux .

, @daroczig Gabor, ODBC, Ubuntu.

+2

Another solution is to place your data in a database that both of your machines have access to. Postgres or MySQL will not cost you anything or an MS-SQL server if you have a crash of money. What you are trying to do is exactly what network RDBMSs were created for. You can play with data in Excel and R on remote computers. Win.

Copying Excel files around is a massive unsuccessful wait. Get yourself a real DBMS. I would go for Postgres.

+2
source

Source: https://habr.com/ru/post/1784374/

More articles:


All Articles