Module: Asposeslidesjava::ExistingChart

Defined in:
lib/asposeslidesjava/Charts/existingchart.rb

Instance Method Summary collapse

Instance Method Details

#initialize ⇒ Object 



3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
 
# File 'lib/asposeslidesjava/Charts/existingchart.rb', line 3

def initialize()
    data_dir = File.dirname(File.dirname(File.dirname(File.dirname(__FILE__)))) + '/data/'
            
    # Instantiate Presentation class that represents the presentation file
    pres = Rjb::import('com.aspose.slides.Presentation').new(data_dir+ "AsposeChart.pptx")

    # Access first slide
    sld = pres.getSlides().get_Item(0)

    # Add chart with default data
    chart = sld.getShapes().get_Item(0)

    # Setting the index of chart data sheet
    defaultWorksheetIndex = 0

    # Getting the chart data worksheet
    fact = chart.getChartData().getChartDataWorkbook()

    # Changing chart Category Name
    fact.getCell(defaultWorksheetIndex, 1, 0, "Modified Category 1")
    fact.getCell(defaultWorksheetIndex, 2, 0, "Modified Category 2")


    # Take first chart series
    series = chart.getChartData().getSeries().get_Item(0)

    # Now updating series data
    fact.getCell(defaultWorksheetIndex, 0, 1, "New_Series1") # modifying series name
    series.getDataPoints().get_Item(0).getValue().setData(90)
    series.getDataPoints().get_Item(1).getValue().setData(123)
    series.getDataPoints().get_Item(2).getValue().setData(44)

    # Take Second chart series
    series = chart.getChartData().getSeries().get_Item(1)

    # Now updating series data
    fact.getCell(defaultWorksheetIndex, 0, 2, "New_Series2") #modifying series name
    series.getDataPoints().get_Item(0).getValue().setData(23)
    series.getDataPoints().get_Item(1).getValue().setData(67)
    series.getDataPoints().get_Item(2).getValue().setData(99)


    # Now, Adding a new series
    chart.getChartData().getSeries().add(fact.getCell(defaultWorksheetIndex, 0, 3, "Series 3"), chart.getType())

    # Take 3rd chart series
    series = chart.getChartData().getSeries().get_Item(2)

    # Now populating series data
    series.getDataPoints().addDataPointForBarSeries(fact.getCell(defaultWorksheetIndex, 1, 3, 20))
    series.getDataPoints().addDataPointForBarSeries(fact.getCell(defaultWorksheetIndex, 2, 3, 50))
    series.getDataPoints().addDataPointForBarSeries(fact.getCell(defaultWorksheetIndex, 3, 3, 30))

    chart.setType(Rjb::import('com.aspose.slides.ChartType').ClusteredCylinder)


    # Saving the presentation to HTML format
    save_format = Rjb::import('com.aspose.slides.SaveFormat')
    pres.save(data_dir + "AsposeChartModified.pptx", save_format.Pptx)

    puts "Updated chart, please check the output file."
end