Agregue los 10 elementos principales en una hoja de trabajo Excel Este REST API indica filtrar el elemento top 10
en la lista
RSET API
Copy
PUT http://api.aspose.cloud/v3.0/cells/{ name} /worksheets/{ sheetName} /autoFilter/filterTop10
Los parámetros de la solicitud son:
Nombre del parámetro
Tipo
Ruta/Cadena de consulta/Cuerpo HTTP
Descripción
nombre
cadena
camino
nombre de la hoja
cadena
camino
rango
cadena
consulta
índice de campo
entero
consulta
yo paro
booleano
consulta
es por ciento
booleano
consulta
recuento de elementos
entero
consulta
MatchBlancos
booleano
consulta
actualizar
booleano
consulta
carpeta
cadena
consulta
nombredealmacenamiento
cadena
consulta
nombre del almacenamiento.
ElEspecificación de API abierta define una interfaz de programación de acceso público y le permite realizar interacciones REST directamente desde un navegador web.
Puede utilizar la herramienta de línea de comandos cURL para acceder fácilmente a los servicios web Aspose.Cells. El siguiente ejemplo muestra cómo realizar llamadas a Cloud API con cURL.
Familia de SDK en la nube
Usar un SDK es la mejor manera de acelerar el desarrollo. Un SDK se encarga de los detalles de bajo nivel y le permite concentrarse en las tareas de su proyecto. Por favor revisa elrepositorio de GitHub para obtener una lista completa de Aspose.Cells SDK de nube.
Los siguientes ejemplos de código demuestran cómo realizar llamadas a servicios web Aspose.Cells utilizando varios SDK:
C#
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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 PutWorksheetFilterTop101Example()
{
string CellsCloudClientId ="....";//get from https://dashboard.aspose.cloud/#/applications
string CellsCloudClientSecret="...";//get from https://dashboard.aspose.cloud/#/applications
PutWorksheetFilterTop10Request request = new PutWorksheetFilterTop10Request
{
name = "Book1.xlsx",
sheetName = "Sheet1",
fieldIndex = 0,
isPercent = true,
isTop = true,
itemCount = 1,
matchBlanks = true,
range = "A1:C10",
refresh = true,
folder = "TestData/In"
};
cellsApi.PutWorksheetFilterTop10(request);
}
}
}
Java
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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);
PutWorksheetFilterTop10Request request = new PutWorksheetFilterTop10Request();
request.setName(remoteName);
request.setSheetName("Sheet1");
request.setRange("RANGE");
request.setFieldIndex(0);
request.setIsTop(true);
request.setIsPercent(true);
request.setItemCount(1);
request.setMatchBlanks(false);
request.setRefresh(false);
request.setFolder(remoteFolder);
request.setStorageName("");
CellsCloudResponse response = api.putWorksheetFilterTop10(request);
} catch (ApiException e) {
e.printStackTrace();
}catch (IOException e) {
e.printStackTrace();
}
}
}
PHP
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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\PutWorksheetFilterTop10Request;
class FilterData {
public $instance;
public function __construct() {
$this->instance = new CellsApi(getenv("CellsCloudClientId"),getenv("CellsCloudClientSecret"),"v3.0",getenv("CellsCloudApiBaseUrl"));
}
public function putWorksheetFilterTop10() {
$remoteFolder = "TestData/In";
$localName = "Book1.xlsx";
$remoteName = "Book1.xlsx"; $request = new PutWorksheetFilterTop10Request();
$request->setName( $remoteName);
$request->setSheetName( "Sheet1");
$request->setRange( "A1:B1");
$request->setFieldIndex( 0);
$request->setIsTop( 'true');
$request->setIsPercent( 'true');
$request->setItemCount( 1);
$request->setMatchBlanks( 'false');
$request->setRefresh( 'true');
$request->setFolder( $remoteFolder);
$request->setStorageName( "");
$this->instance->putWorksheetFilterTop10($request);
}
}
$instance = new FilterData();
$instance->putWorksheetFilterTop10();
?>
Ruby
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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
# Clear cells contents.
def put_worksheet_filter_top10
name = $BOOK1
sheet_name = $SHEET1
range = $RANGE
field_index = 0
is_top = true
is_percent = true
item_count = 1
match_blanks = true
refresh = true
folder = $TEMPFOLDER
result = @instance.upload_file( folder+"/"+name, ::File.open(File.expand_path("data/"+name),"r") {|io| io.read(io.size) })
expect(result.uploaded.size).to be > 0
result = @instance.cells_auto_filter_put_worksheet_filter_top10(name, sheet_name, range, field_index, is_top, is_percent, item_count, {:match_blanks=>match_blanks, :refresh=>refresh, :folder=>folder})
expect(result.code).to eql(200)
end
end
cell = Cell.new()
puts cell.put_worksheet_filter_top10
Node.js
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
const { CellsApi, UploadFileRequest, CellsAutoFilter_PutWorksheetFilterTop10Request } = 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 data =fs.createReadStream(path.join(localPath, filename));
const req = new UploadFileRequest({
path: "Temp/" + filename,
file: data
});
cellsApi.uploadFile(req)
.then((result) => {
const req = new CellsAutoFilter_PutWorksheetFilterTop10Request();
req.name = filename;
req.sheetName = "Sheet1";
req.range = "A1:C10";
req.fieldIndex = 0;
req.isTop = true;
req.isPercent = true;
req.itemCount = 1;
req.matchBlanks = null;
req.refresh = null;
req.folder = "Temp";
cellsApi.cellsAutoFilterPutWorksheetFilterTop10(req)
.then((result) => {
console.log("successful")
}).catch((error) => {
console.error('Unhandled Promise Rejection:', error);
})
})
Android
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-slides/Aspose.Cells-for-Cloud
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-android/
try {
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl());
String name = BOOK1;
String sheetName = SHEET1;
String range = RANGE;
Integer fieldIndex = 0;
Boolean isTop = true;
Boolean isPercent = true;
Integer itemCount = 1;
Boolean matchBlanks = null;
Boolean refresh = null;
String folder = TEMPFOLDER;
CellsApiUtil.Upload(api, folder , name);
CellsCloudResponse response = api.cellsAutoFilterPutWorksheetFilterTop10(name, sheetName, range, fieldIndex, isTop, isPercent, itemCount, matchBlanks, refresh, folder,null);
} catch (Exception ex) {
ex.printStackTrace();
}
Perl
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 $request = AsposeCellsCloud::Request::PutWorksheetFilterTop10Request->new();
$request->{name} = $remoteName;
$request->{sheet_name} = 'Sheet1';
$request->{range} = 'A1:B1';
$request->{field_index} = 0;
$request->{is_top} = 'true';
$request->{is_percent} = 'true';
$request->{item_count} = 1;
$request->{match_blanks} = 'false';
$request->{refresh} = 'true';
$request->{folder} = $remoteFolder;
$request->{storage_name} = '';
my $result = $api->put_worksheet_filter_top10(request=> $request);
Go