4 Replies - 367 Views - Last Post: 20 February 2020 - 12:42 AM Rate Topic: -----

#1 SacPy   User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 26
  • Joined: 18-June 19

Can we import chart from Excel to Python

Posted 19 February 2020 - 05:31 AM

Hi,

I am trying to import Excel worksheet in Python for learning purpose.
I am using below code and this is working without any issues.

My excel file also has a chart in the same worksheet.
My doubt is, is it possible to import Chart from the excel to python.

#Import only one column from the worksheet
import pandas as MyPandas
MyExcel = MyPandas.read_excel (r'\\MyPath\Python Chart Data.xlsx', sheet_name='Sheet1')
MyOutput = MyPandas.DataFrame(MyData, columns= ['Name'])
print (MyOutput)



Is This A Good Question/Topic? 0
  • +

Replies To: Can we import chart from Excel to Python

#2 modi123_1   User is online

  • Suitor #2
  • member icon



Reputation: 15564
  • View blog
  • Posts: 62,309
  • Joined: 12-June 08

Re: Can we import chart from Excel to Python

Posted 19 February 2020 - 08:22 AM

Import a chart to where? Into what?
Was This Post Helpful? 1
  • +
  • -

#3 SacPy   User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 26
  • Joined: 18-June 19

Re: Can we import chart from Excel to Python

Posted 19 February 2020 - 08:46 AM

Hi modi123_1 sir, please pardon my ignorance. Am new to Python.
When I imported excel file in Python, results were reflecting in Console.

Same way, can we also import chart from Excel file in Console.
This was just out of curiosity. Good night.
Was This Post Helpful? 0
  • +
  • -

#4 modi123_1   User is online

  • Suitor #2
  • member icon



Reputation: 15564
  • View blog
  • Posts: 62,309
  • Joined: 12-June 08

Re: Can we import chart from Excel to Python

Posted 19 February 2020 - 08:54 AM

Again - what structure do you believe would hold the chart? How would that structure reference the data that makes up the chart? Most excel charts are not static drawings.
Was This Post Helpful? 1
  • +
  • -

#5 SacPy   User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 26
  • Joined: 18-June 19

Re: Can we import chart from Excel to Python

Posted 20 February 2020 - 12:42 AM

Hi modi123_1 sir, thanks for the help. Please give me some time to think over it.
To be honest, at present I have no idea. My only thought was, will it be possible to import chart also along with the data. Have a nice day ahead.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1