Member Avatar for gishi

hi!

does anyone know how to convert excel file (xls and xlsx)(or even just xls) into csv preferably using xlrd and csv modules. i need to convert a specific excel sheet to csv. i need to create a csv file instead of using comma but semicolon. i am still not familiar with python and i really need to convert files. hope someone can help me.

thanks in advance!

Edited by gishi because: n/a
  • 2 Contributors
  • 6 Replies
  • 619 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by gishi
Member Avatar for gishi

hi!I already tried the codes but i didn't work though. do you have other suggestions or codes so that i can do this? thanks!

Member Avatar for Beat_Slayer

Does pyexcelerator doesn't work?

Wich system you are running, and can you post a sample xls?

Wich error message the converter from pyexcelerator gives?

Member Avatar for gishi

This is the traceback when I import pyExcelerator. I have installed it again and still does not work:

Traceback (most recent call last):
File "<interactive input>", line 1, in ?
ZipImportError: bad local file header in C:\Python24\lib\site-packages\pyexcelerator-0.6.4.1-py2.4.egg

Do you have a code that use xlrd module instead of pyexcelerator?

thanks

Edited by gishi because: incomplete post
Member Avatar for gishi

in addition, this should read or open excel files created in microsoft excel

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.