Bottom Page

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 python openpyxl writing data

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.

you forgot to post your code
Sorry !!
I solved this problem.
I have anew problem. I ma not able to delete a Bar Chart which i have created using OPENPYXL in PYTHON.
Here is the code:
data=Reference(sheet2,min_row=2, max_row=sheet2.max_row, min_col=3)
category=Reference(sheet2,min_col=2, min_row=2, max_row=sheet2.max_row)
chart.add_data(data, titles_from_data=False)
chart.x_axis.title= "Time"
Larz60+ wrote Oct-17-2019, 04:49 PM:
Please post all code, output and errors (in it's entirety) between their respective tags. I did it for you this time, Here are instructions on how to do it yourself next time.

Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  writing data to a csv-file apollo 1 67 Jul-03-2020, 02:28 PM
Last Post: DeaD_EyE
  openpyxl Pasting data to different cells Kristenl2784 3 211 Jun-15-2020, 08:50 PM
Last Post: Yoriz
  Writing Data to CSV abhaydd 2 566 Aug-09-2019, 01:08 AM
Last Post: DeaD_EyE
  Who converts data when writing to a database with an encoding different from utf8? AlekseyPython 1 610 Mar-04-2019, 08:26 AM
Last Post: DeaD_EyE
  Help with Code (Writing Data File) caroline_d_124 3 719 Jan-06-2019, 09:17 PM
Last Post: caroline_d_124
  Openpyxl -Coming up with a single column from a multi column data set Givan007 1 833 Sep-07-2018, 04:29 AM
Last Post: Prabakaran141
  Recommend an Excel library for writing data? jonesin1974 1 1,034 Feb-09-2018, 10:28 PM
Last Post: Gribouillis
  Writing data from a DHT11 to LCD expplane 2 1,393 Aug-07-2017, 03:38 PM
Last Post: expplane
  overwrite data using openpyxl BNB 0 6,329 Jun-21-2017, 11:31 AM
Last Post: BNB

Forum Jump:

Users browsing this thread: 1 Guest(s)