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."); }