/// <summary/>
public CsvWorksheet(CsvWorkbook workbook, string file, string separator)
: base(workbook, Path.GetFileNameWithoutExtension(file))
{
myWorkbook = workbook;
myFile = file;
mySeparator = separator;
}
private void Run()
{
if ( !Directory.Exists( WorkbookPath ) )
{
throw new FileNotFoundException( "No workbook found at: " + WorkbookPath );
}
var workbook = new CsvWorkbook( WorkbookPath );
Body.Open( workbook );
var resultSheets = new List<CsvWorksheet>();
if ( Body.ResultSheets != null )
{
resultSheets.AddRange( workbook.Worksheets
.Where( worksheet => Body.ResultSheets.Contains( worksheet.Name ) )
.OfType<CsvWorksheet>() );
resultSheets.Foreach( worksheet => worksheet.Modified += OnWorksheetModified );
}
Body.Calculate();
Body.Close();
workbook.Save();
Console.WriteLine();
resultSheets.Foreach( worksheet => worksheet.Modified -= OnWorksheetModified );
resultSheets.Foreach( worksheet => worksheet.Print() );
}
/// <summary/>
public CsvWorksheet(CsvWorkbook workbook, string file, char separator)
: this(workbook, file, separator.ToString())
{
}
