private void ExportSheetLayout(dynamic sheet)
{
Logger.Info("ExportSheetLayout");
SheetViewModel svm = new SheetViewModel(sheet);
switch (Settings.Objects)
{
case BatchExportObjects.Charts:
svm.SelectCharts();
break;
case BatchExportObjects.ChartsAndShapes:
svm.SelectShapes();
break;
default:
Logger.Fatal("ExportSheetLayout: Object type '{0}' not implemented!", Settings.Objects);
throw new NotImplementedException(Settings.Objects.ToString());
}
dynamic selection = Instance.Default.Application.Selection;
Exporter.FileName = _batchFileName.GenerateNext(sheet, selection);
Bovender.ComHelpers.ReleaseComObject(selection);
Exporter.Execute();
}
public void CountSelectChartObjects()
{
Workbook wb = Instance.Default.CreateWorkbook();
Worksheet ws = wb.Worksheets.Add();
ChartObjects cos = ws.ChartObjects();
cos.Add(10, 10, 200, 100);
cos.Add(250, 10, 200, 100);
SheetViewModel svm = new SheetViewModel(ws);
Assert.AreEqual(2, svm.CountCharts(), "CountCharts()");
Assert.AreEqual(2, svm.CountShapes(), "CountGraphicObjects()");
Assert.IsTrue(svm.SelectCharts(),
"SelectCharts() should return true if the sheet contains an embedded chart.");
Assert.IsTrue(svm.SelectShapes(),
"SelectGraphicObjects() should return true if the sheet contains an embedded chart.");
}
public void CountSelectShapes()
{
Workbook wb = Instance.Default.CreateWorkbook();
Worksheet ws = wb.Worksheets.Add();
Shapes shs = ws.Shapes;
shs.AddLine(10, 10, 20, 30);
shs.AddLine(50, 50, 20, 30);
SheetViewModel svm = new SheetViewModel(ws);
Assert.AreEqual(0, svm.CountCharts());
Assert.AreEqual(2, svm.CountShapes());
Assert.IsFalse(svm.SelectCharts(),
"SelectCharts() should return false if the sheet contains only shapes.");
Assert.IsTrue(svm.SelectShapes(),
"SelectGraphicObjects() should return true if the sheet contains shapes.");
}
public void CountSelectChartSheet()
{
Workbook wb = Instance.Default.CreateWorkbook();
Worksheet ws = wb.Worksheets.Add();
SheetViewModel svm = new SheetViewModel(ws);
Assert.IsFalse(svm.SelectCharts(),
"SelectCharts() should return false if worksheet does not contain charts.");
Assert.IsFalse(svm.SelectShapes(),
"SelectGraphicObjects() should return false if worksheet does not contain any.");
Chart chart = wb.Charts.Add();
svm = new SheetViewModel(chart);
Assert.AreEqual(1, svm.CountCharts());
Assert.AreEqual(1, svm.CountShapes());
Assert.IsTrue(svm.SelectCharts(),
"SelectCharts() should return true if sheet is a chart.");
Assert.IsTrue(svm.SelectShapes(),
"SelectGraphicObjects() should return true if sheet is a chart.");
}
