How do I export a worksheet as image?


#1

I’m trying to export a worksheet as png or jpg using the C# SDK.
Unfortunately the method GetWorkSheetWithFormat referenced in the documentation https://docs.aspose.cloud/display/cellscloud/Convert+Worksheet+to+Image doesn’t exist.
I tried
var apiResponse = cellsApi.CellsWorksheetsGetWorksheet(@“Anhang.xlsx”, “VMP V1.0”, 128, 128);
but this gives me a JSON.
Thank you


#2

@jojogeyer

Thank you for contacting Aspose Support.

format parameter is missing in the CellsWorksheetsGetWorksheet API of our revamped .NET SDK. We are working to fix this issue at the earliest (CELLSCLOUD-10156).

Meanwhile just to show how the API should look like I have written the following cURL example:

// First get Access Token
// Get App Key and App SID from https://dashboard.aspose.cloud/
curl -v "https://api.aspose.cloud/oauth2/token" \
-X POST \
-d 'grant_type=client_credentials&client_id=0B17F60A-6D69-426B-9ABD-79F35A6E9F7B&client_secret=53b8b19adffa41a3e87dbbd8858977ae' \
-H "Content-Type: application/x-www-form-urlencoded" \
-H "Accept: application/json"
 
// cURL example to convert Worksheet to Image 
curl -v "https://api.aspose.cloud/v1.1/cells/test_cells.xlsx/worksheets/Sheet1?format=gif" \
-X GET \
-H "Content-Type: application/json" \
-H "Accept: multipart/form-data" \
-H "Authorization: Bearer E69aetfC9JqHo-aXX823s1FwFXpMzgpEjtvV82tqU-pvg0hZnOtyaEHVCSa5fjbCCjvth0ArFUn-q0LQjvlV1RinyKXIE7ydAoDQhUYw6refUm9IaiNXPr6CcPAAee-r98BcTCOwywkOfrW_9VqXDKt-ypoFbXLL86emx4W-YVS9_M2GA_LlFAMLVc68IN8bLlX6gY84TiHUsn0Ry5DlcZpEhU4fRL6DTbOoGnJskvCSHxnTWH0s92gfBmAmV4KalB--Jjd4lgqEc8OkwbVkLHL_qpe4pO39y521IsL8In4fQjnaVdNSYIQJSRHMr18DxEq20rde7_wT0tuD03lPMdK8MTLno9RSPswYgzaZa5jsO1tsGIwoykgbXWbaP49AW-ht7_1HeXUMPiCVbnSOPs71jRtWpaw35Qb29LIwQmiqP7P-iq8BkP20xQ59hyU0bNSUJMch8Euxo_Lm6B1ySSrS1kdyxFGRWLdWhtS61GKjaD7d" \
-o Sheet1.gif

Input File: test_cells.xlsx.zip (873.6 KB)
Output File: Sheet1.gif (58.6 KB)

The supported image formats are:

  • jpeg
  • png
  • emf
  • bmp
  • gif