Excel, Python, Linux

M

Mike

Hi everyone,

The situation is this: I am thinking of creating an input database for
mathematical program (MP) model in Excel. I am using MS-Windows as a
platform. However, someone somewhere will use same MP on Linux. So,
Excel database can't be read in Linux and OpenOffice is not allowed!

Unless there is an acceptable alternative to OpenOffice, we have to
explore other options. One potential is to create the database using
Python, programming language, and Python data files are readable in
both MS-Windows and Linux.

Is this the only way? Any alternative?

Thanks
Mike
 
C

CellShocked

Hi everyone,

The situation is this: I am thinking of creating an input database for
mathematical program (MP) model in Excel. I am using MS-Windows as a
platform. However, someone somewhere will use same MP on Linux. So,
Excel database can't be read in Linux and OpenOffice is not allowed!

Unless there is an acceptable alternative to OpenOffice, we have to
explore other options. One potential is to create the database using
Python, programming language, and Python data files are readable in
both MS-Windows and Linux.

Is this the only way? Any alternative?

Thanks
Mike

You simply export the excel data in ASCII delimited database format,
and then filter it into any database you want in Linux, and you can pass
data into excel that way as well.

You do not have to use Python if you don't wish to. Use whatever you
want.sql.

So, where is the problem? Is it some huge, hard to manage data set?
 
M

Mike

  You simply export the excel data in ASCII delimited database format,
and then filter it into any database you want in Linux, and you can pass
data into excel that way as well.

  You do not have to use Python if you don't wish to. Use whatever you
want.sql.

 So, where is the problem?  Is it some huge, hard to manage data set?

The database currently is number of data-files (each has number of
tables), of whom a one of them only is so huge (could exceeds 3 mil).
As you know, Excel has a limit of one million rows and Excel is not
readable in Linux. So to go around this, will exclude that huge data-
file from Excel and read it from Access for example.
 
K

Keith Byrne

The database currently is number of data-files (each has number of
tables), of whom a one of them only is so huge (could exceeds 3 mil).
As you know, Excel has a limit of one million rows and Excel is not
readable in Linux. So to go around this, will exclude that huge data-
file from Excel and read it from Access for example.

There is the option of SQLite (http://www.sqlite.org/) as a file based
DB. It has the advantage of being platform independent and the
advantage of being accessed through a number of libraries including
ODBC which you can use in Access/Excel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top