Добавить изображение в файл Excel

Этот REST API указывает на add новое изображение для рабочего листа Excel.

РСЕТ API

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

Параметры запроса:

Имя параметра	Тип	Путь/строка запроса/HTTPBody	Описание
имя	нить	путь	Имя рабочей книги.
имя листа	нить	путь	Имя рабочего листа.
картина		тело	Изображение объекта
верхний левый ряд	целое число	запрос	0
верхний левый столбец	целое число	запрос	0
нижний правый ряд	целое число	запрос	0
нижний правый столбец	целое число	запрос	0
картинкаПуть	нить	запрос	Путь к изображению, если он не указан, данные изображения проверяются в теле запроса.
папка	нить	запрос	Папка рабочей книги.
имя_хранилища	нить	запрос	имя хранилища.

Спецификация OpenAPI определяет общедоступный интерфейс программирования и позволяет выполнять взаимодействие с REST непосредственно из веб-браузера.

Вы можете использовать инструмент командной строки cURL для легкого доступа к веб-службам Aspose.Cells. В следующем примере показано, как позвонить на Cloud API с помощью cURL.

Request

 
curl -v "http://api.aspose.com/v1.1/cells/Sample_Test_Book.xls/worksheets/Sheet6/pictures?picturePath=aspose-cloud.png" \
-X PUT \
-H "Content-Type: application/json" \
-H "Accept: application/json" \
-H "Authorization: Bearer <jwt token>"

Response

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

Семейство облачных SDK

Использование SDK — лучший способ ускорить разработку. SDK заботится о деталях низкого уровня и позволяет вам сосредоточиться на задачах проекта. Пожалуйста, ознакомьтесь сРепозиторий GitHub для получения полного списка Aspose.Cells Cloud SDK.

Следующие примеры кода демонстрируют, как выполнять вызовы веб-служб 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 PutWorksheetAddPictureExample()
	{
	CellsApi cellsApi = new CellsApi(Environment.GetEnvironmentVariable("CellsCloudTestClientId"), Environment.GetEnvironmentVariable("CellsCloudTestClientSecret"));
	PutWorksheetAddPictureRequest request = new PutWorksheetAddPictureRequest
	{
	name = "Book1.xlsx",
	sheetName = "Sheet6",
	upperLeftRow = 1,
	upperLeftColumn = 1,
	lowerRightRow = 10,
	lowerRightColumn = 10,
	picturePath = "WaterMark.png",
	folder = "TestData/In"
	};
	cellsApi.PutWorksheetAddPicture(request);
	}
	}
	}

view raw Examples-DotNET-CSharp-Pictures-AddPicturesWorksheet-1.cs hosted with ❤ by GitHub

Java

	package com.aspose.cloud.cells.api;
	import com.aspose.cloud.cells.client.*;
	import com.aspose.cloud.cells.model.*;
	import com.aspose.cloud.cells.request.*;
	import java.io.IOException;
	import org.junit.Test;
	import java.util.ArrayList;
	import java.util.List;
	import java.io.File;
	import java.util.HashMap;

	public class Example {
	private CellsApi api;
	public Example(){
	try {
	api = new CellsApi(
	System.getenv("CellsCloudClientId"),
	System.getenv("CellsCloudClientSecret"),
	"v3.0",
	System.getenv("CellsCloudApiBaseUrl")
	);
	} catch (ApiException e) {
	e.printStackTrace();
	}
	}
	public void Run(){
	try{
	String remoteFolder = "TestData/In";

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

	UploadFileRequest uploadFileRequest = new UploadFileRequest();
	uploadFileRequest.setPath( remoteFolder + "/" + remoteName );
	uploadFileRequest.setStorageName( "");
	HashMap<String,File> files = new HashMap<String,File>();
	files.put( localName , new File(localName ));
	uploadFileRequest.setUploadFiles(files);
	api.uploadFile(uploadFileRequest);

	PutWorksheetAddPictureRequest request = new PutWorksheetAddPictureRequest();
	request.setName(remoteName);
	request.setSheetName("Sheet6");
	request.setPicture(null);
	request.setUpperLeftRow(1);
	request.setUpperLeftColumn(1);
	request.setLowerRightRow(10);
	request.setLowerRightColumn(10);
	request.setPicturePath("TestData/WaterMark.png");
	request.setFolder(remoteFolder);
	request.setStorageName("");

	CellsCloudResponse response = api.putWorksheetAddPicture(request);

	} catch (ApiException e) {
	e.printStackTrace();
	}catch (IOException e) {
	e.printStackTrace();
	}
	}
	}

view raw Examples-Java-pictures-AddPicturesWorksheet-add-pictures-worksheet.java hosted with ❤ by GitHub

