Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
This gist contains code snippets related to conversion of XLSM files to CSV format using Aspose.Cells Cloud SDK for .NET
This gist contains code snippets related to conversion of XLSM files to CSV format using Aspose.Cells Cloud SDK for .NET
// 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.xlsm";
// name of resultant file
string resultantFile = "converted.csv";
// format of resultant file
string format = "CSV";
// name of worksheet in workbook
string sheetName = "Sheet2";
try
{
// load XLSM 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, null, null, null, null, null);
if (response != null && response.Equals("OK"))
{
// display confirmation message in console
Console.WriteLine("Successfully converted XLSM to CSV !");
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();
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment