LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
external usenet poster
 
Posts: 277
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Database Readability in Linux? Mike Excel Programming 3 December 7th 10 11:40 PM
Calling a python script from VBA? NateBuckley Excel Programming 1 August 21st 08 03:37 PM
[Excel, VB6] Encode text before sending to Linux server JoTak Excel Programming 1 November 28th 05 10:27 PM
Exchanging data between Linux and Excel Kiwi Trader Guy Excel Programming 1 June 12th 05 12:45 PM
How to open excel file from linux halarikeyur[_3_] Excel Programming 2 October 27th 04 08:37 PM


All times are GMT +1. The time now is 01:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"