Добавьте цветовой фильтр на рабочий лист Excel

Этот REST API указывает на добавление color filter на рабочий лист Excel.

РЕТ API

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

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

Имя параметра	Тип	Путь/Строка запроса/HTTPBody	Описание
имя	нить	путь
Имя листа	нить	путь
диапазон	нить	запрос
fieldIndex	целое число	запрос
цветФильтр		тело
матчБланки	булев	запрос
обновить	булев	запрос
папка	нить	запрос
имя_хранилища	нить	запрос	имя хранилища.

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

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

Request


curl -v "https://api.aspose.cloud/v3.0/cells/Book1.xlsx/worksheets/Sheet1/autoFilter/colorFilter?range=A1%3AB1&fieldIndex=0" \
-X PUT \
-d "{ \"Pattern\": \"Solid\", \"ForegroundColor\": { \"Color\": { \"A\": 255, \"R\": 0, \"G\": 255, \"B\": 255 }, \"ColorIndex\": 0, \"IsShapeColor\": true, \"ThemeColor\": { \"ColorType\": \"Text2\", \"Tint\": 1 }, \"Type\": \"Automatic\" }, \"BackgroundColor\": { \"Color\": { \"A\": 255, \"R\": 0, \"G\": 255, \"B\": 255 }, \"ColorIndex\": 0, \"IsShapeColor\": true, \"ThemeColor\": { \"ColorType\": \"Text2\", \"Tint\": 0 }, \"Type\": \"Automatic\" }}" \
-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:

	using Aspose.Cells.Cloud.SDK.Api;
	using Aspose.Cells.Cloud.SDK.Model;
	using Aspose.Cells.Cloud.SDK.Request;
	using System;
	using System.IO;
	using System.Collections.Generic;

	string CellsCloudClientId ="....";//get from https://dashboard.aspose.cloud/#/applications
	string CellsCloudClientSecret="...";//get from https://dashboard.aspose.cloud/#/applications
	string remoteFolder = "TestData/In";

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



	var colorFilterForegroundColorColor = new Color()
	{
	R = 48,
	G = 48,
	B = 48
	};
	var colorFilterForegroundColor = new CellsColor()
	{
	Type = "Automatic",
	Color = colorFilterForegroundColorColor
	};
	var colorFilter = new ColorFilterRequest()
	{
	Pattern = "Solid",
	ForegroundColor = colorFilterForegroundColor
	};
	var request = new PutWorksheetColorFilterRequest(
	name: remoteName,
	sheetName: "Sheet1",
	range: "A1:B1",
	fieldIndex: 0,
	colorFilter: colorFilter,
	matchBlanks: true,
	refresh: true,
	folder: remoteFolder,
	storageName: ""
	);
	cellsApi.PutWorksheetColorFilter(request);

view raw ExamplePutWorksheetColorFilter.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);

	PutWorksheetColorFilterRequest request = new PutWorksheetColorFilterRequest();
	request.setName(remoteName);

	request.setSheetName("Sheet1");

	request.setRange("A1:B1");

	request.setFieldIndex(0);

	ColorFilterRequest colorFilter = new ColorFilterRequest();
	colorFilter.setPattern("Solid");


	CellsColor foregroundColor = new CellsColor();
	foregroundColor.setType("Automatic");


	Color color = new Color();
	color.setR(48);


	color.setG(48);


	color.setB(48);

	foregroundColor.setColor(color);

	colorFilter.setForegroundColor(foregroundColor);

	request.setColorFilter(colorFilter);

	request.setMatchBlanks(true);

	request.setRefresh(true);

	request.setFolder(remoteFolder);

	request.setStorageName("");

	this.api.putWorksheetColorFilter(request);

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

view raw Example_PutWorksheetColorFilter.java hosted with ❤ by GitHub

