/// <summary>
/// Creates a new Excel File Writer with one worksheet (the default worksheet) in the workbook.
/// </summary>
public ExcelFileWriter( bool createDefaultWorksheet = true )
{
workbook = new XLWorkbook();
AutofitOnSave = true;
if( createDefaultWorksheet ) {
var newWorkSheet = new ExcelWorksheet( workbook.AddWorksheet( "Sheet1" ) );
namesToWorksheets.Add( newWorkSheet.Name, newWorkSheet );
DefaultWorksheet = newWorkSheet;
}
}
/// <summary>
/// Loads the worksheets in the opened workbook into a dictionary.
/// </summary>
private void loadWorksheets()
{
foreach( var worksheet in workbook.Worksheets )
namesToWorksheets.Add( worksheet.Name, new ExcelWorksheet( worksheet ) );
DefaultWorksheet = namesToWorksheets.First().Value;
}
/// <summary>
/// Adds to the workbook and returns a new ExcelWorksheet.
/// </summary>
public ExcelWorksheet AddWorksheet( string name )
{
var newWorkSheet = new ExcelWorksheet( workbook.Worksheets.Add( name ) );
namesToWorksheets.Add( name, newWorkSheet );
return newWorkSheet;
}