在 Excel 工作表中添加 OLE 对象

此 REST API 在 Excel 工作表中表示 add OLE object。

重置 API

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

请求参数为：

参数名称	类型	路径/查询字符串/HTTPBody	描述
姓名	细绳	小路	工作簿名称。
工作表名称	细绳	小路	工作表名称。
对象对象		身体	Ole 对象
左上行	整数	询问	0
左上列	整数	询问	0
高度	整数	询问	0
宽度	整数	询问	0
ole文件	细绳	询问	OLE 文件名
图像文件	细绳	询问	图像文件名
文件夹	细绳	询问	工作簿文件夹。
存储名称	细绳	询问	存储名称。

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

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

Request

 
curl -v "http://api.aspose.cloud/v3.0/cells/Book1.xlsx/worksheets/Sheet1/oleobjects" \
-X PUT \
-H "Content-Type: application/json" \
-H "Accept: application/json" \
-H "Authorization: Bearer <jwt token>" \
-d '{"ImageSourceFullName":"aspose-logo.png", "IsAutoSize":true, "SourceFullName":"Sample_Book2.xls", "UpperLeftRow":15, "Top":10, "UpperLeftColumn":5, "Left":10,"Width":400, "Height":400}'

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 PutWorksheetOleObjectExample()
	{
	CellsApi cellsApi = new CellsApi(Environment.GetEnvironmentVariable("CellsCloudTestClientId"), Environment.GetEnvironmentVariable("CellsCloudTestClientSecret"));
	PutWorksheetOleObjectRequest request = new PutWorksheetOleObjectRequest
	{
	name = "Book1.xlsx",
	sheetName = "Sheet6",
	upperLeftRow = 1,
	upperLeftColumn = 1,
	height = 100,
	width = 80,
	oleFile = "OLEDoc.docx",
	folder = "TestData/In"
	};
	cellsApi.PutWorksheetOleObject(request);
	}
	}
	}

view raw Examples-DotNET-CSharp-OleObjects-AddOleObjectsWorksheet-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);
	PutWorksheetOleObjectRequest request = new PutWorksheetOleObjectRequest();
	request.setName(remoteName);
	request.setSheetName("Sheet6");
	request.setUpperLeftRow(1);
	request.setUpperLeftColumn(1);
	request.setHeight(100);
	request.setWidth(10);
	request.setOleFile("TestData/OLEDoc.docx");
	request.setImageFile("TestData/word.jpg");
	request.setFolder(remoteFolder);
	request.setStorageName("");

	CellsCloudResponse response = api.putWorksheetOleObject(request);

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

view raw Examples-Java-oleobjects-AddOleObjectsWorksheet-add-ole-objects-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\PutWorksheetOleObjectRequest;

	class OLEObject {

	public $instance;

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

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

	$localName = "Book1.xlsx";
	$oLEDoc = "OLEDoc.docx";
	$wordJPG = "word.jpg"; $request = new PutWorksheetOleObjectRequest();
	$request->setName( $localName);
	$request->setSheetName( "Sheet6");
	$request->setUpperLeftRow( 1);
	$request->setUpperLeftColumn( 1);
	$request->setHeight( 100);
	$request->setWidth( 80);
	$request->setOleFile( "OLEDoc.docx");
	$request->setImageFile( "word.jpg");
	$request->setFolder( $remoteFolder);
	$request->setStorageName( "");
	$this->instance->putWorksheetOleObject($request);
	}
	}

	$oLEObject = new OLEObject();
	$oLEObject->putWorksheetOleObject();

	?>

