Home forums Using CanvasJS Export chart to excel and edit data in excel to see changes in chart in excel?

This topic contains 4 replies, has 2 voices, and was last updated by  Indranil Deo 2 months, 3 weeks ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #24395

    Can i export chart to excel and get it along with data such that i can edit data and see changes in the chart and vice versa? I can do it in python by selecting a csv file and adding the data along with its chart(not image) to an excel file and modify as needed. can we do such thing with canvasjs or javascript/jquery in general?

    I am attaching the screenshot of excel i want to have that i generated using python xlsxwriter and pandas.
    Excel generated from csv using python

    #24396

    https://ibb.co/CwpqyPj

    This is link to image.

    #24428

    @venkateshganu,

    It is possible to export the chart data in CSV format as shown in this jsfiddle, but rendering and updating the chart within excel is not possible as of now.

    ___________
    Indranil Deo,
    Team CanvasJS

    #24493

    Thank you for the reply. Can i atleast copy the generated canvas as image into an excel file. I can convert the canvas to image and display it on the website but i want the image to be copied to an excel file along with the table data. The image is encoded and is not getting displayed in excel and instead i get a red X sign. Is it possible to export the canvas as image to an excel file?

    #24514

    @venkateshganu,

    This feature is not available inbuilt. However, you can use any third party plugin like SheetJS to achieve this functionality. Please check their website for more information. Also, you can refer to this example to export the chart data in .xlsx format using SheetJS.

    ___________
    Indranil Deo,
    Team CanvasJS

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.