圖表是簡潔顯示數(shù)據(jù)的絕佳工具。此外，它們以可視方式表示數(shù)據(jù)，從而更易于使用大量數(shù)據(jù)。在需要顯示數(shù)據(jù)（例如每月預算比較或產品采用率）的情況下，圖表可能會有所幫助。有鑒于此，本文將教您如何使用C ++在Excel文件中創(chuàng)建圖表。

• 使用C ++在Excel中創(chuàng)建折線圖
• 使用C ++在Excel中創(chuàng)建金字塔圖
• 使用C ++在Excel中創(chuàng)建氣泡圖

Aspose.Cells for C++是本機C ++庫，使用它可以創(chuàng)建，讀取和修改Excel文件，而無需安裝Microsoft Excel。該API還支持在Excel文件中創(chuàng)建圖表。

下載Aspose.Cells for C++最新版

使用C ++在Excel中創(chuàng)建折線圖

若要創(chuàng)建折線圖，請在添加圖表時使用ChartType_Line枚舉值。以下是在Excel文件中創(chuàng)建折線圖的步驟。

• 首先，創(chuàng)建一個IWorkbook類的實例。
• 使用IWorkbook->GetIWorksheets()->GetObjectByIndex (Aspose::Cells::Systems::Int32 index)方法檢索要添加圖表的工作表。
• 插入圖表的數(shù)據(jù)。
• 使用IWorksheet->GetICharts()->Add(Aspose::Cells::Charts::ChartType type,Aspose::Cells::Systems::Int32 upperLeftRow,Aspose::Cells::Systems::Int32 upperLeftColumn,Aspose::Cells::Systems::Int32 lowerRightRow,Aspose::Cells::Systems::Int32 lowerRightColumn)方法將圖表添加到工作表中。
• 使用IWorksheet->GetICharts()->GetObjectByIndex (Aspose::Cells::Systems::Int32 index)方法訪問圖表及其索引。
• 使用 IChart->GetNISeries()->Add (intrusive_ptrarea, bool isVertical)方法為圖表添加數(shù)據(jù)源。
• 最后，使用IWorkbook->Save(intrusive_ptrfileName)方法保存Excel文件。

以下是使用C ++在Excel中創(chuàng)建折線圖的示例代碼。

// Output directory path.
StringPtr outDir = new String("OutputDirectory\\");

// Path of output excel file
StringPtr outputChartTypeLine = outDir->StringAppend(new String("outputChartTypeLine.xlsx"));

// Create a new workbook
intrusive_ptrworkbook = Factory::CreateIWorkbook();

// Get first worksheet which is created by default
intrusive_ptrworksheet = workbook->GetIWorksheets()->GetObjectByIndex(0);

// Adding sample values to cells
worksheet->GetICells()->GetObjectByIndex(new String("A1"))->PutValue(50);
worksheet->GetICells()->GetObjectByIndex(new String("A2"))->PutValue(100);
worksheet->GetICells()->GetObjectByIndex(new String("A3"))->PutValue(150);
worksheet->GetICells()->GetObjectByIndex(new String("B1"))->PutValue(4);
worksheet->GetICells()->GetObjectByIndex(new String("B2"))->PutValue(20);
worksheet->GetICells()->GetObjectByIndex(new String("B3"))->PutValue(50);

// Adding a chart to the worksheet
int chartIndex = worksheet->GetICharts()->Add(Aspose::Cells::Charts::ChartType::ChartType_Line, 5, 0, 20, 8);

// Accessing the instance of the newly added chart
intrusive_ptrchart = worksheet->GetICharts()->GetObjectByIndex(chartIndex);

// Adding SeriesCollection (chart data source) to the chart ranging from "A1" cell to "B3"
chart->GetNISeries()->Add(new String("A1:B3"), true);

// Saving the Excel file
workbook->Save(outputChartTypeLine);

使用C ++在Excel中創(chuàng)建金字塔圖

