public void ExportChartObject(FileType fileType, int dpi, ColorSpace colorSpace)
{
// ExcelInstance.Application.Visible = true;
Workbook wb = Instance.Default.CreateWorkbook();
Worksheet ws = wb.Worksheets[1];
ws.Cells[1, 1] = 1;
ws.Cells[2, 1] = 2;
ws.Cells[3, 1] = 3;
ChartObjects cos = ws.ChartObjects();
ChartObject co = cos.Add(20, 20, 300, 200);
SeriesCollection sc = co.Chart.SeriesCollection();
sc.Add(ws.Range["A1:A3"]);
co.Chart.ChartArea.Select();
Preset preset = PresetsRepository.Default.Add(fileType, dpi, colorSpace);
SingleExportSettings settings = SingleExportSettings.CreateForSelection(preset);
settings.FileName = Path.Combine(
Path.GetTempPath(),
Path.GetTempFileName() + fileType.ToFileNameExtension()
);
settings.Unit = Unit.Millimeter;
settings.Width = 160;
settings.Height = 40;
File.Delete(settings.FileName);
Exporter exporter = new Exporter(settings);
exporter.Execute();
Assert.IsTrue(File.Exists(settings.FileName));
}
public Exporter(SingleExportSettings settings)
: this()
{
_settings = settings;
if (_settings != null)
{
Preset = _settings.Preset;
}
}
public void DimensionsChartSheet()
{
Chart c = Instance.Default.Application.ActiveWorkbook.Charts.Add();
Preset preset = PresetsRepository.Default.First;
SingleExportSettings settings = SingleExportSettings.CreateForSelection(preset);
svm = new SingleExportSettingsViewModel(settings);
// Assert small differences because rounding errors are possible
Assert.IsTrue(Math.Abs(c.ChartArea.Width - svm.Width) < 0.000001,
"Export settings width is incorrect.");
Assert.IsTrue(Math.Abs(c.ChartArea.Height - svm.Height) < 0.000001,
"Export settings height is incorrect.");
}
public void ExportCommandDisabledWithoutSelection()
{
Instance.Default.Reset(); // reset Excel; no workbooks open
Preset preset = PresetsRepository.Default.First;
SingleExportSettings settings = SingleExportSettings.CreateForSelection(preset);
SingleExportSettingsViewModel svm = new SingleExportSettingsViewModel(settings);
Assert.IsFalse(svm.ExportCommand.CanExecute(null),
"Export command should be disabled if there is no selection.");
Instance.Default.CreateWorkbook();
settings = SingleExportSettings.CreateForSelection(preset);
svm = new SingleExportSettingsViewModel(settings);
Assert.IsTrue(svm.ExportCommand.CanExecute(null),
"Export command should be enabled if something is selected.");
}
public void SetUp()
{
Workbook wb = Instance.Default.CreateWorkbook();
Worksheet ws = wb.Worksheets[1];
ChartObjects cos = ws.ChartObjects();
cos.Add(10, 10, 300, 200).Select();
// Get a preset from the UserSettings to enforce the settings are loaded now.
Preset preset = UserSettings.UserSettings.Default.ExportPresets.FirstOrDefault();
if (preset == null)
{
preset = PresetsRepository.Default.First;
}
SingleExportSettings settings = SingleExportSettings.CreateForSelection(preset);
svm = new SingleExportSettingsViewModel(settings);
}
public void ExportChartSheet()
{
Workbook wb = Instance.Default.CreateWorkbook();
Chart ch = wb.Charts.Add();
((_Chart)ch).Activate();
Preset preset = new Preset(FileType.Png, 300, ColorSpace.Rgb);
SingleExportSettings settings = new SingleExportSettings();
settings.Preset = preset;
settings.FileName = Path.GetFileNameWithoutExtension(Path.GetTempFileName())
+ preset.FileType.ToFileNameExtension();
File.Delete(settings.FileName);
Exporter exporter = new Exporter(settings, true);
exporter.Execute();
Assert.IsTrue(File.Exists(settings.FileName), "Output file was not created.");
}
public SingleExportSettingsViewModel(SingleExportSettings singleExportSettings)
: base(new Exporter(singleExportSettings))
{
Settings = singleExportSettings;
PresetViewModels.Select(Settings.Preset);
// Need to explicitly set the selected enum value in the EnumProvider<Unit> collection.
Units.AsEnum = singleExportSettings.Unit;
PropertyChanged += (sender, args) =>
{
if (args.PropertyName == "SelectedPreset")
{
OnPropertyChanged("MegaPixels");
OnPropertyChanged("MegaPixelsWarning");
OnPropertyChanged("MegaBytes");
OnPropertyChanged("ImageSize");
}
};
}
static void ExportSelection()
{
Preset preset = UserSettings.UserSettings.Default.ExportPreset;
if (preset == null)
{
preset = PresetsRepository.Default.First;
}
SingleExportSettings settings = SingleExportSettings.CreateForSelection(preset);
SingleExportSettingsViewModel vm = new SingleExportSettingsViewModel(settings);
vm.ShowProgressMessage.Sent += Exporter_ShowProgress_Sent;
vm.ProcessFinishedMessage.Sent += Exporter_ProcessFinished_Sent;
vm.InjectInto <Export.Views.SingleExportSettingsView>().ShowDialogInForm();
// NotificationAction a = new NotificationAction();
// a.Caption = Strings.ScreenshotExport;
// a.Message = Strings.GraphicHasNoCopyMethod;
// a.Invoke();
}
/// <summary>
/// Exports the current selection using the last settings, if available.
/// </summary>
public void ExportSelection()
{
Preset preset = Preset.FromLastUsed(Instance.Default.Application.ActiveWorkbook);
Logger.Info("ExportSelection: Preset.FromLastUsed: {0}", preset);
if (preset == null)
{
Dispatcher.Execute(Command.ExportSelection);
}
else
{
SingleExportSettings settings = SingleExportSettings.CreateForSelection(preset);
SingleExportSettingsViewModel svm = new SingleExportSettingsViewModel(settings);
svm.ChooseFileNameMessage.Sent += ChooseFileNameMessage_Sent;
svm.ShowProgressMessage.Sent += Dispatcher.Exporter_ShowProgress_Sent;
svm.ProcessFinishedMessage.Sent += Dispatcher.Exporter_ProcessFinished_Sent;
if (svm.ChooseFileNameCommand.CanExecute(null))
{
svm.ChooseFileNameCommand.Execute(null);
}
}
}
public Exporter(SingleExportSettings settings, bool quickExport)
: this(settings)
{
QuickExport = quickExport;
}
/// <summary>
/// Exports the current selection to a graphic file.
/// </summary>
/// <param name="fileName">File name to export to. The file extension
/// must be one of '.tif', '.tiff', '.png' or '.emf'.</param>
/// <param name="dpi">Resolution in dots per inch (DPI).</param>
/// <param name="colorSpace">Target color space (one of 'RGB', 'GRAY',
/// 'MONO'; if this string is empty, 'RGB' will be assumed).
/// Note: CMYK is currently not supported by this API function.
/// </param>
/// <param name="transparency">Transparency (one of 'NONE', 'CANVAS', 'WHITE';
/// if this string is empty, 'NONE' will be assumed).
/// </param>
/// <returns>
/// 0 if successful;
/// 1 if unknown file type;
/// 2 if unknown color space;
/// 3 if unknown transparency type.
/// </returns>
public int ExportSelection(
string fileName,
int dpi,
string colorSpace,
string transparency)
{
Logger.Info("Export selection");
string ext = System.IO.Path.GetExtension(fileName).ToUpper();
FileType ft;
switch (ext)
{
case ".TIF": ft = FileType.Tiff; break;
case ".TIFF": ft = FileType.Tiff; break;
case ".PNG": ft = FileType.Png; break;
case ".EMF": ft = FileType.Emf; break;
default: return(1);
}
ColorSpace cs;
switch (colorSpace.ToUpper())
{
case "": cs = ColorSpace.Rgb; break;
case "RGB": cs = ColorSpace.Rgb; break;
case "GRAY": cs = ColorSpace.GrayScale; break;
case "MONO": cs = ColorSpace.Monochrome; break;
default: return(2);
}
Transparency t;
switch (transparency.ToUpper())
{
case "": t = Transparency.TransparentCanvas; break;
case "NONE": t = Transparency.WhiteCanvas; break;
case "CANVAS": t = Transparency.TransparentCanvas; break;
case "WHITE": t = Transparency.TransparentWhite; break;
default: return(3);
}
Preset preset = new Preset(ft, dpi, cs);
preset.Transparency = t;
Logger.Info("Preset: {0}", preset);
SingleExportSettings settings = SingleExportSettings.CreateForSelection(preset);
SingleExportSettingsViewModel vm = new SingleExportSettingsViewModel(settings);
vm.FileName = fileName;
vm.ExportCommand.Execute(null);
return(0); // success
}
