How to copy a .csv worksheet into a .xlsx file without the number values turning into

Thread Rating:

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

Thread Modes

How to copy a .csv worksheet into a .xlsx file without the number values turning into

buran

Posts: 8,093

Threads: 154

Joined: Sep 2016

Reputation: 582

Mar-28-2020, 06:51 AM

When reading from csv you will get str, unless you do conversion. You don't show how you read the file, but you can do the conversion either when reading or when writing to excel

If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Find

Messages In This Thread

How to copy a .csv worksheet into a .xlsx file without the number values turning into - by YoshikageKira - Mar-28-2020, 04:30 AM

RE: How to copy a .csv worksheet into a .xlsx file without the number values turning into - by deanhystad - Mar-28-2020, 05:44 AM

RE: How to copy a .csv worksheet into a .xlsx file without the number values turning into - by YoshikageKira - Mar-28-2020, 05:57 AM

RE: How to copy a .csv worksheet into a .xlsx file without the number values turning into - by buran - Mar-28-2020, 06:51 AM

RE: How to copy a .csv worksheet into a .xlsx file without the number values turning into - by YoshikageKira - Mar-28-2020, 07:10 AM

RE: How to copy a .csv worksheet into a .xlsx file without the number values turning into - by buran - Mar-28-2020, 08:24 AM

RE: How to copy a .csv worksheet into a .xlsx file without the number values turning into - by YoshikageKira - Mar-28-2020, 09:38 AM

RE: How to copy a .csv worksheet into a .xlsx file without the number values turning into - by buran - Mar-28-2020, 10:38 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Errors if an xlsx file has blank rows in the beginning….	tester_V	1	889	Aug-28-2023, 06:22 PM Last Post: deanhystad
	Export dataframe to xlsx - Error "zipfile.BadZipFile: File is not a zip file"	Baggio	10	63,103	Mar-12-2021, 01:02 PM Last Post: buran
	XLSX file with multiple sheets to josn file	ovidius	2	2,293	Apr-05-2020, 09:22 AM Last Post: ovidius
	spread values of dataset equally over fixed number of bins	moose_man	3	2,581	Oct-30-2019, 07:41 PM Last Post: ichabod801
	Import Excel File that Starts with Number	kiki1113	1	3,372	Dec-20-2018, 07:13 PM Last Post: Larz60+
	copy one column from csv file and paste into xls file	kprogrammer	0	4,426	Nov-03-2018, 04:03 PM Last Post: kprogrammer
	Copy raw data in excel to another new excel file	keerthiprashanth	5	3,980	Oct-20-2018, 10:13 AM Last Post: volcano63
	Searching a .txt file for a specific number and extracting the corresponding data	nrozman	3	3,295	Jul-27-2018, 02:07 PM Last Post: nrozman
	Updating the Pandas dataframe to existing excel workbook in existing worksheet.	sanmaya	1	9,825	Jul-01-2018, 06:23 PM Last Post: volcano63
	Write data into existing Excel (xlsx) file with multiple sheets	BNB	1	15,431	Jun-01-2017, 04:22 PM Last Post: Larz60+

Users browsing this thread: 1 Guest(s)

View a Printable Version

How to copy a .csv worksheet into a .xlsx file without the number values turning into

User Panel Messages

Announcements