Speichern unter Exce Dieses REST API zeigt die Excel-Datei save
als Datei in einem anderen Format an.
Pfadparameter
Parametername
Typ
Beschreibung
Name
Schnur
Der Dateiname.
Abfrageparameter
Parametername
Typ
Beschreibung
neuerDateiname
Schnur
neuer Dateiname
isAutoFitRows
Schnur
Passt alle Zeilen in dieser Arbeitsmappe automatisch an. Der Standardwert ist „false“.
isAutoFitColumns
Schnur
Passt die Spaltenbreite in dieser Arbeitsmappe automatisch an. Der Standardwert ist „false“.
Ordner
Schnur
Original-Arbeitsmappenordner.
Speichername
Schnur
Der Name des Speicherorts, an dem sich die Datei befindet.
outStorageName
Schnur
Der Speichername, in dem sich die gespeicherte Datei befindet.
checkExcelRestriction
bool
Ob die Einschränkung der Excel-Datei überprüft wird, wenn der Benutzer zellenbezogene Objekte ändert.
Region
Schnur
Die regionalen Einstellungen für die Arbeitsmappe.
SeitenbreiteAnpassungAufProBlatt
bool
Die Seitenbreite passt auf das Arbeitsblatt.
Seite hoch, passend für Blattgröße
bool
Die Seitenhöhe passt auf das Arbeitsblatt.
Blattname
Schnur
Konvertieren Sie das angegebene Arbeitsblatt.
Seitenindex
Schnur
Konvertieren Sie die angegebene Seite des Arbeitsblatts. Der Blattname ist erforderlich.
eineSeiteProBlatt
bool
Bei der Konvertierung in das Format PDF eine Seite pro Blatt.
Anforderungstextparameter
Parametername
Typ
Beschreibung
Speicheroptionen
Objekt
Mit der Speicheroption wird im zweiten Teil des mehrteiligen Inhalts gespeichert.
REST API
API
Typ
Beschreibung
Ressourcenlink
/Zellen/{Name}/saveAs
POST
Arbeitsmappe in Format exportieren
PostDocumentSaveAs
DerOpenAPI-Spezifikation definiert eine öffentlich zugängliche Programmierschnittstelle und ermöglicht Ihnen die Durchführung von REST-Interaktionen direkt von einem Webbrowser aus.
Sie könnencURL Befehlszeilentool für den einfachen Zugriff auf Aspose.Cells-Webdienste. Das folgende Beispiel zeigt, wie Sie mit cURL Aufrufe an die Cloud API tätigen.
Request
Copy
curl - X POST "https://api.aspose.cloud/v3.0/cells/sampleBook.xlsx/SaveAs?newfilename=sample.pdf&isAutoFitRows=true&isAutoFitColumns=true" - H "accept: multipart/form-data"
Response
Copy
{
"SaveResult" : {
"SourceDocument" : {
"Href" : "test.xlsx" ,
"Rel" : null ,
"Title" : null ,
"Type" : null
},
"DestDocument" : {
"Href" : "test.pdf" ,
"Rel" : null ,
"Title" : null ,
"Type" : null
},
"AdditionalItems" : []
},
"Code" : 200 ,
"Status" : "OK"
}
Cloud SDK-Familie
Die Verwendung eines SDKs beschleunigt die Entwicklung am besten. Ein SDK kümmert sich um grundlegende Details und ermöglicht Ihnen, sich auf Ihre Projektaufgaben zu konzentrieren. Bitte beachten Sie dieGitHub-Repository für eine vollständige Liste der Aspose.Cells Cloud SDKs.
Die folgenden Codebeispiele zeigen, wie Sie mithilfe verschiedener SDKs Aufrufe an Aspose.Cells-Webdienste tätigen:
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
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 remoteName = "remote_book1.xlsx";
string localPath = "D:/TestData/CellsCloud";
[TestCategory("Cells")]
[TestMethod]
public void Example()
{
UploadFileRequest uploadFileRequest = new UploadFileRequest();
FileInfo fileInfo = new FileInfo(localPath + "/" + localName);
uploadFileRequest.path = remoteFolder + "/" + remoteName;
uploadFileRequest.storageName = "";
uploadFileRequest.UploadFiles = new Dictionary<string, Stream>() { { localName, File.OpenRead(localPath +"/"+ localName) } };
cellsApi.UploadFile(uploadFileRequest);
var saveOptions = new PdfSaveOptions()
{
SaveFormat = format
};
var request = new PostWorkbookSaveAsRequest(
name: remoteName,
newfilename: newfilename,
saveOptions: saveOptions,
folder: remoteFolder
);
cellsApi.PostWorkbookSaveAs(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";
String format = "csv";
String newfilename = "OutResult/PostExcelSaveAs.csv";
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);
PostWorkbookSaveAsRequest request = new PostWorkbookSaveAsRequest();
request.setName(remoteName);
request.setNewfilename(newfilename);
PdfSaveOptions saveOptions = new PdfSaveOptions();
saveOptions.setSaveFormat(format);
request.setSaveOptions(saveOptions);
request.setFolder(remoteFolder);
this.api.postWorkbookSaveAs(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
require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\CellsApi;
use \Aspose\Cells\Cloud\Request\PostWorkbookSaveAsRequest;
$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";
$format = "csv";
$newfilename = "outResult/PostExcelSaveAs.csv";
$saveOptions = new \Aspose\Cells\Cloud\Model\PdfSaveOptions();
$saveOptions->setSaveFormat($format );
$request = new PostWorkbookSaveAsRequest();
$request->setName( $remoteName);
$request->setNewfilename( $newfilename);
$request->setSaveOptions( $saveOptions);
$request->setFolder( $remoteFolder);
$cellsApi->postWorkbookSaveAs($request);
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
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'
format = "csv"
newfilename = "OutResult/PostExcelSaveAs.csv"
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)
saveOptions = AsposeCellsCloud::PdfSaveOptions.new(:SaveFormat=>format );
request = AsposeCellsCloud::PostWorkbookSaveAsRequest.new(:name=>remote_name,:newfilename=>newfilename,:saveOptions=>saveOptions,:folder=>remote_folder);
@instance.post_workbook_save_as(request);
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
import { CellsApi,PdfSaveOptions,PostWorkbookSaveAsRequest,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 format = "csv"
var newfilename = "OutResult/PostExcelSaveAs.csv"
var saveOptions = new PdfSaveOptions();
saveOptions.saveFormat = format ;
var request = new PostWorkbookSaveAsRequest();
request.name = remoteName;
request.newfilename = newfilename;
request.saveOptions = saveOptions;
request.folder = remoteFolder;
return cellsApi.postWorkbookSaveAs(request)
});
});
Python
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
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 = PostWorkbookSaveAsRequest( 'Book1.xlsx', "Book1.pdf",save_options= None,folder= 'PythonTest')
api.post_workbook_save_as(request)
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
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 $format = 'csv';
my $newfilename = 'outResult/PostExcelSaveAs.csv';
my $save_options = AsposeCellsCloud::Object::PdfSaveOptions->new();
$save_options->{save_format} = $format ;
my $request = AsposeCellsCloud::Request::PostWorkbookSaveAsRequest->new();
$request->{name} = $remoteName;
$request->{newfilename} = $newfilename;
$request->{save_options} = $save_options;
$request->{folder} = $remoteFolder;
$instance->post_workbook_save_as(request=> $request);
Go
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 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)
format := "csv"
newfilename := "OutResult/PostExcelSaveAs.csv"
var saveOptions = new(PdfSaveOptions)
saveOptions.SaveFormat = format
request := new(PostWorkbookSaveAsRequest)
request.Name = remoteName
request.Newfilename = newfilename
request.SaveOptions = saveOptions
request.Folder = remoteFolder
_, httpResponse, err := instance.PostWorkbookSaveAs(request)
if err != nil {
println(err.Error())
} else if httpResponse.StatusCode < 200 || httpResponse.StatusCode > 299 {
println("Fail")
}
}