在工作表中添加图表

此 REST API 表示向工作表添加新图表。

重新设置 API

 
PUT http://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/charts

请求参数为：

参数名称	类型	路径/查询字符串/HTTPBody	描述
姓名	细绳	小路	工作簿名称。
工作表名称	细绳	小路	工作表名称。
图表类型	细绳	询问	图表类型，请参考图表资源中的属性Type。
左上行	整数	询问	0
左上列	整数	询问	0
右下行	整数	询问	0
右下列	整数	询问	0
区域	细绳	询问	指定绘制数据系列所依据的值。
垂直	布尔值	询问	真的
类别数据	细绳	询问	获取或设置分类轴值的范围。可以是单元格区域（例如“d1:e10”）。
isAutoGetSerialName	布尔值	询问	真的
标题	细绳	询问	指定图表标题名称。
文件夹	细绳	询问	工作簿文件夹。
存储名称	细绳	询问	存储名称。
数据标签	布尔值	询问	真的
数据标签位置	细绳	询问	多于
数据透视表	细绳	询问
枢轴表名称	细绳	询问

这OpenAPI规范定义一个可公开访问的编程接口，并允许您直接从 Web 浏览器执行 REST 交互。

您可以使用 cURL 命令行工具轻松访问 Aspose.Cells 的 Web 服务。以下示例展示了如何使用 cURL 调用云端 API。

Request


curl  -v "http://api.aspose.com/v3.0/cells/myWorkbook.xlsx/worksheets/Sheet1/charts?chartType=Bar&area=B1:F2&title=SalesState" 
-X PUT
-H "Content-Type: application/json" \
-H "Accept: application/json" \
-H "Authorization: Bearer <jwt token>"

Response


{

  "Code": "200",

  "Status": "OK"

}

Cloud SDK 系列

使用 SDK 是加速开发的最佳方式。SDK 负责处理底层细节，让您专注于项目任务。请查看GitHub 存储库以获取 Aspose.Cells Cloud SDKs 的完整列表。

以下代码示例演示了如何使用各种 SDK 调用 Aspose.Cells Web 服务：

	// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
	namespace Aspose.Cells.Cloud.SDK.Example
	{
	using Aspose.Cells.Cloud.SDK.Api;
	using Aspose.Cells.Cloud.SDK.Request;
	using System;

	public partial class CellsApiExample
	{
	public void PutWorksheetAddChartExample()
	{
	string CellsCloudClientId ="....";//get from https://dashboard.aspose.cloud/#/applications
	string CellsCloudClientSecret="...";//get from https://dashboard.aspose.cloud/#/applications
	PutWorksheetAddChartRequest request = new PutWorksheetAddChartRequest { name = "Book1.xlsx", sheetName = "Sheet4",
	chartType="pie",
	upperLeftRow = 5,
	upperLeftColumn = 5,
	lowerRightRow = 10,
	lowerRightColumn = 10,
	area = "C7:D11",
	isVertical = true, folder = "TestData/In" };
	cellsApi.PutWorksheetAddChart(request);
	}
	}
	}
	// Obsolet
	//CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
	//string name = MYDOC;
	//string sheetName = SHEET4;
	//string chartType = "Pie";
	//int? upperLeftRow = 5;
	//int? upperLeftColumn = 5;
	//int? lowerRightRow = 10;
	//int? lowerRightColumn = 10;
	//string area = "C7:D11";
	//bool? isVertical = true;
	//string categoryData = null;
	//bool? isAutoGetSerialName = null;
	//string title = null;
	//string folder = TEMPFOLDER;
	//instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
	//var response = instance.CellsChartsPutWorksheetAddChart(name, sheetName, chartType, upperLeftRow, upperLeftColumn, lowerRightRow, lowerRightColumn, area, isVertical, categoryData, isAutoGetSerialName, title, folder);
	//Assert.IsInstanceOf<ChartsResponse>(response, "response is ChartsResponse");
	//Assert.AreEqual(response.Code, 200);