PHP

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

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

	$remoteFolder = "TestData/In";

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

	$colorFilterForegroundColorColor = new \Aspose\Cells\Cloud\Model\Color();
	$colorFilterForegroundColorColor->setR(48 );
	$colorFilterForegroundColorColor->setG(48 );
	$colorFilterForegroundColorColor->setB(48 );
	$colorFilterForegroundColor = new \Aspose\Cells\Cloud\Model\CellsColor();
	$colorFilterForegroundColor->setType("Automatic" );
	$colorFilterForegroundColor->setColor($colorFilterForegroundColorColor );
	$colorFilter = new \Aspose\Cells\Cloud\Model\ColorFilterRequest();
	$colorFilter->setPattern("Solid" );
	$colorFilter->setForegroundColor($colorFilterForegroundColor );


	$request = new PutWorksheetColorFilterRequest();
	$request->setName( $remoteName);
	$request->setSheetName( "Sheet1");
	$request->setRange( "A1:B1");
	$request->setFieldIndex( 0);
	$request->setColorFilter( $colorFilter);
	$request->setMatchBlanks( 'true');
	$request->setRefresh( 'true');
	$request->setFolder( $remoteFolder);
	$request->setStorageName( "");
	$cellsApi->putWorksheetColorFilter($request);

view raw Example_PutWorksheetColorFilter.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)

	remote_folder = 'TestData/In'

	local_name = 'Book1.xlsx'
	remote_name = 'Book1.xlsx'


	mapFiles = { }
	mapFiles[local_name] = ::File.open(File.expand_path("TestData/"+local_name),"r")

	uploadrequest = AsposeCellsCloud::UploadFileRequest.new( { :UploadFiles=>mapFiles,:path=>remote_folder })
	@instance.upload_file(uploadrequest)
	colorFilterForegroundColorColor = AsposeCellsCloud::Color.new(:R=>48 ,:G=>48 ,:B=>48 );
	colorFilterForegroundColor = AsposeCellsCloud::CellsColor.new(:Type=>'Automatic' ,:Color=>colorFilterForegroundColorColor );
	colorFilter = AsposeCellsCloud::ColorFilterRequest.new(:Pattern=>'Solid' ,:ForegroundColor=>colorFilterForegroundColor );
	request = AsposeCellsCloud::PutWorksheetColorFilterRequest.new(:name=>remote_name,:sheetName=>'Sheet1',:range=>'A1:B1',:fieldIndex=>0,:colorFilter=>colorFilter,:matchBlanks=>true,:refresh=>true,:folder=>remote_folder,:storageName=>'');
	@instance.put_worksheet_color_filter(request);

view raw Example_PutWorksheetColorFilter.rb hosted with ❤ by GitHub

Node.js

	import { CellsApi,Color,CellsColor,ColorFilterRequest,PutWorksheetColorFilterRequest,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 localNameRequest = new UploadFileRequest();
	localNameRequest.uploadFiles ={localName:fs.createReadStream(localPath + localName)};
	localNameRequest.path = remoteFolder + "/" + remoteName ;
	localNameRequest.storageName ="";
	cellsApi.uploadFile(localNameRequest );


	var colorFilterForegroundColorColor = new Color();
	colorFilterForegroundColorColor.r = 48 ;
	colorFilterForegroundColorColor.g = 48 ;
	colorFilterForegroundColorColor.b = 48 ;
	var colorFilterForegroundColor = new CellsColor();
	colorFilterForegroundColor.type = "Automatic" ;
	colorFilterForegroundColor.color = colorFilterForegroundColorColor ;
	var colorFilter = new ColorFilterRequest();
	colorFilter.pattern = "Solid" ;
	colorFilter.foregroundColor = colorFilterForegroundColor ;

	var request = new PutWorksheetColorFilterRequest();
	request.name = remoteName;
	request.sheetName = "Sheet1";
	request.range = "A1:B1";
	request.fieldIndex = 0;
	request.colorFilter = colorFilter;
	request.matchBlanks = true;
	request.refresh = true;
	request.folder = remoteFolder;
	request.storageName = "";
	return cellsApi.putWorksheetColorFilter(request)



	});
	});

