Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Excel, Python, Linux
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 |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Excel, Python, Linux
On Sat, 11 Dec 2010 20:54:35 -0800 (PST), Mike
wrote: 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? |
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Excel, Python, Linux
On Dec 11, 9:38*pm, CellShocked
<cellshoc...@thecellvalueattheendofthespreadsheet. org wrote: On Sat, 11 Dec 2010 20:54:35 -0800 (PST), Mike wrote: 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? 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. |
#4
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Excel, Python, Linux
On Dec 12 2010, 5:36*pm, Mike wrote:
On Dec 11, 9:38*pm, CellShocked <cellshoc...@thecellvalueattheendofthespreadsheet. org wrote: On Sat, 11 Dec 2010 20:54:35 -0800 (PST), Mike wrote: 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? 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Database Readability in Linux? | Excel Programming | |||
Calling a python script from VBA? | Excel Programming | |||
[Excel, VB6] Encode text before sending to Linux server | Excel Programming | |||
Exchanging data between Linux and Excel | Excel Programming | |||
How to open excel file from linux | Excel Programming |