Member Avatar for MartinPB

Hi all

I have a large folder containing multiple xlsx (only one sheet) files which I need to convert to a csv format.
I can convert them individually using the xlsx2csv but I cannot make a working function that loops over all the files in the folder and saves them with the same names as the xlsx-files but as csv.

I have been searching a lot of different forums, but I have been unable to find a helpful thread.

Can anyone help me?

Best,
Martin

OBS...
I do the individual conversion like the following:

from xlsx2csv import *
xlsx2csv("dir\ID_01.xlsx", open("ID_01.csv", "w+"))

And that converts the file ID_01.xlsx into ID_01.csv.

  • 2 Contributors
  • 1 Reply
  • 1K Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by TrustyTony
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.