python openpyxl writing data

Thread Rating:

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

Thread Modes

python openpyxl writing data

Bikram
Unladen Swallow

Posts: 2

Threads: 1

Joined: Oct 2019

Reputation: 0

Oct-15-2019, 08:51 PM

Hi,

I can write numerical data to the excel file. But it saves as a text. I am using "openpyxl" module for creating, writing and saving excel file.
Can anyone help me to convert the data to numerical data in excel file.

Any help is appreciated.

Thanks,
Bikram

Find

Messages In This Thread

python openpyxl writing data - by Bikram - Oct-15-2019, 08:51 PM

RE: python openpyxl writing data - by Larz60+ - Oct-16-2019, 02:23 AM

RE: python openpyxl writing data - by Bikram - Oct-17-2019, 03:33 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Help with writing monitored data to mysql upon change of one particular variable	donottrackmymetadata	3	288	Apr-18-2024, 09:55 PM Last Post: deanhystad
	Issue in writing sql data into csv for decimal value to scientific notation	mg24	8	3,059	Dec-06-2022, 11:09 AM Last Post: mg24
	openpyxl convert data to float	jacklee26	13	6,023	Nov-19-2022, 11:59 AM Last Post: deanhystad
	Create a function for writing to SQL data to csv	mg24	4	1,175	Oct-01-2022, 04:30 AM Last Post: mg24
	Need Help writing data into Excel format	ajitnayak87	8	2,540	Feb-04-2022, 03:00 AM Last Post: Jeff_t
	Fastest Way of Writing/Reading Data	JamesA	1	2,203	Jul-27-2021, 03:52 PM Last Post: Larz60+
	Set 'Time' format cell when writing data to excel and not 'custom'	limors	3	6,317	Mar-29-2021, 09:36 PM Last Post: Larz60+
	Python Openpyxl is unable to check from Column 6 onwards	Skye	0	1,731	Oct-13-2020, 06:11 AM Last Post: Skye
	Formatting Data/Time with Pyodbc and openpyxl	bearcats6001	0	2,293	Aug-17-2020, 03:44 PM Last Post: bearcats6001
	writing data to a csv-file	apollo	1	2,378	Jul-03-2020, 02:28 PM Last Post: DeaD_EyE

Users browsing this thread: 2 Guest(s)

View a Printable Version

python openpyxl writing data

User Panel Messages

Announcements