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 422 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 439 Mar-04-2019, 08:26 AM
Last Post: DeaD_EyE
  Help with Code (Writing Data File) caroline_d_124 3 534 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 620 Sep-07-2018, 04:29 AM
Last Post: Prabakaran141
  Recommend an Excel library for writing data? jonesin1974 1 886 Feb-09-2018, 10:28 PM
Last Post: Gribouillis
  Writing data from a DHT11 to LCD expplane 2 1,224 Aug-07-2017, 03:38 PM
Last Post: expplane
  overwrite data using openpyxl BNB 0 5,356 Jun-21-2017, 11:31 AM
Last Post: BNB

Forum Jump:


Users browsing this thread: 1 Guest(s)