Export LISTOBJECT object to CSV format file using Cells Cloud SDK for C#
API
POST
https://api.aspose.cloud/v3.0/cells/export
Export LISTOBJECT object to CSV file from Excel file is a complex task. Export LISTOBJECT to CSV format transitions is performed by our C# SDK while maintaining the source LISTOBJECT spreadsheet's main structural and logical content. Our C# library is a professional solution to export LISTOBJECT objects to CSV format files online. This Cloud SDK gives C# developers powerful functionality and perfect CSV output.
Code example in C# using REST API to export LISTOBJECT to CSV format from spreadsheet
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
string format = "csv";
string objectType ="listobject";
LightCellsApi lightCellsApi =
new LightCellsApi(Environment.GetEnvironmentVariable("ProductClientId"), Environment.GetEnvironmentVariable("ProductClientSecret"));
IDictionary<string ,Stream> files = new Dictionary<string ,Stream>();
files.Add("Book1.xlsx" , File.OpenRead("Book1.xlsx"));
files.Add("myDocument.xlsx", File.OpenRead("myDocument.xlsx"));
var filesResult = lightCellsApi.PostExport(files, objectType, format);
foreach (var file in filesResult.Files)
{
string v = file.FileContent;
string filename = file.Filename;
byte[] workbookData = System.Convert.FromBase64String(v);
MemoryStream memoryStream = new MemoryStream(workbookData, 0, workbookData.Length);
memoryStream.Seek(0, SeekOrigin.Begin);
using (FileStream fileStream = File.Create( filename))
{
fileStream.Position = 0;
memoryStream.CopyTo(fileStream);
fileStream.Close();
}
}
How to use Cells Cloud SDK for Net to export objects from Excel LISTOBJECT to CSV
- Register an account at Dashboard to get free API quota & authorization details
- Initialize the Cells API with your Client ID, Client Secret, Base URL, and API version.
- Use the `postExport` method to retrieve the resulting stream.
System Requirements
- NET Framework 4.5.2 or newer
- Net Standard 2.0 or newer