各形式は特定のユースケースに対応しており、CSV はデータベースのインポートに、JSON は Web API に、XML は企業システムとの統合に使用されます。 他のアプリケーションと統合するために、これらのフォーマットをそれぞれの出力ストリームにエクスポートします。 ライブラリは、すべてのスプレッドシートファイルタイプ変換を内部で処理し、プロセス全体を通してデータの整合性を維持します。
using IronXL;// Import .xls, .csv, or .tsv fileWorkBook workbook = WorkBook.Load("XlsFile.xls");// Export as .xlsx fileworkbook.SaveAs("newFile.xlsx");
using IronXL;
// Import .xls, .csv, or .tsv file
WorkBook workbook = WorkBook.Load("XlsFile.xls");
// Export as .xlsx file
workbook.SaveAs("newFile.xlsx");
ImportsIronXL' Import .xls, .csv, or .tsv filePrivate workbook AsWorkBook = WorkBook.Load("XlsFile.xls")' Export as .xlsx fileworkbook.SaveAs("newFile.xlsx")
Imports IronXL
' Import .xls, .csv, or .tsv file
Private workbook As WorkBook = WorkBook.Load("XlsFile.xls")
' Export as .xlsx file
workbook.SaveAs("newFile.xlsx")
using IronXL;// Load the workbookWorkBook workbook = WorkBook.Load("xlsFile.xlsx");// Exports the workbook to a XLSX stream.var stream = workbook.ToXlsxStream();
using IronXL;
// Load the workbook
WorkBook workbook = WorkBook.Load("xlsFile.xlsx");
// Exports the workbook to a XLSX stream.
var stream = workbook.ToXlsxStream();
ImportsIronXL' Load the workbookPrivate workbook AsWorkBook = WorkBook.Load("xlsFile.xlsx")' Exports the workbook to a XLSX stream.Private stream = workbook.ToXlsxStream()
Imports IronXL
' Load the workbook
Private workbook As WorkBook = WorkBook.Load("xlsFile.xlsx")
' Exports the workbook to a XLSX stream.
Private stream = workbook.ToXlsxStream()
using IronXL;// Import .xlsx, .csv or .tsv fileWorkBook workbook = WorkBook.Load("XlsxFile.xlsx");// Export as .xls fileworkbook.SaveAs("newFile.xls");
using IronXL;
// Import .xlsx, .csv or .tsv file
WorkBook workbook = WorkBook.Load("XlsxFile.xlsx");
// Export as .xls file
workbook.SaveAs("newFile.xls");
ImportsIronXL' Import .xlsx, .csv or .tsv filePrivate workbook AsWorkBook = WorkBook.Load("XlsxFile.xlsx")' Export as .xls fileworkbook.SaveAs("newFile.xls")
Imports IronXL
' Import .xlsx, .csv or .tsv file
Private workbook As WorkBook = WorkBook.Load("XlsxFile.xlsx")
' Export as .xls file
workbook.SaveAs("newFile.xls")
using IronXL;// Load the workbookWorkBook workbook = WorkBook.Load("xlsxFile.xlsx");// Exports the workbook to a XLS stream.var stream = workbook.ToXlsStream();
using IronXL;
// Load the workbook
WorkBook workbook = WorkBook.Load("xlsxFile.xlsx");
// Exports the workbook to a XLS stream.
var stream = workbook.ToXlsStream();
ImportsIronXL' Load the workbookDim workbook AsWorkBook = WorkBook.Load("xlsxFile.xlsx")' Exports the workbook to a XLS stream.Dim stream = workbook.ToXlsStream()
Imports IronXL
' Load the workbook
Dim workbook As WorkBook = WorkBook.Load("xlsxFile.xlsx")
' Exports the workbook to a XLS stream.
Dim stream = workbook.ToXlsStream()
using IronXL;// Load the workbookWorkBook workbook = WorkBook.Load("sample.xlsx");// Exports the first sheet of the workbook to a CSV streamvar stream = workbook.ToCsvStream(0);
using IronXL;
// Load the workbook
WorkBook workbook = WorkBook.Load("sample.xlsx");
// Exports the first sheet of the workbook to a CSV stream
var stream = workbook.ToCsvStream(0);
ImportsIronXL' Load the workbookPrivate workbook AsWorkBook = WorkBook.Load("sample.xlsx")' Exports the first sheet of the workbook to a CSV streamPrivate stream = workbook.ToCsvStream(0)
Imports IronXL
' Load the workbook
Private workbook As WorkBook = WorkBook.Load("sample.xlsx")
' Exports the first sheet of the workbook to a CSV stream
Private stream = workbook.ToCsvStream(0)
using IronXL;// Load the workbookWorkBook workbook = WorkBook.Load("sample.xlsx");// Exports the entire workbook to a CSV streamvar workBookStream = workbook.ToCsvStreams();
using IronXL;
// Load the workbook
WorkBook workbook = WorkBook.Load("sample.xlsx");
// Exports the entire workbook to a CSV stream
var workBookStream = workbook.ToCsvStreams();
ImportsIronXL' Load the workbookPrivate workbook AsWorkBook = WorkBook.Load("sample.xlsx")' Exports the entire workbook to a CSV streamPrivate workBookStream = workbook.ToCsvStreams()
Imports IronXL
' Load the workbook
Private workbook As WorkBook = WorkBook.Load("sample.xlsx")
' Exports the entire workbook to a CSV stream
Private workBookStream = workbook.ToCsvStreams()
Excel データを XML にエクスポートする方法は?
XML エクスポートは、企業システムとの構造化データ交換を可能にします。 IronXLはスプレッドシートデータの階層構造を維持しながら、このプロセスを簡素化します:
using IronXL;// Import .xlsx, .xls or .csv fileWorkBook workbook = WorkBook.Load("sample.xlsx");// Export as .xml fileworkbook.SaveAsXml("newFile.xml");
using IronXL;
// Import .xlsx, .xls or .csv file
WorkBook workbook = WorkBook.Load("sample.xlsx");
// Export as .xml file
workbook.SaveAsXml("newFile.xml");
ImportsIronXL' Import .xlsx, .xls or .csv filePrivate workbook AsWorkBook = WorkBook.Load("sample.xlsx")' Export as .xml fileworkbook.SaveAsXml("newFile.xml")
Imports IronXL
' Import .xlsx, .xls or .csv file
Private workbook As WorkBook = WorkBook.Load("sample.xlsx")
' Export as .xml file
workbook.SaveAsXml("newFile.xml")
SaveAsXml メソッドは、各ワークシートを、スプレッドシートデータの構造化された表現を含む個別の XML ファイルに変換します。 ここには以下が含まれます:
指定したワークシートを XML ストリームにエクスポートするには、ワークシートのインデックスを表す整数パラメータを指定して ToXmlStream メソッドを使用します。 リアルタイムのデータ処理シナリオに最適です:
using IronXL;// Load the workbookWorkBook workbook = WorkBook.Load("sample.xlsx");// Converts the first worksheet to a XML Streamvar stream = workbook.ToXmlStream(0);
using IronXL;
// Load the workbook
WorkBook workbook = WorkBook.Load("sample.xlsx");
// Converts the first worksheet to a XML Stream
var stream = workbook.ToXmlStream(0);
ImportsIronXL' Load the workbookPrivate workbook AsWorkBook = WorkBook.Load("sample.xlsx")' Converts the first worksheet to a XML StreamPrivate stream = workbook.ToXmlStream(0)
Imports IronXL
' Load the workbook
Private workbook As WorkBook = WorkBook.Load("sample.xlsx")
' Converts the first worksheet to a XML Stream
Private stream = workbook.ToXmlStream(0)
using IronXL;// Load the workbookWorkBook workbook = WorkBook.Load("sample.xlsx");// Exports the entire workbook to a XML streamvar workBookStream = workbook.ToXmlStreams();
using IronXL;
// Load the workbook
WorkBook workbook = WorkBook.Load("sample.xlsx");
// Exports the entire workbook to a XML stream
var workBookStream = workbook.ToXmlStreams();
ImportsIronXL' Load the workbookPrivate workbook AsWorkBook = WorkBook.Load("sample.xlsx")' Exports the entire workbook to a XML streamPrivate workBookStream = workbook.ToXmlStreams()
Imports IronXL
' Load the workbook
Private workbook As WorkBook = WorkBook.Load("sample.xlsx")
' Exports the entire workbook to a XML stream
Private workBookStream = workbook.ToXmlStreams()
Excel ファイルから JSON を生成する方法は?
現代の Web アプリケーションでは、データ交換用に JSON 形式を求められることが多いです。 IronXLは直接JSONエクスポート機能を提供し、ExcelデータをウェブフレンドリーなJSON構造に変換します:
using IronXL;// Import Excel fileWorkBook workbook = WorkBook.Load("sample.xlsx");// Export as JSON fileworkbook.SaveAsJson("newFile.json");
using IronXL;
// Import Excel file
WorkBook workbook = WorkBook.Load("sample.xlsx");
// Export as JSON file
workbook.SaveAsJson("newFile.json");
using IronXL;// Load the workbookWorkBook workbook = WorkBook.Load("sample.xlsx");// Exports the first sheet of the workbook to a JSON streamvar stream = workbook.ToJsonStream(0);
using IronXL;
// Load the workbook
WorkBook workbook = WorkBook.Load("sample.xlsx");
// Exports the first sheet of the workbook to a JSON stream
var stream = workbook.ToJsonStream(0);
ImportsIronXL' Load the workbookPrivate workbook AsWorkBook = WorkBook.Load("sample.xlsx")' Exports the first sheet of the workbook to a JSON streamPrivate stream = workbook.ToJsonStream(0)
Imports IronXL
' Load the workbook
Private workbook As WorkBook = WorkBook.Load("sample.xlsx")
' Exports the first sheet of the workbook to a JSON stream
Private stream = workbook.ToJsonStream(0)
using IronXL;// Load the workbookWorkBook workbook = WorkBook.Load("sample.xlsx");// Exports the entire workbook to a JSON streamvar workBookStream = workbook.ToJsonStreams();
using IronXL;
// Load the workbook
WorkBook workbook = WorkBook.Load("sample.xlsx");
// Exports the entire workbook to a JSON stream
var workBookStream = workbook.ToJsonStreams();
ImportsIronXL' Load the workbookPrivate workbook AsWorkBook = WorkBook.Load("sample.xlsx")' Exports the entire workbook to a JSON streamPrivate workBookStream = workbook.ToJsonStreams()
Imports IronXL
' Load the workbook
Private workbook As WorkBook = WorkBook.Load("sample.xlsx")
' Exports the entire workbook to a JSON stream
Private workBookStream = workbook.ToJsonStreams()
Excelエクスポート開発に役立つリソースとは
APIリファレンス文書
高度な Excel 操作のためのすべての名前空間、クラス、メソッド、プロパティを含む完全な IronXL API を調べます。