473,407 Members | 2,598 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,407 software developers and data experts.

excel library without COM

Hi,

is there any library to help me write excel files without using win
com? because i'll be working on linux platform. At the same time I
could want to perform some formatting, merging of cells. adding sheets
and etc ...

Thanks
james

Jun 4 '07 #1
7 3986
On Jun 3, 7:59 pm, james_027 <cai.hai...@gmail.comwrote:
Hi,

is there any library to help me write excel files without using win
com? because i'll be working on linux platform. At the same time I
could want to perform some formatting, merging of cells. adding sheets
and etc ...

Thanks
james
I'm not aware of any modules. However, this thread is on the same
topic and it mentions using html or txt files as possibilities:

http://mail.python.org/pipermail/pyt...il/138748.html

I would also think that you could write some kind of custom XML parser/
creator that you could use to create the Excel sheet's structure and
then interface with COM later.

Mike

Jun 4 '07 #2
On Jun 3, 6:59 pm, james_027 <cai.hai...@gmail.comwrote:
is there any library to help me write excel files without using win
com?
One option is:
https://secure.simplistix.co.uk/svn/xlwt/trunk
Jun 4 '07 #3

i think this one works pretty nice: http://www.python.org/pypi/xlrd

Happy hacking,

Yuce
On Jun 4, 3:59 am, james_027 <cai.hai...@gmail.comwrote:
Hi,

is there any library to help me write excel files without using win
com? because i'll be working on linux platform. At the same time I
could want to perform some formatting, merging of cells. adding sheets
and etc ...

Thanks
james

Jun 4 '07 #4
On Jun 4, 3:52 pm, yuce <yucete...@gmail.comwrote:
i think this one works pretty nice:http://www.python.org/pypi/xlrd
Sure does :-) However the "rd" in "xlrd" is short for "ReaD". As
Waldemar suggested, "xlwt" ("wt" as in WriTe) is more like what the OP
needs.

Cheers,
John

Jun 4 '07 #5
On Jun 4, 8:16 pm, John Machin <sjmac...@lexicon.netwrote:
On Jun 4, 3:52 pm, yuce <yucete...@gmail.comwrote:
i think this one works pretty nice:http://www.python.org/pypi/xlrd

Sure does :-) However the "rd" in "xlrd" is short for "ReaD". As
Waldemar suggested, "xlwt" ("wt" as in WriTe) is more like what the OP
needs.

Cheers,
John

Thanks to all who have contributed. I have one concern though. Many of
the module seems to be not active anymore? or updated? It is because
it really stable and has most of the features needed?

Thanks
james

Jun 5 '07 #6
On Jun 5, 1:04 pm, james_027 <cai.hai...@gmail.comwrote:
On Jun 4, 8:16 pm, John Machin <sjmac...@lexicon.netwrote:
On Jun 4, 3:52 pm, yuce <yucete...@gmail.comwrote:
i think this one works pretty nice:http://www.python.org/pypi/xlrd
Sure does :-) However the "rd" in "xlrd" is short for "ReaD". As
Waldemar suggested, "xlwt" ("wt" as in WriTe) is more like what the OP
needs.
Cheers,
John

Thanks to all who have contributed. I have one concern though. Many of
the module seems to be not active anymore? or updated? It is because
it really stable and has most of the features needed?
xlwt is active, stable enough for heavy use, and will get a public
outing Real Soon Now (after xlrd 0.6.1 final, which is expected Truly
Rooly Real Soon Now).
Jun 5 '07 #7
On Jun 5, 6:17 pm, John Machin <sjmac...@lexicon.netwrote:
On Jun 5, 1:04 pm, james_027 <cai.hai...@gmail.comwrote:
On Jun 4, 8:16 pm, John Machin <sjmac...@lexicon.netwrote:
On Jun 4, 3:52 pm, yuce <yucete...@gmail.comwrote:
i think this one works pretty nice:http://www.python.org/pypi/xlrd
Sure does :-) However the "rd" in "xlrd" is short for "ReaD". As
Waldemar suggested, "xlwt" ("wt" as in WriTe) is more like what the OP
needs.
Cheers,
John
Thanks to all who have contributed. I have one concern though. Many of
the module seems to be not active anymore? or updated? It is because
it really stable and has most of the features needed?

xlwt is active, stable enough for heavy use, and will get a public
outing Real Soon Now (after xlrd 0.6.1 final, which is expected Truly
Rooly Real Soon Now).
Thanks a John

Now my searching is over

Jun 6 '07 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Marwa Bahaa | last post by:
HI all, I have an application using ASP.net, and in this application the user will have the choice to download data from Sql Server to excel sheet,this will be done using code only could any one...
17
by: Ange T | last post by:
Hi there, I'm having pain with the VB behind an Access form. The form is used to create reports in Excel based on the details entered in the form. This has always worked without error on my...
3
by: eye5600 | last post by:
I want to read/write Excel files but I am having trouble getting started. Using MS article 302084 as a cookbook, I try to add the reference for MS Excel Object Library. Two versions are listed, 5 &...
9
by: [Yosi] | last post by:
Can I make an Excel file without having Excel in my PC ? I want to create Excel files from my C# application , then open those files later in another PC who have Excel installed . As we can open...
9
by: hari krishna | last post by:
hi, I want to send the data from dataset information to Excel through ASP.Net. there will be no XL installed on web server. web server is win 2000 server machine. I am using visual basic code in...
4
by: Lisa | last post by:
Hi - I'm able to open excel workbooks and word documents, but I can't seem to copy excel charts, named ranges, etc. to a word document. Anyone know of good reference material in this area? What...
3
by: cs_hart | last post by:
Is it possible to access excel worksheets without starting the excel application? If it makes any difference I'm running vb.net 2003 and excel 97. thanks...charlie
10
by: Steve | last post by:
I am trying to create a DLL in Visual Studio 2005-Visual Basic that contains custom functions. I believe I need to use COM interop to allow VBA code in Excel 2002 to access it. I've studied...
9
by: John Bailo | last post by:
I want to generate an Excel file (.xls format) from some database data. I don't want to use Excel.exe because of all the automation and security issues. Does Microsoft document the .xls file...
2
by: Nicholas Dreyer | last post by:
The following error Run-time exception thrown : System.Runtime.InteropServices.COMException - Error loading type library/DLL. happens while running the code listed at the bottom of this...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.