Получить MaxColumn из Excel Worksheet

Этот REST API указывает на то, что шоу получает maxcolumn в файле Excel, когда параметр cellOrMethodName равен maxcolumn.

cURL Пример

Request


curl -X GET "http://api.aspose.com/v3.0/cells/myWorkbook.xlsx/worksheets/Sheet1/cells/maxcolumn"  -H "Content-Type: application/json" -H "Accept: application/json"

Response

{}

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

	public partial class CellsApiExample
	{
	public void GetWorksheetCellMaxColumnExample()
	{
	string CellsCloudClientId ="....";//get from https://dashboard.aspose.cloud/#/applications
	string CellsCloudClientSecret="...";//get from https://dashboard.aspose.cloud/#/applications
	GetWorksheetCellRequest request = new GetWorksheetCellRequest { name = "Book1.xlsx", sheetName = "Sheet1", cellOrMethodName = "maxcolumn", folder = "TestData/In" };
	cellsApi.GetWorksheetCell(request);
	}
	}
	}
	// Obsolet
	//CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
	//string name = BOOK1;
	//string sheetName = SHEET1;
	//string cellOrMethodName = "maxcolumn";
	//string folder = TEMPFOLDER;
	//instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
	//var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
	//Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");

view raw Examples-DotNET-CSharp-Cells-GetMaxColumnWorksheet-1.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);
	GetWorksheetCellRequest request = new GetWorksheetCellRequest();
	request.setName(remoteName);
	request.setSheetName("Sheet1");
	request.setCellOrMethodName("maxcolumn");
	request.setFolder(remoteFolder);
	request.setStorageName("");

	String response = api.getWorksheetCell(request);

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

view raw Examples-Java-cells-GetMaxColumnWorksheet-get-max-column.java hosted with ❤ by GitHub

PHP

	<?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\GetWorksheetCellRequest;

	class Cell {

	public $instance;

	public function __construct() {
	$this->instance = new CellsApi(getenv("CellsCloudClientId"),getenv("CellsCloudClientSecret"),"v3.0",getenv("CellsCloudApiBaseUrl"));
	}

	public function getWorksheetCell() {
	$remoteFolder = "TestData/In";
	$localName = "Book1.xlsx";
	$remoteName = "Book1.xlsx";
	$request = new GetWorksheetCellRequest();
	$request->setName( $remoteName);
	$request->setSheetName( "Sheet1");
	$request->setCellOrMethodName( "maxcolumn");
	$request->setFolder( $remoteFolder);
	$request->setStorageName( "");
	$this->instance->getWorksheetCell($request);
	}
	}

	$instance = new Cell();
	$instance->getWorksheetCell();

	?>

view raw Examples-PHP-Cells-GetWorksheetMaxColumn.php hosted with ❤ by GitHub

Ruby

	# 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

	# Read cell data by cell's name.
	def read_cell_data_by_cell_name
	name = $BOOK1
	sheet_name = $SHEET1
	cell_or_method_name = 'maxcolumn'
	folder = $TEMPFOLDER
	storage = nil
	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_get_worksheet_cell(name, sheet_name, cell_or_method_name, { :folder=>folder})
	print(result)
	end

	end

	cell = Cell.new()
	puts cell.read_cell_data_by_cell_name

view raw Examples-Ruby-Cells-get_worksheet_max_column.rb hosted with ❤ by GitHub

Node.js

	const { CellsApi, UploadFileRequest, Cells_GetWorksheetCellRequest } = 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 Cells_GetWorksheetCellRequest();
	req.name = filename;
	req.sheetName = "Sheet1";
	req.cellOrMethodName = 'A1';
	req.folder = "Temp";
	cellsApi.cellsGetWorksheetCell(req)
	.then((result) => {
	req.cellOrMethodName = 'firstcell';
	req.folder = "Temp";
	cellsApi.cellsGetWorksheetCell(req)
	.then((result) => {
	req.cellOrMethodName = 'endcell';
	req.folder = "Temp";
	cellsApi.cellsGetWorksheetCell(req)
	.then((result) => {
	req.cellOrMethodName = 'maxrow';
	req.folder = "Temp";
	cellsApi.cellsGetWorksheetCell(req)
	.then((result) => {
	req.cellOrMethodName = 'maxdatarow';
	req.folder = "Temp";
	cellsApi.cellsGetWorksheetCell(req)
	.then((result) => {
	req.cellOrMethodName = 'maxcolumn';
	req.folder = "Temp";
	cellsApi.cellsGetWorksheetCell(req)
	.then((result) => {
	req.cellOrMethodName = 'maxdatacolumn';
	req.folder = "Temp";
	cellsApi.cellsGetWorksheetCell(req)
	.then((result) => {
	req.cellOrMethodName = 'minrow';
	req.folder = "Temp";
	cellsApi.cellsGetWorksheetCell(req)
	.then((result) => {
	req.cellOrMethodName = 'mindatarow';
	req.folder = "Temp";
	cellsApi.cellsGetWorksheetCell(req)
	.then((result) => {
	req.cellOrMethodName = 'mincolumn';
	req.folder = "Temp";
	cellsApi.cellsGetWorksheetCell(req)
	.then((result) => {
	req.cellOrMethodName = 'mindatacolumn';
	req.folder = "Temp";
	cellsApi.cellsGetWorksheetCell(req)
	.then((result) => {
	console.log("cellsGetWorksheetCell test done.")
	})
	})
	})
	})
	})
	})
	})
	})
	})
	})

	})
	})

view raw Examples-Node.js-SDK-Cells-GetMaxColumnWorksheet-1.js hosted with ❤ by GitHub

Python

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	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 = GetWorksheetCellRequest( 'Book1.xlsx', 'Sheet1', 'maxcolumn',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_cell(request)

view raw GetMaxColumnFromExcelWorksheet.py hosted with ❤ by GitHub

Android

Swift

Perl

	# 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::GetWorksheetCellRequest->new();
	$request->{name} = $remoteName;
	$request->{sheet_name} = 'Sheet1';
	$request->{cell_or_method_name} = 'maxcolumn';
	$request->{folder} = $remoteFolder;
	$request->{storage_name} = '';
	my $result = $api->get_worksheet_cell(request=> $request);

view raw Examples-Perl-Cells-GetMaxColumnWorksheet-1.pl hosted with ❤ by GitHub

Получить MaxDataRow из Excel Worksheet Получить MaxDataColumn из Excel Worksheet