view raw Examples-DotNET-CSharp-Charts-AddChart-1.cs hosted with ❤ by GitHub

Java

	// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
	try {
	CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl"));
	String remoteFolder = "TestData/";
	String localName = "Book1.xlsx";
	String remoteName = "Book1.xlsx";
	PutWorksheetAddChartRequest request = new PutWorksheetAddChartRequest();
	request.setName("myDocument.xlsx");
	request.setSheetName("Sheet3");
	request.setChartType("pie");
	request.setUpperLeftRow(5);
	request.setUpperLeftColumn(5);
	request.setLowerRightRow(10);
	request.setLowerRightColumn(10);
	request.setArea("C7:D11");
	request.setIsVertical(true);
	request.setCategoryData("");
	request.setIsAutoGetSerialName(false);
	request.setTitle("");
	request.setDataLabels(false);
	request.setDataLabelsPosition("");
	request.setPivotTableSheet("");
	request.setPivotTableName("");
	request.setFolder(remoteFolder);
	request.setStorageName("");

	CellsCloudResponse response = api.putWorksheetAddChart(request);

	} catch (Exception ex) {
	ex.printStackTrace();
	}

view raw Examples-Java-chart-AddChart-1.java hosted with ❤ by GitHub

PHP

	// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
	<?php
	require_once('vendor\autoload.php');
	use \Aspose\Cells\Cloud\Api\CellsApi;
	use \Aspose\Cells\Cloud\Request\PutWorksheetChartRequest;

	class Chart {

	public $instance;

	public function __construct() {
	$this->instance = new CellsApi(getenv("CellsCloudClientId"),getenv("CellsCloudClientSecret"),"v3.0",getenv("CellsCloudApiBaseUrl"));
	}

	public function putWorksheetAddChart() {
	$remoteFolder = "TestData/In";

	$localName = "Book1.xlsx";
	$remoteName = "Book1.xlsx";
	$request = new PutWorksheetChartRequest();
	$request->setName( $remoteName);
	$request->setSheetName( "Sheet4");
	$request->setChartType( "Pie");
	$request->setUpperLeftRow( 5);
	$request->setUpperLeftColumn( 5);
	$request->setLowerRightRow( 10);
	$request->setLowerRightColumn( 10);
	$request->setArea( "C7:D11");
	$request->setIsVertical( 'true');
	$request->setTitle( "Aspose Chart");
	$request->setFolder( $remoteFolder);
	$request->setStorageName( "");
	$this->instance->putWorksheetChart($request);
	}
	}

	$instance = new Chart();
	$instance->putWorksheetAddChart();

	?>

view raw Examples-PHP-Charts-PutWorksheetAddChart-.php hosted with ❤ by GitHub

Ruby

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-ruby
	require 'aspose_cells_cloud'

	class Chart

	include AsposeCellsCloud

	def initialize
	#Get client_id and client_secret from https://cloud.aspose.com

	@instance = AsposeCellsCloud::CellsApi.new($client_id,$client_secret,$api_version,$baseurl)
	end
	# Add new chart to worksheet.
	def add_new_chart_to_worksheet
	name = $MYDOC
	sheet_name = $SHEET3
	chart_type = 'Pie'
	upper_left_row = 5
	upper_left_column = 5
	lower_right_row = 10
	lower_right_column = 10
	area = $CELLAREA
	is_vertical = true
	category_data = nil
	is_auto_get_serial_name = nil
	title = nil
	folder = $TEMPFOLDER
	result = @instance.upload_file( folder+"/"+name, ::File.open(File.expand_path("data/"+name),"r") {\|io\| io.read(io.size) })
	expect(result.uploaded.size).to be > 0
	result = @instance.cells_charts_put_worksheet_add_chart(name, sheet_name, chart_type, { :upper_left_row=>upper_left_row, :upper_left_column=>upper_left_column, :lower_right_row=>lower_right_row, :lower_right_column=>lower_right_column, :area=>area, :is_vertical=>is_vertical, :folder=>folder})
	expect(result.code).to eql(200)
	end

	end

	chart = Chart.new()
	puts chart.add_new_chart_to_worksheet

