public static XLWorkbook GetOrCreateWorkbook(string path, string worksheetName)
{
if (!File.Exists(path))
{
var workbook = new XLWorkbook(XLEventTracking.Disabled);
workbook.GetOrAddWorksheet(worksheetName);
workbook.SaveAs(path);
return(workbook);
}
return(new XLWorkbook(path, XLEventTracking.Disabled));
}
/// <summary>
/// Creates a new serializer using the given <see cref="XLWorkbook"/> and <see cref="CsvConfiguration"/>.
/// <remarks>
/// The <paramref name="workbook"/> will <b><i>not</i></b> be disposed of when the serializer is disposed.
/// The workbook will <b><i>not</i></b> be saved by the serializer.
/// A new worksheet will be added to the workbook.
/// </remarks>
/// </summary>
/// <param name="workbook">The workbook to write the data to.</param>
/// <param name="sheetName">The name of the sheet to write to.</param>
/// <param name="configuration">The configuration.</param>
private ExcelSerializer(XLWorkbook workbook, string sheetName, CsvConfiguration configuration = null)
: this(workbook.GetOrAddWorksheet(sheetName), configuration)
{
}
/// <summary>
/// Creates a new serializer using the given <see cref="XLWorkbook"/> and <see cref="CsvConfiguration"/>.
/// <remarks>
/// The <paramref name="workbook"/> will <b><i>not</i></b> be disposed of when the serializer is disposed.
/// The workbook will <b><i>not</i></b> be saved by the serializer.
/// A new worksheet will be added to the workbook.
/// </remarks>
/// </summary>
/// <param name="workbook">The workbook to write the data to.</param>
/// <param name="sheetName">The name of the sheet to write to.</param>
/// <param name="configuration">The configuration.</param>
public ExcelSerializer(XLWorkbook workbook, string sheetName, CsvConfiguration configuration = null)
: this(workbook.GetOrAddWorksheet(sheetName), configuration)
{
disposeWorksheet = true;
}