若要創(chuàng)建金字塔形圖，請在添加統(tǒng)計圖時使用ChartType_Pyramid枚舉值指定統(tǒng)計圖類型。以下是在Excel文件中創(chuàng)建金字塔圖的步驟。

• 首先，創(chuàng)建一個IWorkbook類的實例。
• 使用IWorkbook->GetIWorksheets()->GetObjectByIndex (Aspose::Cells::Systems::Int32 index)方法檢索要添加圖表的工作表。
• 插入圖表的數(shù)據(jù)。
• 使用IWorksheet->GetICharts()->Add(Aspose::Cells::Charts::ChartType type,Aspose::Cells::Systems::Int32 upperLeftRow,Aspose::Cells::Systems::Int32 upperLeftColumn,Aspose::Cells::Systems::Int32 lowerRightRow,Aspose::Cells::Systems::Int32 lowerRightColumn)方法將圖表添加到工作表中。
• 使用IWorksheet->GetICharts()->GetObjectByIndex (Aspose::Cells::Systems::Int32 index)方法訪問圖表及其索引。
• 使用 IChart->GetNISeries()->Add (intrusive_ptrarea, bool isVertical)方法為圖表添加數(shù)據(jù)源。
• 最后，使用IWorkbook->Save(intrusive_ptrfileName)方法保存Excel文件。

以下是使用C ++在Excel中創(chuàng)建金字塔圖的示例代碼。

// Output directory path.
StringPtr outDir = new String("OutputDirectory\\");

// Path of output excel file
StringPtr outputChartTypePyramid = outDir->StringAppend(new String("outputChartTypePyramid.xlsx"));

// Create a new workbook
intrusive_ptrworkbook = Factory::CreateIWorkbook();

// Get first worksheet which is created by default
intrusive_ptrworksheet = workbook->GetIWorksheets()->GetObjectByIndex(0);

// Adding sample values to cells
worksheet->GetICells()->GetObjectByIndex(new String("A1"))->PutValue(50);
worksheet->GetICells()->GetObjectByIndex(new String("A2"))->PutValue(100);
worksheet->GetICells()->GetObjectByIndex(new String("A3"))->PutValue(150);
worksheet->GetICells()->GetObjectByIndex(new String("B1"))->PutValue(4);
worksheet->GetICells()->GetObjectByIndex(new String("B2"))->PutValue(20);
worksheet->GetICells()->GetObjectByIndex(new String("B3"))->PutValue(50);

// Adding a chart to the worksheet
int chartIndex = worksheet->GetICharts()->Add(Aspose::Cells::Charts::ChartType::ChartType_Pyramid, 5, 0, 20, 8);

// Accessing the instance of the newly added chart
intrusive_ptrchart = worksheet->GetICharts()->GetObjectByIndex(chartIndex);

// Adding SeriesCollection (chart data source) to the chart ranging from "A1" cell to "B3"
chart->GetNISeries()->Add(new String("A1:B3"), true);

// Saving the Excel file
workbook->Save(outputChartTypePyramid);

使用C ++在Excel中創(chuàng)建氣泡圖

為了創(chuàng)建一個氣泡圖，該傳ChartType_Bubble枚舉值到IWorksheet-> GetICharts（） - >添加（）方法。以下是在Excel文件中創(chuàng)建氣泡圖的步驟。

