/// <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()) { }