view raw Examples-Ruby-Charts-add_new_chart_to_worksheet-.rb hosted with ❤ by GitHub

Python

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.requests import *

	CellsCloudClientId ='....' # get from https://dashboard.aspose.cloud/#/applications
	CellsCloudClientSecret='....' # get from https://dashboard.aspose.cloud/#/applications
	api = CellsApi(CellsCloudClientId,CellsCloudClientSecret)
	request = PutWorksheetChartRequest( 'myDocument.xlsx', 'Sheet3', 'Pie' ,upper_left_row= 5,upper_left_column= 5,lower_right_row= 10,lower_right_column= 10,area= 'C7:D11',is_vertical= True,title= 'Aspose Chart',folder= 'PythonTest',storage_name= '')
	api.put_worksheet_chart(request)

view raw AddChartToWorksheet.py hosted with ❤ by GitHub

Node.js

	// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
	import { expect } from "chai";
	import "mocha";

	import * as model from "../src/model/model";
	import * as BaseTest from "./baseTest";
	var fs = require('fs');

	describe('cellsChartsPutWorksheetAddChart', function() {
	it('should call cellsChartsPutWorksheetAddChart successfully', function() {
	const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
	const filename = "myDocument.xlsx";
	var data =fs.createReadStream(localPath + filename);
	var req = new model.UploadFileRequest();
	req.path = "Temp/" + filename;
	req.file = data;

	return cellsApi.uploadFile(req)
	.then((result) => {
	expect(result.body.uploaded.length).greaterThan(0);
	var req = new model.CellsCharts_PutWorksheetAddChartRequest();
	req.name = filename;
	req.sheetName = "Sheet4";
	req.chartType = "Pie";
	req.upperLeftRow = 5;
	req.upperLeftColumn = 5;
	req.lowerRightRow = 10;
	req.lowerRightColumn = 10;
	req.area = "C7:D11";
	req.isVertical = true;
	req.isAutoGetSerialName = null;
	req.folder = "Temp";

	return cellsApi.cellsChartsPutWorksheetAddChart(req)
	.then((result) => {
	expect(result.body.code).to.equal(200);
	expect(result.response.statusCode).to.equal(200);
	});
	});
	});
	});

view raw Examples-Node.js-SDK-Charts-AddChart-1.js hosted with ❤ by GitHub

Objective C

Perl

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-perl/
	use strict;
	use warnings;
	use utf8;
	use File::Slurp;
	use MIME::Base64;
	use AsposeCellsCloud::CellsApi;
	my $config = AsposeCellsCloud::Configuration->new( client_id => $ENV{'ProductClientId'}, client_secret => $ENV{'ProductClientSecret'});
	my $instance = AsposeCellsCloud::CellsApi->new(AsposeCellsCloud::ApiClient->new( $config));


	my $remoteFolder = 'TestData/In';
	my $remoteName = 'Book1.xlsx';
	my $request = AsposeCellsCloud::Request::PutWorksheetAddChartRequest->new();
	$request->{name} = $remoteName;
	$request->{sheet_name} = 'Sheet4';
	$request->{chart_type} = 'Pie';
	$request->{upper_left_row} = 5;
	$request->{upper_left_column} = 5;
	$request->{lower_right_row} = 10;
	$request->{lower_right_column} = 10;
	$request->{area} = 'C7:D11';
	$request->{is_vertical} = 'true';
	$request->{title} = 'Aspose Chart';
	$request->{folder} = $remoteFolder;
	$request->{storage_name} = '';
	my $result = $api->put_worksheet_add_chart(request=> $request);

view raw Examples-Perl-Charts-AddChart-1.pl hosted with ❤ by GitHub

Android

从工作表获取图表从工作表中删除所有图表