Rich-Text-Formatierung auf eine Cel anwenden

Dieser REST API gibt an, rich text formatting auf eine Zelle in einer Excel-Datei anzuwenden.

RSET API

 
POST http://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/cells/{cellName}/characters

Die Anforderungsparameter sind:

Parametername	Typ	Pfad/Abfragezeichenfolge/HTTPBody	Beschreibung
Name	Schnur	Weg
Blattname	Schnur	Weg
Zellname	Schnur	Weg
Optionen		Körper
Ordner	Schnur	Abfrage
Speichername	Schnur	Abfrage	Speichername.

DerOpenAPI-Spezifikation definiert eine öffentlich zugängliche Programmierschnittstelle und ermöglicht Ihnen, REST-Interaktionen direkt von einem Webbrowser aus durchzuführen.

Mit dem Befehlszeilentool cURL können Sie ganz einfach auf die Webdienste Aspose.Cells zugreifen. Das folgende Beispiel zeigt, wie Sie mit cURL Anrufe an Cloud API tätigen.

Request

 
curl -v "http://api.aspose.cloud/v3.0/cells/Book1.xlsx/worksheets/Sheet1/cells/A1/characters" \
-X POST \
-d "{ \"FontSetting\": [ { \"Font\": { \"IsBold\": \"true\", \"Size\": \"24\" }, \"Length\": \"5\", \"StartIndex\": \"0\" }, { \"Font\": { \"IsItalic\": \"true\", \"Size\": \"15\" }, \"Length\": \"4\", \"StartIndex\": \"5\" } ] }" \
-H "Content-Type: application/json" \
-H "Accept: application/json" \
-H "Authorization: Bearer <jwt token>"

Response

{
"Code": 200,
"Status": "OK"
}

Cloud SDK-Familie

Die Verwendung eines SDK ist der beste Weg, um die Entwicklung zu beschleunigen. Ein SDK kümmert sich um Details auf niedriger Ebene und ermöglicht es Ihnen, sich auf Ihre Projektaufgaben zu konzentrieren. Bitte lesen Sie dieGitHub-Repository für eine vollständige Liste der Aspose.Cells Cloud SDKs.

Die folgenden Codebeispiele zeigen, wie Sie mit verschiedenen SDKs Aufrufe an die Webdienste Aspose.Cells tätigen:

	// 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.Model;
	using Aspose.Cells.Cloud.SDK.Request;
	using System;
	using System.Collections.Generic;

	public partial class CellsApiExample
	{
	public void PostCellCharactersExample()
	{
	string CellsCloudClientId ="....";//get from https://dashboard.aspose.cloud/#/applications
	string CellsCloudClientSecret="...";//get from https://dashboard.aspose.cloud/#/applications
	List<FontSetting> options = new List<FontSetting>();
	Font font = new Font();
	font.Size = 10;
	FontSetting fs1 = new FontSetting();
	fs1.Font = font;
	fs1.Length = 2;
	fs1.StartIndex = 0;
	options.Add(fs1);
	PostCellCharactersRequest request = new PostCellCharactersRequest { name = "Book1.xlsx", sheetName ="Sheet1", cellName ="A1", options = options, folder = "TestData/In" };
	cellsApi.PostCellCharacters(request);
	}
	}
	}
	// Obsolet
	//CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
	//string name = BOOK1;
	//string sheetName = SHEET2;
	//string cellName = "G8";
	//List<FontSetting> options = new List<FontSetting>();
	//Font font = new Font();
	//font.Size = 10;
	//FontSetting fs1 = new FontSetting();
	//fs1.Font = font;
	//fs1.Length = 2;
	//fs1.StartIndex = 0;
	//options.Add(fs1);
	//string folder = TEMPFOLDER;
	//instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
	//var response = instance.CellsPostCellCharacters(name, sheetName, cellName, options, folder);
	//Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
	//Assert.AreEqual(response.Status, "OK");

view raw Examples-DotNet-CSharp-Cells-ApplyRichTextFormatting-1.cs 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\PostCellCharactersRequest;
	class Cell {

	public $instance;

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

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

	$localName = "Book1.xlsx";
	$remoteName = "Book1.xlsx";

	$optionsvalue0Font = new \Aspose\Cells\Cloud\Model\Font();
	$optionsvalue0Font->setIsBold('true' );
	$optionsvalue0Font->setSize(16 );
	$optionsvalue0 = new \Aspose\Cells\Cloud\Model\FontSetting();
	$optionsvalue0->setLength(5 );
	$optionsvalue0->setStartIndex(0 );
	$optionsvalue0->setFont($optionsvalue0Font );
	$options = array (
	$optionsvalue0
	);
	$request = new PostCellCharactersRequest();
	$request->setName( $remoteName);
	$request->setSheetName( "Sheet1");
	$request->setCellName( "E36");
	$request->setOptions( $options);
	$request->setFolder( $remoteFolder);
	$request->setStorageName( "");
	$this->instance->postCellCharacters($request);
	}
	}

	$instance = new Cell();
	$instance->postCellTextFormatting();

	?>

