473,232 Members | 1,647 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,232 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 3983
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...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

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.