view raw Examples-PHP-OLEObjects-PutWorksheetOleObject-.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 OLEObject

	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 OLE object
	def add_ole_object
	name = $BOOK1
	sheet_name = $SHEET6
	ole_object = nil
	upper_left_row = 1
	upper_left_column = 1
	height = 100
	width = 80
	ole_file = 'OLEDoc.docx'
	image_file = 'word.jpg'
	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+"/"+ole_file, ::File.open(File.expand_path("data/"+ole_file),"r") {\|io\| io.read(io.size) })
	result = @instance.upload_file( folder+"/"+image_file, ::File.open(File.expand_path("data/"+image_file),"r") {\|io\| io.read(io.size) })
	expect(result.uploaded.size).to be > 0
	result = @instance.cells_ole_objects_put_worksheet_ole_object(name, sheet_name, { :ole_object=>ole_object, :upper_left_row=>upper_left_row, :upper_left_column=>upper_left_column, :height=>height, :width=>width, :ole_file=> (folder+"/"+ole_file), :image_file=> (folder+"/"+image_file),:folder=>folder})
	expect(result.code).to eql(200)
	end

	end

	oleObject = OLEObject.new()
	puts oleObject.add_ole_object

view raw Examples-Ruby-OLEObject-add_ole_object-.rb hosted with ❤ by GitHub

Node.js

	const { CellsApi, UploadFileRequest, CellsOleObjects_PutWorksheetOleObjectRequest } = 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 filename = "Book1.xlsx";
	const filename1 = "OLEDoc.docx";
	const filename2 = "word.jpg";
	const data =fs.createReadStream(path.join(localPath, filename));

	const req = new UploadFileRequest({
	path: "Temp/" + filename,
	file: data
	});
	cellsApi.uploadFile(req)
	.then((result) => {
	const filename1= "word.jpg";
	const cellsApi = new CellsApi(clientId, clientSecret,"v3.0",ApiURL);
	const data =fs.createReadStream(localPath + filename1);
	const req = new UploadFileRequest();
	req.path = "Temp/" + filename1;
	req.file = data;
	cellsApi.uploadFile(req)
	.then((result) => {
	const filename2 = "OLEDoc.docx";
	const cellsApi = new CellsApi(clientId, clientSecret,"v3.0",ApiURL);
	const data =fs.createReadStream(localPath + filename2);
	const req = new UploadFileRequest();
	req.path = "Temp/" + filename2;
	req.file = data;
	cellsApi.uploadFile(req)
	.then((result) => {
	const req = new CellsOleObjects_PutWorksheetOleObjectRequest();
	req.name = filename;
	req.sheetName = "Sheet6";
	req.folder = "Temp";
	req.oleObject = null;
	req.upperLeftRow = 1;
	req.upperLeftColumn = 1;
	req.height = 100;
	req.width = 80;
	req.oleFile = filename1;
	req.imageFile = filename2;
	cellsApi.cellsOleObjectsPutWorksheetOleObject(req)
	.then((result) => {
	console.log("successful")

	})


	})
	})


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

view raw Examples-Node.js-SDK-Oleobjects-AddOleObjectsWorksheet-1.js 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 = PutWorksheetOleObjectRequest( 'Book1.xlsx', 'Sheet6',upper_left_row= 1,upper_left_column= 1,height= 100,width= 80,ole_file= 'OLEDoc.docx',image_file= 'word.jpg',folder= "PythonTest",storage_name= '')
	api.put_worksheet_ole_object(request)

view raw AddOLEObjectsToExcelWorksheet.py hosted with ❤ by GitHub

Android

Swift

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 $oLEDoc = 'OLEDoc.docx';
	my $wordJPG = 'word.jpg';
	my $remoteName = 'Book1.xlsx';
	my $request = AsposeCellsCloud::Request::PutWorksheetOleObjectRequest->new();
	$request->{name} = $remoteName;
	$request->{sheet_name} = 'Sheet6';
	$request->{upper_left_row} = 1;
	$request->{upper_left_column} = 1;
	$request->{height} = 100;
	$request->{width} = 80;
	$request->{ole_file} = 'OLEDoc.docx';
	$request->{image_file} = 'word.jpg';
	$request->{folder} = $remoteFolder;
	$request->{storage_name} = '';
	my $result = $api->put_worksheet_ole_object(request=> $request);

view raw Examples-Perl-Oleobjects-AddOleObjectsWorksheet-1.pl hosted with ❤ by GitHub

在 Excel 工作表中获取 OLE 对象更新 Excel 工作表中的 OLE 对象