清除 Excel 文件中的对象

此 REST API 表示 Excel 文件中的 clear excel 对象。

重新设置 API


POST https://api.aspose.cloud/v3.0/cells/clearobjects

请求参数为：

参数名称	类型	路径/查询字符串/HTTPBody	描述
文件	文件	表单数据	要上传的文件
对象类型	细绳	询问	重复行/空白列/空白行/公式/内容/样式/图表/注释/图片/形状/列表对象/超链接/ole对象/数据透视表/验证/背景

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

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

Request

 
curl -v "http://api.aspose.cloud/v3.0/cells/clearobjects?objecttype=comment" \
-X POST \
-H "Content-Type: application/json" \
-H "Accept: application/json" \
-H "Authorization: Bearer <jwt token>" \
-F 'xxxxx1=@xxxx1.xlsx' \
-F 'xxxxx2=@xxxx2.xlsx'

Response

{
    "Files":
    [
        { 
            "Filename":"xxxx1",
            "FileSize":274022,
            "FileContent":"-----Base64String--------"
        },
        { 
            "Filename":"xxxx2",
            "FileSize":274022,
            "FileContent":"-----Base64String--------"
        }
    ]
}

Cloud SDK 系列

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

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

	namespace Aspose.Cells.Cloud.SDK.Tests.Api.Example
	{
	using Microsoft.VisualStudio.TestTools.UnitTesting;
	using Aspose.Cells.Cloud.SDK.Request;
	using System.Collections.Generic;
	using Aspose.Cells.Cloud.SDK.Api;
	using System;
	using System.IO;

	[TestClass]
	public class CellsApiExample
	{
	string CellsCloudClientId ="....";//get from https://dashboard.aspose.cloud/#/applications
	string CellsCloudClientSecret="...";//get from https://dashboard.aspose.cloud/#/applications
	private readonly string remoteFolder = "TestData/In";
	string localName = "Book1.xlsx";
	string localPath = "D:/TestData/CellsCloud";
	[TestCategory("Cells")]
	[TestMethod]
	public void Example()
	{


	IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
	mapFiles.Add(localName, File.OpenRead(localPath +"/"+ localName));


	var request = new PostClearObjectsRequest(
	file: mapFiles,
	objecttype: objecttype
	);
	cellsApi.PostClearObjects(request);





	}


	}
	}

view raw ExamplePostClearObjects.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 book1Xlsx = "Book1.xlsx";
	String dataSourceXlsx = "datasource.xlsx";

	String objecttype = "chart";


	PostClearObjectsRequest request = new PostClearObjectsRequest();
	request.setObjecttype(objecttype);



	HashMap<String,File> fileMap = new HashMap<String,File>();
	fileMap.put(book1Xlsx ,CellsApiUtil.GetFileHolder(book1Xlsx) );
	fileMap.put(dataSourceXlsx ,CellsApiUtil.GetFileHolder(dataSourceXlsx) );
	request.setFile(fileMap);
	this.api.postClearObjects(request);

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

view raw Example_PostClearObjects.java hosted with ❤ by GitHub

PHP

	<?php
	require_once('vendor\autoload.php');
	use \Aspose\Cells\Cloud\Api\CellsApi;
	use \Aspose\Cells\Cloud\Request\PostClearObjectsRequest;

	$CellsCloudClientId = "...." ; # get from https://dashboard.aspose.cloud/#/applications
	$CellsCloudClientSecret = "...."; # get from https://dashboard.aspose.cloud/#/applications
	$cellsApi = new CellsApi($CellsCloudClientId , $CellsCloudClientSecret );

	$book1Xlsx = "Book1.xlsx";
	$dataSourceXlsx = "datasource.xlsx";

	$objecttype = "chart";

	$mapFiles = array ();
	$mapFiles[$book1Xlsx] ='TestData/'.$book1Xlsx;
	$mapFiles[$dataSourceXlsx] = "TestData/".$dataSourceXlsx;;

	$request = new PostClearObjectsRequest();
	$request->setFile( $mapFiles);
	$request->setObjecttype( $objecttype);
	$cellsApi->postClearObjects($request);

view raw Example_PostClearObjects.php hosted with ❤ by GitHub