PHP

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

	class Picture {

	public $instance;

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

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

	$localName = "Book1.xlsx";
	$waterMarkPNG = "WaterMark.png";
	$remoteName = "Book1.xlsx";
	$request = new PutWorksheetAddPictureRequest();
	$request->setName( $remoteName);
	$request->setSheetName( "Sheet6");
	$request->setUpperLeftRow( 1);
	$request->setUpperLeftColumn( 1);
	$request->setLowerRightRow( 10);
	$request->setLowerRightColumn( 10);
	$request->setPicturePath( $remoteFolder . "/WaterMark.png");
	$request->setFolder( $remoteFolder);
	$request->setStorageName( "");
	$this->instance->putWorksheetAddPicture($request);
	}
	}

	$picture = new Picture();
	$picture->putWorksheetAddPicture();

	?>

view raw Examples-PHP-Pictures-PutWorksheetAddPicture-.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 Picture

	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 a new worksheet picture.
	def add_a_new_worksheet_picture
	name = $BOOK1
	sheet_name = $SHEET6
	picture = nil
	upper_left_row = 1
	upper_left_column = 1
	lower_right_row = 10
	lower_right_column = 10
	picture_path = 'WaterMark.png'
	folder = $TEMPFOLDER
	result = @instance.upload_file( folder+"/"+name, ::File.open(File.expand_path("data/"+name),"r") {\|io\| io.read(io.size) })
	result = @instance.upload_file( folder+"/"+picture_path, ::File.open(File.expand_path("data/"+picture_path),"r") {\|io\| io.read(io.size) })
	expect(result.uploaded.size).to be > 0
	result = @instance.cells_pictures_put_worksheet_add_picture(name, sheet_name, {:picture=>picture, :upper_left_row=>upper_left_row, :upper_left_column=>upper_left_column, :lower_right_row=>lower_right_row, :lower_right_column=>lower_right_column, :picture_path=>(folder+"/"+picture_path), :folder=>folder})
	expect(result.code).to eql(200)
	end

	end

	picture = Picture.new()
	puts picture.add_a_new_worksheet_picture

view raw Examples-Ruby-Pictures-add_a_new_worksheet_picture-.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 = PutWorksheetAddPictureRequest( 'Book1.xlsx', 'Sheet6',upper_left_row= 1,upper_left_column= 1,lower_right_row= 10,lower_right_column= 10,picture_path= 'PythonTest/WaterMark.png',folder= 'PythonTest',storage_name= '')
	api.put_worksheet_add_picture(request)

view raw AddPictureToExcelWorksheet.py hosted with ❤ by GitHub

Node.js

	const { CellsApi, UploadFileRequest, CellsPictures_PutWorksheetAddPictureRequest } = require("asposecellscloud");
	const clientId = process.env.CellsCloudClientId;
	const clientSecret = process.env.CellsCloudClientSecret;
	const ApiURL = process.env.CellsCloudApiBaseUrl;
	const fs = require('fs');
	const path = require('path');
	const cellsApi = new CellsApi(clientId, clientSecret,"v3.0",ApiURL);
	const localPath = "D:/aspose-cells-cloud-node/TestData/"
	const picturePath = "WaterMark.png";
	const filename = "Book1.xlsx";
	const data =fs.createReadStream(path.join(localPath, filename));

	const req = new UploadFileRequest({
	path: "Temp/" + filename,
	file: data
	});
	cellsApi.uploadFile(req)
	.then((result) => {
	const data =fs.createReadStream(path.join(localPath, picturePath));
	const req = new UploadFileRequest();
	req.path = "Temp/" + picturePath;
	req.file = data;
	cellsApi.uploadFile(req)
	.then((result) => {
	const req = new CellsPictures_PutWorksheetAddPictureRequest();
	req.name = filename;
	req.sheetName = "Sheet6";
	req.picture = null;
	req.upperLeftRow = 1;
	req.upperLeftColumn = 1;
	req.lowerRightRow = 10;
	req.lowerRightColumn = 10;
	req.picturePath = "Temp/WaterMark.png";
	req.folder = "Temp";
	cellsApi.cellsPicturesPutWorksheetAddPicture(req)
	.then((result) => {
	console.log("successful")
	})

	})

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

view raw Examples-Node.js-SDK-Pictures-AddPicturesWorksheet-1.js hosted with ❤ by GitHub

Objective C

Android

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 $waterMarkPNG = 'WaterMark.png';
	my $remoteName = 'Book1.xlsx';
	my $request = AsposeCellsCloud::Request::PutWorksheetAddPictureRequest->new();
	$request->{name} = $remoteName;
	$request->{sheet_name} = 'Sheet6';
	$request->{upper_left_row} = 1;
	$request->{upper_left_column} = 1;
	$request->{lower_right_row} = 10;
	$request->{lower_right_column} = 10;
	$request->{picture_path} = $remoteFolder . '/WaterMark.png';
	$request->{folder} = $remoteFolder;
	$request->{storage_name} = '';
	my $result = $api->put_worksheet_add_picture(request=> $request);

view raw Examples-Perl-Pictures-AddPicturesWorksheet-1.pl hosted with ❤ by GitHub

Получите все изображения в рабочем листе Excel. Удалить картинку в файле Excel