This gist explains the steps and code snippet on how to convert XLSM to CSV format using Aspose.Cells Cloud SDK for .NET.
For more information, please visit
This gist explains the steps and code snippet on how to convert XLSM to CSV format using Aspose.Cells Cloud SDK for .NET.
For more information, please visit
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(); | |
} |