Ruby

	require 'openssl'
	require 'bundler'
	require 'aspose_cells_cloud'


	CellsCloudClientId = "...." # get from https://dashboard.aspose.cloud/#/applications
	CellsCloudClientSecret = "...." # get from https://dashboard.aspose.cloud/#/applications
	@instance = AsposeCellsCloud::CellsApi.new(CellsCloudClientId, CellsCloudClientSecret)

	book1_xlsx = 'Book1.xlsx'
	data_source_xlsx = 'datasource.xlsx'

	objecttype = "chart"


	mapFiles = { }
	mapFiles[book1_xlsx]= ::File.open(File.expand_path("TestData/"+book1_xlsx),"r")
	mapFiles[data_source_xlsx]= ::File.open(File.expand_path("TestData/"+data_source_xlsx),"r")
	request = AsposeCellsCloud::PostClearObjectsRequest.new(:File=>mapFiles,:objecttype=>objecttype);
	@instance.post_clear_objects(request);

view raw Example_PostClearObjects.rb hosted with ❤ by GitHub

Node.js

	import { CellsApi,PostClearObjectsRequest,UploadFileRequest } from "asposecellscloud";
	var fs = require('fs');
	var path = require('path');
	var process = require('process');
	const _ = require('asposecellscloud');

	const CellsCloudClientId ="....";//get from https://dashboard.aspose.cloud/#/applications
	const CellsCloudClientSecret="...";//get from https://dashboard.aspose.cloud/#/applications
	const cellsApi = new CellsApi(CellsCloudClientId, CellsCloudClientSecret);

	var remoteFolder = "TestData/In"
	var localPath = "TestData/CellsCloud/"
	var localName = "Book1.xlsx"
	var remoteName = "Book1.xlsx"


	describe('example', function(){
	it("should call successfully" , function(){
	var dataSourceXlsx = "datasource.xlsx"


	var objecttype = "chart"

	var mapFiles = {};

	mapFiles[book1Xlsx]= fs.createReadStream(localPath +remoteName) ;
	mapFiles[dataSourceXlsx]= fs.createReadStream(localPath +dataSourceXlsx) ;

	var request = new PostClearObjectsRequest();
	request.file = mapFiles;
	request.objecttype = objecttype;
	return cellsApi.postClearObjects(request)
	});
	});

view raw Example_PostClearObjects.ts hosted with ❤ by GitHub

Python

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	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 = PostClearObjectsRequest( mapFiles, objecttype)
	api.post_clear_objects(request)

view raw Example_PostClearObjects.py hosted with ❤ by GitHub

Perl

	use lib 'lib';
	use strict;
	use warnings;
	use File::Slurp;
	use MIME::Base64;
	use AsposeCellsCloud::CellsApi;

	my $CellsCloudClientId = "...."; # get from https://dashboard.aspose.cloud/#/applications
	my $CellsCloudClientSecret = "...."; # get from https://dashboard.aspose.cloud/#/applications
	my $config = AsposeCellsCloud::Configuration->new( client_id => $CellsCloudClientId , client_secret => $CellsCloudClientSecret );

	my $instance = AsposeCellsCloud::CellsApi->new(AsposeCellsCloud::ApiClient->new( $config));


	my $book1Xlsx = 'Book1.xlsx';
	my $dataSourceXlsx = 'datasource.xlsx';


	my $objecttype = 'chart';

	my $mapFiles = {};

	$mapFiles->{$book1Xlsx}= "TestData/".$book1Xlsx ;
	$mapFiles->{$dataSourceXlsx}= "TestData/".$dataSourceXlsx ;

	my $request = AsposeCellsCloud::Request::PostClearObjectsRequest->new();
	$request->{file} = $mapFiles;
	$request->{objecttype} = $objecttype;
	$instance->post_clear_objects(request=> $request);

view raw Example_PostClearObjects.pl hosted with ❤ by GitHub

	package main

	import (
	. "github.com/aspose-cells-cloud/aspose-cells-cloud-go/v25"
	)

	func main() {
	CellsCloudClientId := "...." // get from https://dashboard.aspose.cloud/#/applications
	CellsCloudClientSecret := "...." // get from https://dashboard.aspose.cloud/#/applications
	instance := NewCellsApiService(CellsCloudClientId, CellsCloudClientSecret)
	book1Xlsx := "Book1.xlsx"
	dataSourceXlsx := "datasource.xlsx"

	objecttype := "chart"

	var mapFiles map[string]string
	mapFiles = make(map[string]string)
	mapFiles[book1Xlsx] = book1Xlsx
	mapFiles[dataSourceXlsx] = dataSourceXlsx

	request := new(PostClearObjectsRequest)
	request.File = mapFiles
	request.Objecttype = objecttype
	_, httpResponse, err := instance.PostClearObjects(request)
	if err != nil {
	println(err.Error())
	} else if httpResponse.StatusCode < 200 \|\| httpResponse.StatusCode > 299 {
	println("Fail")
	}
	}

view raw Example_PostClearObjects.go hosted with ❤ by GitHub

获取页数表格 Excel Fil 在 Excel 工作簿上自动调整行