view raw Example_PutWorksheetColorFilter.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)
	colorFilterForegroundColorColor = Color(r= 48 ,g= 48 ,b= 48 )
	colorFilterForegroundColor = CellsColor(type= 'Automatic' ,color= colorFilterForegroundColorColor )
	colorFilter = ColorFilterRequest(pattern= 'Solid' ,foreground_color= colorFilterForegroundColor )
	request = PutWorksheetColorFilterRequest( 'Book1.xlsx', 'Sheet1', 'A1:B1', 0, colorFilter,match_blanks= True,refresh= True,folder= 'PythonTest',storage_name= '')
	api.put_worksheet_color_filter(request)

view raw Example_PutWorksheetColorFilter.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 $remoteFolder = 'TestData/In';

	my $localName = 'Book1.xlsx';
	my $remoteName = 'Book1.xlsx';

	my $upload_file_request = AsposeCellsCloud::Request::UploadFileRequest->new( 'UploadFiles'=>{ $localName => $localName } ,'path'=>$remoteFolder . '/' . $remoteName );

	my $color_filter_foreground_color_color = AsposeCellsCloud::Object::Color->new();
	$color_filter_foreground_color_color->{r} = 48 ;
	$color_filter_foreground_color_color->{g} = 48 ;
	$color_filter_foreground_color_color->{b} = 48 ;
	my $color_filter_foreground_color = AsposeCellsCloud::Object::CellsColor->new();
	$color_filter_foreground_color->{type} = 'Automatic' ;
	$color_filter_foreground_color->{color} = $color_filter_foreground_color_color ;
	my $color_filter = AsposeCellsCloud::Object::ColorFilterRequest->new();
	$color_filter->{pattern} = 'Solid' ;
	$color_filter->{foreground_color} = $color_filter_foreground_color ;

	my $request = AsposeCellsCloud::Request::PutWorksheetColorFilterRequest->new();
	$request->{name} = $remoteName;
	$request->{sheet_name} = 'Sheet1';
	$request->{range} = 'A1:B1';
	$request->{field_index} = 0;
	$request->{color_filter} = $color_filter;
	$request->{match_blanks} = 'true';
	$request->{refresh} = 'true';
	$request->{folder} = $remoteFolder;
	$request->{storage_name} = '';
	$instance->put_worksheet_color_filter(request=> $request);

view raw Example_PutWorksheetColorFilter.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)
	remoteFolder := "TestData/In"

	localName := "Book1.xlsx"
	remoteName := "Book1.xlsx"

	localNameRequest := new(UploadFileRequest)
	localNameRequest.UploadFiles = make(map[string]string)
	localNameRequest.UploadFiles[localName] = localName
	localNameRequest.Path = remoteFolder + "/" + remoteName
	localNameRequest.StorageName = ""
	instance.UploadFile(localNameRequest)

	var colorFilterForegroundColorColor = new(Color)
	colorFilterForegroundColorColor.R = int64(48)
	colorFilterForegroundColorColor.G = int64(48)
	colorFilterForegroundColorColor.B = int64(48)
	var colorFilterForegroundColor = new(CellsColor)
	colorFilterForegroundColor.Type_ = "Automatic"
	colorFilterForegroundColor.Color = colorFilterForegroundColorColor
	var colorFilter = new(ColorFilterRequest)
	colorFilter.Pattern = "Solid"
	colorFilter.ForegroundColor = colorFilterForegroundColor

	request := new(PutWorksheetColorFilterRequest)
	request.Name = remoteName
	request.SheetName = "Sheet1"
	request.Range_ = "A1:B1"
	request.FieldIndex = int64(0)
	request.ColorFilter = colorFilter
	request.MatchBlanks = true
	request.Refresh = true
	request.Folder = remoteFolder
	request.StorageName = ""
	_, httpResponse, err := instance.PutWorksheetColorFilter(request)
	if err != nil {
	println(err.Error())
	} else if httpResponse.StatusCode < 200 \|\| httpResponse.StatusCode > 299 {
	println("Fail")
	}
	}

view raw Example_PutWorksheetColorFilter.go hosted with ❤ by GitHub

Добавить фильтр в рабочий лист Excel Найдите все непустые ячейки на рабочем листе Excel