2. Convert to Spreadsheet Document Formats
Leave feedback
GroupDocs.Conversion Cloud REST API allows us to convert the supported document formats to Spreadsheet Document Formats and returns the output document storage URL and also support to get the result as a stream.
Convert to Spreadsheet Formats
You can convert the supported document formats to Spreadsheet Formats and returns the output document storage URL
Resource
The following GroupDocs.Conversion Cloud REST API resource has been used in the convert to spreadsheet Format example.
The API is completely independent of your operating system, database system or development language. We provide and support API SDKs in many development languages in order to make it even easier to integrate. You can see our available SDKs list here.
usingSystem;usingSystem.Collections.Generic;usingGroupDocs.Conversion.Cloud.Sdk.Api;usingGroupDocs.Conversion.Cloud.Sdk.Client;usingGroupDocs.Conversion.Cloud.Sdk.Model;usingGroupDocs.Conversion.Cloud.Sdk.Model.Requests;namespaceGroupDocs.Conversion.Cloud.Examples.CSharp{// Convert to Cells with load and save optionsclassConvert_To_Cells{publicstaticvoidRun(){varconfiguration=newConfiguration(Common.MyAppSid,Common.MyAppKey);varapiInstance=newConvertApi(configuration);try{// convert settingsvarsettings=newConvertSettings{StorageName=Common.MyStorage,FilePath="conversions/password-protected.docx",Format="xlsx",LoadOptions=newDocxLoadOptions(){Password="password"},ConvertOptions=newXlsxConvertOptions(){FromPage=1,PagesCount=1,Password="password",UsePdf=false},OutputPath="converted/tocells"};// convert to specified formatList<StoredConvertedResult>response=apiInstance.ConvertDocument(newConvertDocumentRequest(settings));Console.WriteLine("Document conveted successfully: "+response[0].Url);}catch(Exceptione){Console.WriteLine("Exception when calling ConvertApi: "+e.Message);}}}}
<?phpinclude(dirname(__DIR__).'\CommonUtils.php');$convertApi=CommonUtils::GetConvertApiInstance();try{$settings=newGroupDocs\Conversion\Model\ConvertSettings();$settings->setStorageName(CommonUtils::$MyStorage);$settings->setFilePath("conversions\\sample.docx");$settings->setFormat("xlsx");$loadOptions=newGroupDocs\Conversion\Model\DocxLoadOptions();$loadOptions->setPassword("");$loadOptions->setHideWordTrackedChanges(true);$settings->setLoadOptions($loadOptions);$convertOptions=newGroupDocs\Conversion\Model\XlsxConvertOptions();$convertOptions->setFromPage(1);$convertOptions->setFromPage(1);$settings->setConvertOptions($convertOptions);$settings->setOutputPath("converted\\tocells");$request=newGroupDocs\Conversion\Model\Requests\ConvertDocumentRequest($settings);$response=$convertApi->convertDocument($request);echo"Document converted successfully: ",$response[0]->getUrl();}catch(Exception$e){echo"Something went wrong: ",$e->getMessage(),"<br />";PHP_EOL;}?>
packageexamples.Working_With_Conversions;importcom.groupdocs.cloud.conversion.api.*;importcom.groupdocs.cloud.conversion.client.ApiException;importcom.groupdocs.cloud.conversion.model.*;importcom.groupdocs.cloud.conversion.model.requests.*;importexamples.Utils;importjava.util.List;publicclassConversion_Java_Convert_To_Cells{publicstaticvoidmain(String[]args){ConvertApiapiInstance=newConvertApi(Utils.AppSID,Utils.AppKey);try{ConvertSettingssettings=newConvertSettings();settings.setStorageName(Utils.MYStorage);settings.setFilePath("conversions\\password-protected.docx");settings.setFormat("xlsx");DocxLoadOptionsloadOptions=newDocxLoadOptions();loadOptions.setPassword("password");loadOptions.setHideWordTrackedChanges(true);loadOptions.setDefaultFont("Arial");settings.setLoadOptions(loadOptions);XlsxConvertOptionsconvertOptions=newXlsxConvertOptions();convertOptions.setFromPage(1);convertOptions.setPagesCount(2);convertOptions.setFromPage(1);convertOptions.setPassword("password");convertOptions.setUsePdf(true);settings.setConvertOptions(convertOptions);settings.setOutputPath("converted\\tocells");// convert to specified format
List<StoredConvertedResult>response=apiInstance.convertDocument(newConvertDocumentRequest(convertSettings));System.out.println("Document converted successfully: "+response.size());}catch(ApiExceptione){System.err.println("Exception while calling ConvertApi:");e.printStackTrace();}}}
# Load the gemrequire'groupdocs_conversion_cloud'require'common_utilities/Utils.rb'classWorking_With_Conversionsdefself.Conversion_Ruby_Convert_To_Cells()# Getting instance of the APIapi=Common_Utilities.Get_ConvertApi_Instance()$settings=GroupDocsConversionCloud::ConvertSettings.new()$settings.storage_name=$myStorage;$settings.file_path="conversions/password-protected.docx"$settings.format="xlsx"$loadOptions=GroupDocsConversionCloud::DocxLoadOptions.new()$loadOptions.password="password"$settings.load_options=$loadOptions;$convertOptions=GroupDocsConversionCloud::XlsxConvertOptions.new()$convertOptions.from_page=1$convertOptions.pages_count=1$convertOptions.password="password"$convertOptions.use_pdf=false$settings.convert_options=$convertOptions$settings.output_path="converted/tocells"$request=GroupDocsConversionCloud::ConvertDocumentRequest.new($settings)$response=api.convert_document($request)puts("Document converted successfully: "+($response).to_s)endend
# Import modulesimportgroupdocs_conversion_cloudfromCommon_Utilities.UtilsimportCommon_UtilitiesclassConversion_Python_Convert_To_Cells:@classmethoddefRun(self):# Create instance of the APIapi=Common_Utilities.Get_ConvertApi_Instance()try:settings=groupdocs_conversion_cloud.ConvertSettings()settings.storage_name=Common_Utilities.myStorage;settings.file_path="conversions\\password-protected.docx"settings.format="xlsx"loadOptions=groupdocs_conversion_cloud.DocxLoadOptions()loadOptions.password="password"settings.load_options=loadOptions;convertOptions=groupdocs_conversion_cloud.XlsxConvertOptions()convertOptions.from_page=1convertOptions.pages_count=1convertOptions.password="password"convertOptions.use_pdf=Falsesettings.convert_options=convertOptionssettings.output_path="converted\\tocells"request=groupdocs_conversion_cloud.ConvertDocumentRequest(settings)response=api.convert_document(request)print("Document converted successfully: "+str(response))exceptgroupdocs_conversion_cloud.ApiExceptionase:print("Exception while calling API: {0}".format(e.message))
// For complete examples and data files, please go to https://github.com/groupdocs-conversion-cloud/groupdocs-conversion-cloud-go-samples
packageconvertimport("fmt""os""github.com/groupdocs-conversion-cloud/groupdocs-conversion-cloud-go-samples/config""github.com/groupdocs-conversion-cloud/groupdocs-conversion-cloud-go/models")funcConvertToSpreadsheet(){settings:=models.ConvertSettings{Format:"xlsx",FilePath:"WordProcessing/four-pages.docx",OutputPath:"converted",}result,_,err:=config.Client.ConvertApi.ConvertDocument(config.Ctx,settings)iferr!=nil{fmt.Printf("ConvertToSpreadsheet error: %v\n",err)return}}
Convert to Spreadsheet Document Formats with Stream Output
You can convert the supported document formats to Spreadsheet Formats and get the output document as Stream
Resource
The following GroupDocs.Conversion Cloud REST API resource has been used in the convert to spreadsheet Format example.
The API is completely independent of your operating system, database system or development language. We provide and support API SDKs in many development languages in order to make it even easier to integrate. You can see our available SDKs list here.
usingSystem;usingSystem.Collections.Generic;usingSystem.IO;usingGroupDocs.Conversion.Cloud.Sdk.Api;usingGroupDocs.Conversion.Cloud.Sdk.Client;usingGroupDocs.Conversion.Cloud.Sdk.Model;usingGroupDocs.Conversion.Cloud.Sdk.Model.Requests;namespaceGroupDocs.Conversion.Cloud.Examples.CSharp{// Convert to Cells with load and save options with output as iostreamclassConvert_To_Cells_Stream{publicstaticvoidRun(){varconfiguration=newConfiguration(Common.MyAppSid,Common.MyAppKey);varapiInstance=newConvertApi(configuration);try{// convert settingsvarsettings=newConvertSettings{StorageName=Common.MyStorage,FilePath="conversions/password-protected.docx",Format="xlsx",LoadOptions=newDocxLoadOptions(){Password="password"},ConvertOptions=newXlsxConvertOptions(){FromPage=1,PagesCount=1,Password="password",UsePdf=false},OutputPath=null// set OutputPath as null will result the output as document IOStream};// convert to specified formatStreamresponse=apiInstance.ConvertDocumentDownload(newConvertDocumentRequest(settings));Console.WriteLine("Document conveted successfully: "+response.Length.ToString());}catch(Exceptione){Console.WriteLine("Exception when calling ConvertApi: "+e.Message);}}}}
<?phpinclude(dirname(__DIR__).'\CommonUtils.php');$convertApi=CommonUtils::GetConvertApiInstance();try{$settings=newGroupDocs\Conversion\Model\ConvertSettings();$settings->setStorageName(CommonUtils::$MyStorage);$settings->setFilePath("conversions\\sample.docx");$settings->setFormat("xlsx");$loadOptions=newGroupDocs\Conversion\Model\DocxLoadOptions();$loadOptions->setPassword("");$loadOptions->setHideWordTrackedChanges(true);$settings->setLoadOptions($loadOptions);$convertOptions=newGroupDocs\Conversion\Model\XlsxConvertOptions();$convertOptions->setFromPage(1);$convertOptions->setFromPage(1);$settings->setConvertOptions($convertOptions);// set OutputPath as empty will result the output as document Stream'
$settings->setOutputPath("");$request=newGroupDocs\Conversion\Model\Requests\ConvertDocumentRequest($settings);$response=$convertApi->convertDocumentDownload($request);echo"Document converted successfully: Document Size: ",$response->getSize();}catch(Exception$e){echo"Something went wrong: ",$e->getMessage(),"<br />";PHP_EOL;}?>
packageexamples.Working_With_Conversions;importcom.groupdocs.cloud.conversion.api.*;importcom.groupdocs.cloud.conversion.client.ApiException;importcom.groupdocs.cloud.conversion.model.*;importcom.groupdocs.cloud.conversion.model.requests.*;importexamples.Utils;importjava.util.stream.*;publicclassConversion_Java_Convert_To_Cells_Stream{publicstaticvoidmain(String[]args){ConvertApiapiInstance=newConvertApi(Utils.AppSID,Utils.AppKey);try{ConvertSettingssettings=newConvertSettings();settings.setStorageName(Utils.MYStorage);settings.setFilePath("conversions\\password-protected.docx");settings.setFormat("xlsx");DocxLoadOptionsloadOptions=newDocxLoadOptions();loadOptions.setPassword("password");loadOptions.setHideWordTrackedChanges(true);loadOptions.setDefaultFont("Arial");settings.setLoadOptions(loadOptions);XlsxConvertOptionsconvertOptions=newXlsxConvertOptions();convertOptions.setFromPage(1);convertOptions.setPagesCount(2);convertOptions.setFromPage(1);convertOptions.setPassword("password");convertOptions.setUsePdf(true);settings.setConvertOptions(convertOptions);// set OutputPath as empty will result the output as document IOStream
settings.setOutputPath("");// convert to specified format
Streamresponse=apiInstance.convertDocument(newConvertDocumentRequest(convertSettings));System.out.println("Document converted successfully: "+response);}catch(ApiExceptione){System.err.println("Exception while calling ConvertApi:");e.printStackTrace();}}}
# Load the gemrequire'groupdocs_conversion_cloud'require'common_utilities/Utils.rb'classWorking_With_Conversionsdefself.Conversion_Ruby_Convert_To_Cells_Stream()# Getting instance of the APIapi=Common_Utilities.Get_ConvertApi_Instance()$settings=GroupDocsConversionCloud::ConvertSettings.new()$settings.storage_name=$myStorage;$settings.file_path="conversions/password-protected.docx"$settings.format="xlsx"$loadOptions=GroupDocsConversionCloud::DocxLoadOptions.new()$loadOptions.password="password"$settings.load_options=$loadOptions;$convertOptions=GroupDocsConversionCloud::XlsxConvertOptions.new()$convertOptions.from_page=1$convertOptions.pages_count=1$convertOptions.password="password"$convertOptions.use_pdf=false$settings.convert_options=$convertOptions# leave OutputPath will result the output as document IOStream$request=GroupDocsConversionCloud::ConvertDocumentRequest.new($settings)$response=api.convert_document($request)puts("Document converted successfully: "+($response.length).to_s)endend
"use strict";classConversion_Node_Convert_To_Cells_Stream{staticRun(){varsettings=newgroupdocs_conversion_cloud_1.ConvertSettings();settings.storageName=myStorage;settings.filePath="conversions/password-protected.docx";settings.format="xlsx";varloadOptions=newgroupdocs_conversion_cloud_1.DocxLoadOptions();loadOptions.password="password";settings.loadOptions=loadOptions;varconvertOptions=newgroupdocs_conversion_cloud_1.XlsxConvertOptions();convertOptions.fromPage=1;convertOptions.pagesCount=1;convertOptions.password="password";convertOptions.usePdf=false;settings.convertOptions=convertOptions;settings.outputPath=null;// set OutputPath as null will result the output as document IOStream
varrequest=newgroupdocs_conversion_cloud_1.ConvertDocumentRequest(settings);convertApi.convertDocumentDownload(request).then(function(response){console.log("Document converted successfully: "+response.length);}).catch(function(error){console.log("Error: "+error.message);});}}module.exports=Conversion_Node_Convert_To_Cells_Stream;
# Import modulesimportgroupdocs_conversion_cloudfromCommon_Utilities.UtilsimportCommon_UtilitiesclassConversion_Python_Convert_To_Cells_Stream:@classmethoddefRun(self):# Create instance of the APIapi=Common_Utilities.Get_ConvertApi_Instance()try:settings=groupdocs_conversion_cloud.ConvertSettings()settings.storage_name=Common_Utilities.myStorage;settings.file_path="conversions\\password-protected.docx"settings.format="xlsx"loadOptions=groupdocs_conversion_cloud.DocxLoadOptions()loadOptions.password="password"settings.load_options=loadOptions;convertOptions=groupdocs_conversion_cloud.XlsxConvertOptions()convertOptions.from_page=1convertOptions.pages_count=1convertOptions.password="password"convertOptions.use_pdf=Falsesettings.convert_options=convertOptionssettings.output_path=None# leave OutputPath will result the output as document IOStreamrequest=groupdocs_conversion_cloud.ConvertDocumentRequest(settings)response=api.convert_document_download(request)print("Document converted successfully: "+str(len(response)))exceptgroupdocs_conversion_cloud.ApiExceptionase:print("Exception while calling API: {0}".format(e.message))
// For complete examples and data files, please go to https://github.com/groupdocs-conversion-cloud/groupdocs-conversion-cloud-go-samples
packageconvertimport("fmt""os""github.com/groupdocs-conversion-cloud/groupdocs-conversion-cloud-go-samples/config""github.com/groupdocs-conversion-cloud/groupdocs-conversion-cloud-go/models")funcConvertToSpreadsheet(){settings:=models.ConvertSettings{Format:"xlsx",FilePath:"WordProcessing/four-pages.docx",}result,_,err:=config.Client.ConvertApi.ConvertDocument(config.Ctx,settings)iferr!=nil{fmt.Printf("ConvertToSpreadsheet error: %v\n",err)return}// Get file info
fileInfo,errInfo:=result.Stat()iferrInfo!=nil{t.Error(errInfo)}// Get the size of the file
fileSize:=fileInfo.Size()}
Convert to Spreadsheet with Advanced Options
This example demonstrates how to convert word processing documents into a spreadsheet with advanced conversion options.
There are steps that usage of GroupDocs.Conversion Cloud consists of:
Step 3 is not needed if the “OutputPath” option is not provided: the convert API method will return the converted document in the response body.
Resource
HTTPPOST~/conversion
Swagger UI lets you call this REST API directly from the browser.
cURL example
# First get JSON Web Token# Please get your Client Id and Client Secret from https://dashboard.groupdocs.cloud/applications. Kindly place Client Id in "client_id" and Client Secret in "client_secret" argument.curl -v "https://api.groupdocs.cloud/connect/token"\
-X POST \
-d "grant_type#client_credentials&client_id#xxxx&client_secret#xxxx"\
-H "Content-Type: application/x-www-form-urlencoded"\
-H "Accept: application/json"# cURL example to convert documentcurl -v "https://api.groupdocs.cloud/v2.0/conversion/conversion"\
-X POST \
-H "Content-Type: application/json"\
-H "Accept: application/json"\
-H "Authorization: Bearer <jwt token>"-d "{
'FilePath': 'WordProcessing/four-pages.docx',
'Format': 'xlsx',
'ConvertOptions': {
'FromPage': 2,
'PagesCount': 1,
'Zoom': 150
},
'OutputPath': 'Output'
}"
The API is completely independent of your operating system, database system or development language. We provide and support API SDKs in many development languages in order to make it even easier to integrate. You can see our available SDKs list here.
// For complete examples and data files, please go to https://github.com/groupdocs-conversion-cloud/groupdocs-conversion-cloud-dotnet-samplesstringMyAppKey="";// Get AppKey and AppSID from https://dashboard.groupdocs.cloudstringMyAppSid="";// Get AppKey and AppSID from https://dashboard.groupdocs.cloudvarconfiguration=newConfiguration(MyAppSid,MyAppKey);// Create necessary API instancesvarapiInstance=newConvertApi(configuration);// Prepare convert settingsvarsettings=newConvertSettings{FilePath="WordProcessing/four-pages.docx",Format="xlsx",ConvertOptions=newSpreadsheetConvertOptions(){FromPage=2,PagesCount=1,Zoom=150},OutputPath="converted"};// Convert to specified formatvarresponse=apiInstance.ConvertDocument(newConvertDocumentRequest(settings));
// For complete examples and data files, please go to https://github.com/groupdocs-conversion-cloud/groupdocs-conversion-cloud-java-samples
StringMyAppKey="";// Get AppKey and AppSID from https://dashboard.groupdocs.cloud
StringMyAppSid="";// Get AppKey and AppSID from https://dashboard.groupdocs.cloud
Configurationconfiguration=newConfiguration(MyAppSid,MyAppKey);// Create API instance
ConvertApiapiInstance=newConvertApi(configuration);// Prepare convert settings
ConvertSettingssettings=newConvertSettings();settings.setFilePath("WordProcessing/four-pages.docx");settings.setFormat("xlsx");SpreadsheetConvertOptionsconvertOptions=newSpreadsheetConvertOptions();convertOptions.setFromPage(2);convertOptions.setPagesCount(1);convertOptions.setZoom(150);settings.setConvertOptions(convertOptions);settings.setOutputPath("converted");List<StoredConvertedResult>result=apiInstance.convertDocument(newConvertDocumentRequest(settings));
// For complete examples and data files, please go to https://github.com/groupdocs-conversion-cloud/groupdocs-conversion-cloud-php-samples
useGroupDocs\Conversion\Model;useGroupDocs\Conversion\Model\Requests;$AppSid="";// Get AppKey and AppSID from https://dashboard.groupdocs.cloud
$AppKey="";// Get AppKey and AppSID from https://dashboard.groupdocs.cloud
$configuration=newGroupDocs\Conversion\Configuration();$configuration->setAppSid($AppSid);$configuration->setAppKey($AppKey);$apiInstance=newGroupDocs\Conversion\ConvertApi($configuration);// Prepare convert settings
$settings=newModel\ConvertSettings();$settings->setFilePath("WordProcessing/four-pages.docx");$settings->setFormat("xlsx");$convertOptions=newModel\SpreadsheetConvertOptions();$convertOptions->setFromPage(2);$convertOptions->setPagesCount(1);$convertOptions->setZoom(150);$settings->setConvertOptions($convertOptions);$settings->setOutputPath("converted");// Convert
$result=$apiInstance->convertDocument(newRequests\ConvertDocumentRequest($settings));
# For complete examples and data files, please go to https://github.com/groupdocs-conversion-cloud/groupdocs-conversion-cloud-ruby-samplesrequire'groupdocs_conversion_cloud'$app_sid="XXXX-XXXX-XXXX-XXXX"# Get AppKey and AppSID from https://dashboard.groupdocs.cloud$app_key="XXXXXXXXXXXXXXXX"# Get AppKey and AppSID from https://dashboard.groupdocs.cloud# Create necessary API instancesapiInstance=GroupDocsConversionCloud::ConvertApi.from_keys($app_sid,$app_key)# Prepare convert settingssettings=GroupDocsConversionCloud::ConvertSettings.newsettings.file_path="WordProcessing/four-pages.docx"settings.format="xlsx"convertOptions=GroupDocsConversionCloud::SpreadsheetConvertOptions.newconvertOptions.from_page=2convertOptions.pages_count=1convertOptions.zoom=150settings.convert_options=convertOptionssettings.output_path="converted"# Convertresult=apiInstance.convert_document(GroupDocsConversionCloud::ConvertDocumentRequest.new(settings))
// For complete examples and data files, please go to https://github.com/groupdocs-conversion-cloud/groupdocs-conversion-cloud-node-samples
global.conversion_cloud=require("groupdocs-conversion-cloud");global.appSid="XXXX-XXXX-XXXX-XXXX";// Get AppKey and AppSID from https://dashboard.groupdocs.cloud
global.appKey="XXXXXXXXXXXXXXXX";// Get AppKey and AppSID from https://dashboard.groupdocs.cloud
global.convertApi=conversion_cloud.ConvertApi.fromKeys(appSid,appKey);letsettings=newconversion_cloud.ConvertSettings();settings.filePath="WordProcessing/four-pages.docx";settings.format="xlsx";letconvertOptions=newconversion_cloud.SpreadsheetConvertOptions();convertOptions.fromPage=2;convertOptions.pagesCount=1;convertOptions.zoom=150;settings.convertOptions=convertOptionssettings.outputPath="converted";letresult=awaitconvertApi.convertDocument(newconversion_cloud.ConvertDocumentRequest(settings));
# For complete examples and data files, please go to https://github.com/groupdocs-conversion-cloud/groupdocs-conversion-cloud-python-samplesimportgroupdocs_conversion_cloudapp_sid="XXXX-XXXX-XXXX-XXXX"# Get AppKey and AppSID from https://dashboard.groupdocs.cloudapp_key="XXXXXXXXXXXXXXXX"# Get AppKey and AppSID from https://dashboard.groupdocs.cloud# Create necessary API instancesapiInstance=groupdocs_conversion_cloud.ConvertApi.from_keys(Common.app_sid,Common.app_key)# Prepare convert settingssettings=groupdocs_conversion_cloud.ConvertSettings()settings.file_path="WordProcessing/four-pages.docx"settings.format="xlsx"settings.convert_options=groupdocs_conversion_cloud.SpreadsheetConvertOptions()settings.output_path="converted"# Convertresult=apiInstance.convert_document(groupdocs_conversion_cloud.ConvertDocumentRequest(settings))
// For complete examples and data files, please go to https://github.com/groupdocs-conversion-cloud/groupdocs-conversion-cloud-go-samples
packageconvertimport("fmt""github.com/groupdocs-conversion-cloud/groupdocs-conversion-cloud-go-samples/config""github.com/groupdocs-conversion-cloud/groupdocs-conversion-cloud-go/models")funcConvertToSpreadsheet(){settings:=models.ConvertSettings{Format:"xlsx",FilePath:"WordProcessing/four-pages.docx",OutputPath:"converted",ConvertOptions:&models.SpreadsheetConvertOptions{FromPage:2,PagesCount:1,Zoom:150,},}result,_,err:=config.Client.ConvertApi.ConvertDocument(config.Ctx,settings)iferr!=nil{fmt.Printf("ConvertToSpreadsheet error: %v\n",err)return}fmt.Printf("Document converted successfully: %v\n",result[0].Url)}
Was this page helpful?
Any additional feedback you'd like to share with us?
Please tell us how we can improve this page.
Thank you for your feedback!
We value your opinion. Your feedback will help us improve our documentation.