using System; using System.IO; using System.Text; using CPF.ReoGrid.Events; using CPF.ReoGrid.IO; namespace CPF.ReoGrid { public interface IWorkbook : IDisposable { void Save(string path); void Save(string path, FileFormat fileFormat); void Save(string path, FileFormat fileFormat, Encoding encoding); void Save(Stream stream, FileFormat fileFormat); void Save(Stream stream, FileFormat fileFormat, Encoding encoding); void Load(string path); void Load(string path, FileFormat fileFormat); void Load(string path, FileFormat fileFormat, Encoding encoding); void Load(Stream stream, FileFormat fileFormat); void Load(Stream stream, FileFormat fileFormat, Encoding encoding); event EventHandler WorkbookLoaded; event EventHandler WorkbookSaved; Worksheet CreateWorksheet(string name = null); void InsertWorksheet(int index, Worksheet sheet); void AddWorksheet(Worksheet sheet); bool RemoveWorksheet(int index); bool RemoveWorksheet(Worksheet sheet); int GetWorksheetIndex(Worksheet sheet); int GetWorksheetIndex(string name); Worksheet GetWorksheetByName(string name); Worksheet CopyWorksheet(int index, int newIndex, string newName = null); Worksheet CopyWorksheet(Worksheet sheet, int newIndex, string newName = null); Worksheet MoveWorksheet(int index, int newIndex); Worksheet MoveWorksheet(Worksheet sheet, int newIndex); WorksheetCollection Worksheets { get; } bool Readonly { get; set; } void Reset(); event EventHandler WorksheetCreated; event EventHandler WorksheetInserted; event EventHandler WorksheetRemoved; event EventHandler WorksheetNameChanged; event EventHandler ExceptionHappened; void NotifyExceptionHappen(Worksheet sheet, Exception ex); } }