How to Save or Export Spreadsheets

// Import the necessary namespace for IronXL
using IronXL;

// Create a new Excel WorkBook document
WorkBook workBook = WorkBook.Create();

// Create a blank WorkSheet named "new_sheet"
WorkSheet workSheet = workBook.CreateWorkSheet("new_sheet");

// Save the Excel file as .xls
// The Excel file can also be saved in other formats like XLSX, XLSM, CSV, TSV, JSON, XML, HTML 
// by changing the file extension in the SaveAs method
workBook.SaveAs("sample.xls");

' Import the necessary namespace for IronXL
Imports IronXL

' Create a new Excel WorkBook document
Private workBook As WorkBook = WorkBook.Create()

' Create a blank WorkSheet named "new_sheet"
Private workSheet As WorkSheet = workBook.CreateWorkSheet("new_sheet")

' Save the Excel file as .xls
' The Excel file can also be saved in other formats like XLSX, XLSM, CSV, TSV, JSON, XML, HTML 
' by changing the file extension in the SaveAs method
workBook.SaveAs("sample.xls")

using IronXL;

// This code demonstrates creating an Excel workbook with multiple worksheets,
// populating cells with data, and saving the workbook in various formats.

// Create a new Excel WorkBook document
WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLSX);

// Create two WorkSheets and name them "sheet1" and "sheet2"
WorkSheet workSheet1 = workBook.CreateWorkSheet("sheet1");
WorkSheet workSheet2 = workBook.CreateWorkSheet("sheet2");

// Input data in the first cell of each worksheet
workSheet1["A1"].StringValue = "Data in A1 of sheet1";
workSheet2["A1"].StringValue = "Data in A1 of sheet2";

// Save the workbook as a CSV file
workBook.SaveAs("sample.csv", fileFormat: ExcelFileFormat.CSV);

// Save the workbook as a JSON file
workBook.SaveAs("sample.json", fileFormat: ExcelFileFormat.JSON);

// Save the workbook as an XML file
workBook.SaveAs("sample.xml", fileFormat: ExcelFileFormat.XML);

// Export the workbook as an HTML file
workBook.ExportToHtml("sample.html");

Imports IronXL

' This code demonstrates creating an Excel workbook with multiple worksheets,
' populating cells with data, and saving the workbook in various formats.

' Create a new Excel WorkBook document
Private workBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)

' Create two WorkSheets and name them "sheet1" and "sheet2"
Private workSheet1 As WorkSheet = workBook.CreateWorkSheet("sheet1")
Private workSheet2 As WorkSheet = workBook.CreateWorkSheet("sheet2")

' Input data in the first cell of each worksheet
Private workSheet1("A1").StringValue = "Data in A1 of sheet1"
Private workSheet2("A1").StringValue = "Data in A1 of sheet2"

' Save the workbook as a CSV file
workBook.SaveAs("sample.csv", fileFormat:= ExcelFileFormat.CSV)

' Save the workbook as a JSON file
workBook.SaveAs("sample.json", fileFormat:= ExcelFileFormat.JSON)

' Save the workbook as an XML file
workBook.SaveAs("sample.xml", fileFormat:= ExcelFileFormat.XML)

' Export the workbook as an HTML file
workBook.ExportToHtml("sample.html")

using IronXL;
using System.IO;

// Create a new Excel WorkBook document
WorkBook workBook = WorkBook.Create();

// Create a blank WorkSheet with the specified name
WorkSheet workSheet = workBook.CreateWorkSheet("new_sheet");

// Export the workbook to an HTML formatted string
string htmlString = workBook.ExportToHtmlString();

// Export the workbook as a binary array
// This can be useful for situations where you need to work with raw binary data, 
// such as saving to a binary file format or transmitting over a network.
byte[] binary = workBook.ToByteArray(); // Note: ToBinary() method is not valid. It should be ToByteArray().

// Export the workbook as a Stream
// Streams are useful for writing the workbook to a file, sending over a network, etc.
Stream stream = workBook.ToStream();

// Export the workbook as a DataSet
// This allows easy integration with DataGrids, SQL, and Entity Framework (EF).
System.Data.DataSet dataSet = workBook.ToDataSet();

Imports IronXL
Imports System.IO

' Create a new Excel WorkBook document
Private workBook As WorkBook = WorkBook.Create()

' Create a blank WorkSheet with the specified name
Private workSheet As WorkSheet = workBook.CreateWorkSheet("new_sheet")

' Export the workbook to an HTML formatted string
Private htmlString As String = workBook.ExportToHtmlString()

' Export the workbook as a binary array
' This can be useful for situations where you need to work with raw binary data, 
' such as saving to a binary file format or transmitting over a network.
Private binary() As Byte = workBook.ToByteArray() ' Note: ToBinary() method is not valid. It should be ToByteArray().

' Export the workbook as a Stream
' Streams are useful for writing the workbook to a file, sending over a network, etc.
Private stream As Stream = workBook.ToStream()

' Export the workbook as a DataSet
' This allows easy integration with DataGrids, SQL, and Entity Framework (EF).
Private dataSet As System.Data.DataSet = workBook.ToDataSet()