I am new to python. i am working in php project. we need to implement one module

Question

I am new to python. i am working in php project. we need to implement one module in our project which is generating excel file with very large amount of data. so we choose python for generating excel files.

But i am very confused for choosing python module. there are lot of excel generator library available in python (pyexcelerator, pyexcelerate, xlrd, xlwt, xlutils, xlsxWriter,..etc) which one is best?

my current option is pyexcelerate. is this good? or suggest which have to choose?

we have very large amount of data to write. So it should be fast and take very less memory for process. So which is Best?

Explanation / Answer

This probably boils down to a matter of taste.

I would recommend you to give preference to packages which still show some activities on the developer side as it might increase the longevity of your code.

Personally I used the packages xlwt and xlrd a lot. The former is for writing and the latter for reading Excel files. I had to process files with around 100'000 lines and memory or speed never was an issue.
For xlrd

Here is the documentation to xlrd and here are some simple examples to get you started in no time.
For xlwt

Here is the documentation. Here and here are some simple examples.

But as I said, it is probably a matter of taste and I'm not saying that the other packages you mentioned are any worse than xlrd. It is just the one I do have experience with and I always was pretty satisfied with it.

Hope that is of some help to you.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.