Экспортировать рабочий лист

Вы можете экспортировать форматы:XLS, XLSX, XLSB, CSV, ТСВ, XLSM, ОРВ, ТЕКСТ, PDF, ОТС, XPS, ДИФ, PNG, JPEG, BMP, SVG, TIFF, EMF, ЧИСЛА, FODS..

ОТДЫХ API

API	Тип	Описание	Ссылка Swagger
/ячейки/экспорт	ПОЧТА	Экспортировать Excel из содержимого запроса в какой-либо формат	ПостЭкспорт

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

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

Запрос


curl -X POST "https://api.aspose.cloud/v3.0/cells/export?objectType=worksheet&format=tiff" -H "accept: multipart/form-data" -H "Content-Type: multipart/form-data" -H "x-aspose-client: Containerize.Swagger" -d {"File":{}}

Ответ

{
    "Files": [{
        "Filename": "Book1_xlsx_Sheet1.tif",
        "FileSize": 390,
        "FileContent": "-----Base64String--------"
    }, {
        "Filename": "Book1_xlsx_Sheet2.tif",
        "FileSize": 10040,
        "FileContent": "-----Base64String--------"
    }, {
        "Filename": "Book1_xlsx_Sheet3.tif",
        "FileSize": 2824,
        "FileContent": "-----Base64String--------"
    }, {
        "Filename": "Book1_xlsx_Sheet4.tif",
        "FileSize": 1350,
        "FileContent": "-----Base64String--------"
    }, {
        "Filename": "Book1_xlsx_Sheet5.tif",
        "FileSize": 12978,
        "FileContent": "-----Base64String--------"
    }, {
        "Filename": "Book1_xlsx_Sheet6.tif",
        "FileSize": 7002,
        "FileContent": "-----Base64String--------"
    }, {
        "Filename": "Book1_xlsx_Sheet7.tif",
        "FileSize": 11532,
        "FileContent": "-----Base64String--------"
    }, {
        "Filename": "myDocument_xlsx_Sheet1.tif",
        "FileSize": 382,
        "FileContent": "-----Base64String--------"
    }, {
        "Filename": "myDocument_xlsx_Sheet2.tif",
        "FileSize": 382,
        "FileContent": "-----Base64String--------"
    }, {
        "Filename": "myDocument_xlsx_Sheet3.tif",
        "FileSize": 130084,
        "FileContent": "-----Base64String--------"
    }, {
        "Filename": "myDocument_xlsx_Sheet4.tif",
        "FileSize": 120062,
        "FileContent": "-----Base64String--------"
    }]
}

Семейство облачных 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;
	using System.Collections.Generic;
	using System.IO;

	public partial class CellsApiExample
	{
	public void PostExportPicturePngExample()
	{
	string CellsCloudClientId ="....";//get from https://dashboard.aspose.cloud/#/applications
	string CellsCloudClientSecret="...";//get from https://dashboard.aspose.cloud/#/applications
	IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
	mapFiles.Add("assemblytest.xlsx", File.OpenRead(@".\TestData\assemblytest.xlsx"));
	mapFiles.Add("datasource.xlsx", File.OpenRead(@".\TestData\datasource.xlsx"));
	PostExportRequest request = new PostExportRequest { File = mapFiles, format = "pdf", objectType = "worksheet" };
	cellsApi.PostExport(request);
	}
	}
	}

view raw ExamplePostExportWorksheet.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 assemblyTestXlsx = "assemblytest.xlsx";
	String book1Xlsx = "Book1.xlsx";

	String format = "csv";
	String objectType = "worksheet";


	PostExportRequest request = new PostExportRequest();
	request.setFormat(format);

	request.setObjectType(objectType);



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

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

view raw Example_PostExportWorksheet.java hosted with ❤ by GitHub

PHP

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

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

	$assemblyTestXlsx = "assemblytest.xlsx";
	$book1Xlsx = "Book1.xlsx";

	$format = "csv";
	$objectType = "worksheet";

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

	$request = new PostExportRequest();
	$request->setFile( $mapFiles);
	$request->setObjectType( $objectType);
	$request->setFormat( $format);
	$cellsApi->postExport($request);

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

	assembly_test_xlsx = 'assemblytest.xlsx'
	book1_xlsx = 'Book1.xlsx'

	format = "csv"
	object_type = "worksheet"


	mapFiles = { }
	mapFiles[assembly_test_xlsx]= ::File.open(File.expand_path("TestData/"+assembly_test_xlsx),"r")
	mapFiles[book1_xlsx]= ::File.open(File.expand_path("TestData/"+book1_xlsx),"r")
	request = AsposeCellsCloud::PostExportRequest.new(:File=>mapFiles,:objectType=>object_type,:format=>format);
	@instance.post_export(request);

view raw Example_PostExportWorksheet.rb hosted with ❤ by GitHub

Node.js

	import { CellsApi, PostExportRequest } 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 assemblyTestXlsx = "assemblytest.xlsx"


	var format = "csv"
	var objectType = "worksheet"

	var mapFiles = {};

	mapFiles[assemblyTestXlsx]= fs.createReadStream(localPath +assemblyTestXlsx) ;
	mapFiles[book1Xlsx]= fs.createReadStream(localPath +localName) ;

	var request = new PostExportRequest();
	request.file = mapFiles;
	request.objectType = objectType;
	request.format = format;
	return cellsApi.postExport(request)
	});
	});

view raw Example_PostExportWorksheet.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 = PostExportRequest( {'assemblytest.xlsx':'assemblytest.xlsx'},object_type= 'worksheet',format= 'png')
	api.post_export(request)

view raw Example_PostExportWorksheet.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 $assemblyTestXlsx = 'assemblytest.xlsx';
	my $book1Xlsx = 'Book1.xlsx';


	my $format = 'csv';
	my $objectType = 'worksheet';

	my $mapFiles = {};

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

	my $request = AsposeCellsCloud::Request::PostExportRequest->new();
	$request->{file} = $mapFiles;
	$request->{object_type} = $objectType;
	$request->{format} = $format;
	$instance->post_export(request=> $request);

view raw Example_PostExportWorksheet.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)
	assemblyTestXlsx := "assemblytest.xlsx"
	book1Xlsx := "Book1.xlsx"

	format := "csv"
	objectType := "worksheet"

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

	request := new(PostExportRequest)
	request.File = mapFiles
	request.ObjectType = objectType
	request.Format = format
	_, httpResponse, err := instance.PostExport(request)
	if err != nil {
	println(err.Error())
	} else if httpResponse.StatusCode < 200 \|\| httpResponse.StatusCode > 299 {
	println("Fail")
	}
	}

view raw Example_PostExportWorksheet.go hosted with ❤ by GitHub

Импортировать изображение в рабочий лист Excel Импорт целочисленного массива в рабочий лист Excel