إضافة مخطط في ورقة عمل

يشير REST API إلى إضافة مخطط جديد إلى ورقة العمل.

رسيت API

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

معلمات الطلب هي:

اسم المعلمة	يكتب	المسار/سلسلة الاستعلام/HTTPBody	وصف
اسم	خيط	طريق	اسم المصنف.
اسم الورقة	خيط	طريق	اسم ورقة العمل.
نوع التخطيط	خيط	استفسار	نوع الرسم البياني، يرجى الرجوع إلى الخاصية اكتب مورد الرسم البياني.
UpperLeftRow	عدد صحيح	استفسار	0
UpperLeftColumn	عدد صحيح	استفسار	0
LowerRightRow	عدد صحيح	استفسار	0
LowerRightColumn	عدد صحيح	استفسار	0
منطقة	خيط	استفسار	يحدد القيم التي سيتم من خلالها رسم سلسلة البيانات.
isVertical	منطقية	استفسار	حقيقي
classData	خيط	استفسار	الحصول على نطاق قيم محور الفئة أو تعيينه. ويمكن أن يكون نطاقًا من الخلايا (مثل “d1:e10”).
isAutoGetSerialName	منطقية	استفسار	حقيقي
عنوان	خيط	استفسار	يحدد اسم عنوان المخطط.
مجلد	خيط	استفسار	مجلد المصنف.
اسم التخزين	خيط	استفسار	اسم التخزين.
dataLabels	منطقية	استفسار	حقيقي
dataLabelsPosition	خيط	استفسار	فوق
PivotTableSheet	خيط	استفسار
PivotTableName	خيط	استفسار

المواصفات OpenAPI يحدد واجهة برمجة يمكن الوصول إليها بشكل عام ويتيح لك تنفيذ تفاعلات REST مباشرة من متصفح الويب.

يمكنك استخدام أداة سطر الأوامر cURL للوصول إلى خدمات الويب Aspose.Cells بسهولة. يوضح المثال التالي كيفية إجراء مكالمات إلى Cloud API مع cURL.

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 بالتفاصيل ذات المستوى المنخفض وتتيح لك التركيز على مهام مشروعك. يرجى التحقق منمستودع جيثب للحصول على قائمة كاملة بـ Aspose.Cells Cloud SDKs.

توضح أمثلة التعليمات البرمجية التالية كيفية إجراء مكالمات إلى خدمات الويب Aspose.Cells باستخدام مجموعات تطوير البرامج (SDK) المتنوعة:

	// 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()
	{
	CellsApi cellsApi = new CellsApi(Environment.GetEnvironmentVariable("CellsCloudTestClientId"), Environment.GetEnvironmentVariable("CellsCloudTestClientSecret"));
	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 *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	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

الحصول على مخطط من ورقة عمل حذف كافة المخططات من ورقة عمل