Bottom Page

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 python openpyxl writing data
#1
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
Quote
#2
you forgot to post your code
Quote
#3
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:
chart=BarChart() 
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.set_categories(category)
sheet2.add_chart(chart,"M3")
chart.title="Count"
chart.x_axis.title= "Time"
chart.y_axis.title="Reason"
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.
Quote

Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  Writing Data to CSV abhaydd 2 384 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 392 Mar-04-2019, 08:26 AM
Last Post: DeaD_EyE
  Help with Code (Writing Data File) caroline_d_124 3 486 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 565 Sep-07-2018, 04:29 AM
Last Post: Prabakaran141
  Recommend an Excel library for writing data? jonesin1974 1 847 Feb-09-2018, 10:28 PM
Last Post: Gribouillis
  Writing data from a DHT11 to LCD expplane 2 1,171 Aug-07-2017, 03:38 PM
Last Post: expplane
  overwrite data using openpyxl BNB 0 5,146 Jun-21-2017, 11:31 AM
Last Post: BNB

Forum Jump:


Users browsing this thread: 1 Guest(s)