This gist contains code snippets related to conversion of XLSB files to JPEG format using Aspose.Cells Cloud SDK for .NET

readme.md

This gist explains the steps and code snippet on how to convert XLSB to JPEG format using Aspose.Cells Cloud SDK for .NET.

For more information, please visit

• XLSB to JPEG - Convert XLSB to JPEG in C#

Convert XLSB to JPEG in C#

This gist contains code snippets related to conversion of XLSB files to JPEG format using Aspose.Cells Cloud SDK for .NET

convert-xlsb-to-jpeg.cs

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

// Get client credentials from https://dashboard.aspose.cloud/
string clientSecret = "d757548a9f2558c39c2feebdf85b4c44";
string clientID = "4db2f826-bf9c-42e7-8b2a-8cbca2d15553";
        
// create CellsApi instance while passing ClientID and ClientSecret
CellsApi instance = new CellsApi(clientID, clientSecret);

// name of input Excel file
string name = "TestCase.xlsb";
// name of resultant file
string resultantFile = "converted.jpeg";

// format of resultant file
string format = "JPEG";

// vertical and horizontal resolution for image
int? verticalResolution = 800;
int? horizontalResolution = 600;

// name of worksheet in workbook
string sheetName = "Sheet2";
        
try
{
    // load XLSB file from local drive
    using (var file = System.IO.File.OpenRead(@"C:\Users\Downloads\" + name))
    {
        // perform conversion and save output to Stream isntance
        var response = instance.CellsWorksheetsGetWorksheet(name, sheetName, format, verticalResolution, horizontalResolution, null, null, null); 
        
        if (response != null && response.Equals("OK"))
        {
            // display confirmation message in console
            Console.WriteLine("Successfully converted XLSB to JPEG !");
            Console.ReadKey();
        }
    
    // call method to save the output on system drive
    saveToDisk(response, @"C:\Users\shahbnay\Downloads\" + resultantFile);
    }
}catch (Exception ex)
{
    Console.WriteLine("error:" + ex.Message + "\n" + ex.StackTrace);
}

// custom method to save stream over system
static void saveToDisk(Stream responseStream, String resultantFile)
{
    var fileStream = File.Create(resultantFile);
    responseStream.Seek(0, SeekOrigin.Begin);
    responseStream.CopyTo(fileStream);
    fileStream.Close();
}

The Gist is marked as Public