• 首先，創(chuàng)建一個IWorkbook類的實例。
• 使用IWorkbook-> GetIWorksheets（）-> GetObjectByIndex（Aspose :: Cells :: Systems :: Int32索引）方法檢索要在其中添加圖表的工作表。
• 插入圖表的數(shù)據(jù)。
• 使用IWorksheet-> GetICharts（）-> Add將圖表添加到工作表中（Aspose :: Cells :: Charts :: ChartType類型，Aspose :: Cells :: Systems :: Int32 upperLeftRow，Aspose :: Cells :: Systems： ：Int32 upperLeftColumn，Aspose :: Cells :: Systems :: Int32 lowerRightRow，Aspose :: Cells :: Systems :: Int32 lowerRightColumn）方法。
• 使用IWorksheet-> GetICharts（）-> GetObjectByIndex（Aspose :: Cells :: Systems :: Int32索引）方法訪問帶有索引的圖表。
• 使用 IChart->GetNISeries()->GetObjectByIndex(0)->SetBubbleSizes (intrusive_ptrarea, bool isVertical), IChart->GetNISeries()->GetObjectByIndex(0)->SetBubbleSizes (intrusive_ptr值）、ICchart->GetNISeries()->GetObjectByIndex(0)->SetXValues（intrusive_ptr值）、ICchart->GetNISeries()->GetObjectByIndex(0)->SetValues（intrusive_ptr值）方法分別設置。
• 最后，使用IWorkbook->Save(intrusive_ptrfileName)方法保存Excel文件。

以下是使用C ++在Excel中創(chuàng)建氣泡圖的示例代碼。

// Output directory path.
StringPtr outDir = new String("OutputDirectory\\");

// Path of output excel file
StringPtr outputChartTypeBubble = outDir->StringAppend(new String("outputChartTypeBubble.xlsx"));

// Create a new workbook
intrusive_ptrworkbook = Factory::CreateIWorkbook();

// Get first worksheet which is created by default
intrusive_ptrworksheet = workbook->GetIWorksheets()->GetObjectByIndex(0);

// Fill in data for chart's series
// Y Values
worksheet->GetICells()->GetObjectByIndex(0, 0)->PutValue((StringPtr)new String("Y Values"));
worksheet->GetICells()->GetObjectByIndex(0, 1)->PutValue(2);
worksheet->GetICells()->GetObjectByIndex(0, 2)->PutValue(4);
worksheet->GetICells()->GetObjectByIndex(0, 3)->PutValue(6);
// Bubble Size
worksheet->GetICells()->GetObjectByIndex(1, 0)->PutValue((StringPtr)new String("Bubble Size"));
worksheet->GetICells()->GetObjectByIndex(1, 1)->PutValue(2);
worksheet->GetICells()->GetObjectByIndex(1, 2)->PutValue(3);
worksheet->GetICells()->GetObjectByIndex(1, 3)->PutValue(1);
// X Values
worksheet->GetICells()->GetObjectByIndex(2, 0)->PutValue((StringPtr)new String("X Values"));
worksheet->GetICells()->GetObjectByIndex(2, 1)->PutValue(1);
worksheet->GetICells()->GetObjectByIndex(2, 2)->PutValue(2);
worksheet->GetICells()->GetObjectByIndex(2, 3)->PutValue(3);

// Set first column width
worksheet->GetICells()->SetColumnWidth(0, 12);

// Adding a chart to the worksheet
int chartIndex = worksheet->GetICharts()->Add(Aspose::Cells::Charts::ChartType::ChartType_Bubble, 5, 0, 20, 8);

// Accessing the instance of the newly added chart
intrusive_ptrchart = worksheet->GetICharts()->GetObjectByIndex(chartIndex);

// Adding SeriesCollection (chart data source) to the chart ranging from B1 to D1
chart->GetNISeries()->Add(new String("B1:D1"), true);

// Set bubble sizes
chart->GetNISeries()->GetObjectByIndex(0)->SetBubbleSizes(new String("B2:D2"));

// Set X axis values
chart->GetNISeries()->GetObjectByIndex(0)->SetXValues(new String("B3:D3"));

// Set Y axis values
chart->GetNISeries()->GetObjectByIndex(0)->SetValues(new String("B1:D1"));

// Saving the Excel file
workbook->Save(outputChartTypeBubble);

如果你想試用Aspose的全部完整功能，可聯(lián)系在線客服獲取30天臨時授權體驗。