Creating csv files from Excel file

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

Creating csv files from Excel file

azizrasul
Wafer-Thin Wafer

Posts: 75

Threads: 14

Joined: Jul 2022

Reputation: 0

Oct-28-2022, 05:54 PM

That worked, thanks.

How can I adjust the code so it loops through all the worksheets and each worksheet created a csv file with the name of the worksheet e.g. Sheet1.csv, Sheet2.csv, etc.

Find

Messages In This Thread

Creating csv files from Excel file - by azizrasul - Oct-27-2022, 09:37 PM

RE: Creating csv files from Excel file - by Larz60+ - Oct-28-2022, 01:25 AM

RE: Creating csv files from Excel file - by deanhystad - Oct-28-2022, 02:23 AM

RE: Creating csv files from Excel file - by azizrasul - Oct-28-2022, 05:54 PM

RE: Creating csv files from Excel file - by deanhystad - Oct-28-2022, 08:37 PM

RE: Creating csv files from Excel file - by azizrasul - Oct-28-2022, 09:39 PM

RE: Creating csv files from Excel file - by Yoriz - Oct-28-2022, 09:58 PM

RE: Creating csv files from Excel file - by Larz60+ - Oct-28-2022, 10:02 PM

RE: Creating csv files from Excel file - by azizrasul - Oct-28-2022, 11:28 PM

RE: Creating csv files from Excel file - by azizrasul - Oct-28-2022, 11:31 PM

RE: Creating csv files from Excel file - by Larz60+ - Oct-29-2022, 08:55 AM

RE: Creating csv files from Excel file - by azizrasul - Oct-29-2022, 04:27 PM

RE: Creating csv files from Excel file - by deanhystad - Oct-29-2022, 06:51 PM

RE: Creating csv files from Excel file - by azizrasul - Oct-29-2022, 07:22 PM

RE: Creating csv files from Excel file - by azizrasul - Oct-29-2022, 07:28 PM

RE: Creating csv files from Excel file - by deanhystad - Oct-30-2022, 12:45 AM

RE: Creating csv files from Excel file - by Larz60+ - Oct-29-2022, 07:56 PM

RE: Creating csv files from Excel file - by azizrasul - Oct-29-2022, 08:33 PM

RE: Creating csv files from Excel file - by Larz60+ - Oct-29-2022, 11:54 PM

RE: Creating csv files from Excel file - by azizrasul - Oct-30-2022, 01:17 AM

RE: Creating csv files from Excel file - by azizrasul - Oct-30-2022, 01:23 AM

RE: Creating csv files from Excel file - by azizrasul - Oct-30-2022, 01:25 AM

RE: Creating csv files from Excel file - by deanhystad - Oct-30-2022, 03:20 AM

RE: Creating csv files from Excel file - by azizrasul - Nov-01-2022, 11:33 PM

RE: Creating csv files from Excel file - by Larz60+ - Nov-01-2022, 11:44 PM

RE: Creating csv files from Excel file - by azizrasul - Nov-01-2022, 11:51 PM

RE: Creating csv files from Excel file - by Larz60+ - Nov-02-2022, 06:23 PM

RE: Creating csv files from Excel file - by deanhystad - Nov-02-2022, 07:17 PM

RE: Creating csv files from Excel file - by azizrasul - Nov-02-2022, 07:44 PM

RE: Creating csv files from Excel file - by Larz60+ - Nov-02-2022, 08:46 PM

RE: Creating csv files from Excel file - by azizrasul - Nov-02-2022, 09:23 PM

RE: Creating csv files from Excel file - by azizrasul - Nov-02-2022, 11:13 PM

RE: Creating csv files from Excel file - by azizrasul - Nov-02-2022, 11:23 PM

RE: Creating csv files from Excel file - by Larz60+ - Nov-03-2022, 01:06 AM

RE: Creating csv files from Excel file - by azizrasul - Nov-03-2022, 02:05 AM

RE: Creating csv files from Excel file - by deanhystad - Nov-03-2022, 03:01 AM

RE: Creating csv files from Excel file - by azizrasul - Nov-03-2022, 04:10 PM

RE: Creating csv files from Excel file - by deanhystad - Nov-03-2022, 05:36 PM

RE: Creating csv files from Excel file - by azizrasul - Nov-03-2022, 07:22 PM

RE: Creating csv files from Excel file - by deanhystad - Nov-03-2022, 07:43 PM

RE: Creating csv files from Excel file - by azizrasul - Nov-03-2022, 08:33 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	docx file to pandas dataframe/excel	iitip92	1	3,025	Jun-27-2024, 05:28 AM Last Post: Pedroski55
	Python openyxl not updating Excel file	MrBean12	1	2,267	Mar-03-2024, 12:16 AM Last Post: MrBean12
	Copy Paste excel files based on the first letters of the file name	Viento	2	1,679	Feb-07-2024, 12:24 PM Last Post: Viento
	Search Excel File with a list of values	huzzug	4	3,009	Nov-03-2023, 05:35 PM Last Post: huzzug
	Updating sharepoint excel file odd results	cubangt	1	2,181	Nov-03-2023, 05:13 PM Last Post: noisefloor
	Help creating shell scrip for python file	marciokoko	10	3,714	Sep-16-2023, 09:46 PM Last Post: snippsat
	Reading data from excel file –> process it >>then write to another excel output file	Jennifer_Jone	0	2,179	Mar-14-2023, 07:59 PM Last Post: Jennifer_Jone
	Save and Close Excel File	avd88	0	6,943	Feb-20-2023, 07:19 PM Last Post: avd88
	Trying to access excel file on our sharepoint server but getting errors	cubangt	0	1,558	Feb-16-2023, 08:11 PM Last Post: cubangt
	Import XML file directly into Excel spreadsheet	demdej	0	1,658	Jan-24-2023, 02:48 PM Last Post: demdej

Users browsing this thread: 1 Guest(s)

View a Printable Version

Creating csv files from Excel file

User Panel Messages

Announcements