view raw Examples-PHP-Cells-PostCellTextFormatting-.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 Cell

	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

	def upload_file(file_name)

	response = @cells_api.put_create(file_name, File.open("../../../data/" << file_name,"r") { \|io\| io.read } )
	end

	# Rich text formatting in a single cell.
	def post_cell_text_formatting
	file_name = "Book1.xlsx"
	upload_file(file_name)
	sheet_name = "sheet1"
	cell_name = "A1"

	# Set cell value
	response = @cells_api.post_worksheet_cell_set_value(file_name, sheet_name, cell_name, {value: "121211212112", type: "string"})

	fontSetting1 = FontSetting.new
	fontSetting1.length = 5
	fontSetting1.start_index = 0
	font1 = Font.new
	font1.is_bold = true
	font1.size = 24
	fontSetting1.font = font1

	fontSetting2 = FontSetting.new
	fontSetting2.length = 4
	fontSetting2.start_index = 5
	font2 = Font.new
	font2.is_italic = true
	font2.size = 15
	fontSetting2.font = font2

	options = [fontSetting1, fontSetting2]

	# Rich text formatting in a single cell
	response = @cells_api.post_cell_text_formatting(file_name, sheet_name, cell_name, options, opts = {})
	end

	end

	cell = Cell.new()
	puts cell.post_cell_text_formatting

view raw Examples-Ruby-Cells-post_cell_text_formatting-.rb 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/
	const { CellsApi,UploadFileRequest, Cells_PostCellCharactersRequest,Font ,FontSetting } = require("asposecellscloud");
	const clientId = process.env.CellsCloudClientId;
	const clientSecret = process.env.CellsCloudClientSecret;
	const ApiURL = process.env.CellsCloudApiBaseUrl;
	const CellsApi = new CellsApi(clientId, clientSecret,"v3.0",ApiURL);
	const fs = require('fs');
	const path = require('path');
	const localPath = "D:/aspose-cells-cloud-node/TestData/"
	const filename = "Book1.xlsx";
	const data =fs.createReadStream(path.join(localPath, filename));
	const req = new model.UploadFileRequest();
	req.path = "Temp/" + filename;
	req.file = data;
	CellsApi.uploadFile(req)
	.then((result) => {

	const req = new model.Cells_PostCellCharactersRequest();
	req.name = filename;
	req.cellName = "G8";
	req.sheetName = "Sheet2";
	req.folder = "Temp";

	const font = new Font();
	font.size = 10;
	const fs1 = new FontSetting();
	fs1.font = font;
	fs1.length = 2;
	fs1.startIndex = 0;

	const options = new Array<FontSetting>();
	options.push(fs1);
	req.options = options;
	cellsApi.cellsPostCellCharacters(req)
	.then((result) => {
	console.log("successfully");
	});

	})
	.catch((error) => {
	console.error('Unhandled Promise Rejection:', error);
	});

view raw Examples-Node.js-SDK-Cells-ApplyRichTextFormatting-1.js hosted with ❤ by GitHub

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 $optionsvalue0_font = AsposeCellsCloud::Object::Font->new();
	$optionsvalue0_font->{is_bold} = 'true' ;
	$optionsvalue0_font->{size} = 16 ;
	my $optionsvalue0 = AsposeCellsCloud::Object::FontSetting->new();
	$optionsvalue0->{length} = 5 ;
	$optionsvalue0->{start_index} = 0 ;
	$optionsvalue0->{font} = $optionsvalue0_font ;
	my @options = [];push (@options ,$optionsvalue0 );
	my $request = AsposeCellsCloud::Request::PostCellCharactersRequest->new();
	$request->{name} = $remoteName;
	$request->{sheet_name} = 'Sheet1';
	$request->{cell_name} = 'E36';
	$request->{options} = []; push ( @{$request->{options}}, $optionsvalue0 );;
	$request->{folder} = $remoteFolder;
	$request->{storage_name} = '';
	my $result = $api->post_cell_characters(request=> $request);

view raw Examples-Perl-Cells-ApplyRichTextFormatting-1.pl hosted with ❤ by GitHub

Zellenstil im Arbeitsblatt Excel ändern Klare Inhalte und Stile von Cells im Arbeitsblatt Excel