スプレッドシートを保存またはエクスポートする方法

using IronXL;

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

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

// Save the excel file as XLS, XLSX, XLSM, CSV, TSV, JSON, XML, HTML
workBook.SaveAs("sample.xls");

Imports IronXL

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

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

' Save the excel file as XLS, XLSX, XLSM, CSV, TSV, JSON, XML, HTML
workBook.SaveAs("sample.xls")

using IronXL;

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

// Create three WorkSheets
WorkSheet workSheet1 = workBook.CreateWorkSheet("sheet1");
WorkSheet workSheet2 = workBook.CreateWorkSheet("sheet2");

// Input information
workSheet1["A1"].StringValue = "A1";
workSheet2["A1"].StringValue = "A1";

// Save as CSV
workBook.SaveAsCsv("sample.csv");

// Save as JSON
workBook.SaveAsJson("sample.json");

// Save as XML
workBook.SaveAsXml("sample.xml");

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

Imports IronXL

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

' Create three WorkSheets
Private workSheet1 As WorkSheet = workBook.CreateWorkSheet("sheet1")
Private workSheet2 As WorkSheet = workBook.CreateWorkSheet("sheet2")

' Input information
Private workSheet1("A1").StringValue = "A1"
Private workSheet2("A1").StringValue = "A1"

' Save as CSV
workBook.SaveAsCsv("sample.csv")

' Save as JSON
workBook.SaveAsJson("sample.json")

' Save as XML
workBook.SaveAsXml("sample.xml")

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

using IronXL;
using System.IO;

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

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

// Export to HTML string
string htmlString = workBook.ExportToHtmlString();

// Export as Byte array
byte[] binary = workBook.ToBinary();
byte[] byteArray = workBook.ToByteArray();

// Export as Stream
Stream stream = workBook.ToStream();

// Export as DataSet
System.Data.DataSet dataSet = workBook.ToDataSet(); // Allow easy integration with DataGrids, SQL and EF

Imports IronXL
Imports System.IO

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

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

' Export to HTML string
Private htmlString As String = workBook.ExportToHtmlString()

' Export as Byte array
Private binary() As Byte = workBook.ToBinary()
Private byteArray() As Byte = workBook.ToByteArray()

' Export as Stream
Private stream As Stream = workBook.ToStream()

' Export as DataSet
Private dataSet As System.Data.DataSet = workBook.ToDataSet() ' Allow easy integration with DataGrids, SQL and EF