By registering with us, you'll be able to discuss, share and private message with other members of our community.

SignUp Now!
  • Guest, before posting your code please take these rules into consideration:
    • It is required to use our BBCode feature to display your code. While within the editor click < / > or >_ and place your code within the BB Code prompt. This helps others with finding a solution by making it easier to read and easier to copy.
    • You can also use markdown to share your code. When using markdown your code will be automatically converted to BBCode. For help with markdown check out the markdown guide.
    • Don't share a wall of code. All we want is the problem area, the code related to your issue.

    To learn more about how to use our BBCode feature, please click here.

    Thank you, Code Forum.

Python Read xls and xlsx file to write it in csv file using python


New Coder
Hi All,

I have
2 -> .XLS files (with header),
1 -> .XLSX file and
1 -> .XLSX file (password protected)

I have to read these files optimally and create respective .CSV files

- What would be the best optimized approach?
- What are the necessary libraries required? Can one library solve this or we need different libraries for specific type of file?
- Can you share sample codes?
- There should be no loss of data.
- There is HEADER in file(as it is a reporting file) which has content to be extracted from.
- If there are extra empty columns then I want to exclude them in CSV.
- If there are empty cells then it should be blank (eg :- xyz,,abc),
NO space or any other value(eg :- xyz, ,abc).

Please let me know if more information is required.

New Threads

Latest posts

Buy us a coffee!

Top Bottom