public static void ExportNamedRanges()
{
OfceExcel.Workbook WB = MyApp.ExcelApp.ActiveWorkbook;
foreach (OfceExcel.Name NamedRange in WB.Names)
{
try
{
OfceExcel.Range CurRange = NamedRange.RefersToRange;
CurRange.CopyPicture(OfceExcel.XlPictureAppearance.xlScreen, OfceExcel.XlCopyPictureFormat.xlBitmap);
MyApp.Fullpathname = MyApp.ExcelApp.ActiveWorkbook.Path + "\\" + WB.Name + "_" + NamedRange.Name + ".png";
sysImg.Imaging.ImageFormat PngFormat = sysImg.Imaging.ImageFormat.Png;
bool result = MyApp.SaveImage(MyApp.Fullpathname, PngFormat);
}
catch { }
finally { }
}
foreach (OfceExcel.Worksheet WS in WB.Worksheets)
{
foreach (OfceExcel.Name NamedRange in WS.Names)
{
}
}
}
public static void SaveWithWB(string filename)
{
MyApp.Fullpathname = MyApp.ExcelApp.ActiveWorkbook.Path + "\\" + filename + ".png";
sysImg.Imaging.ImageFormat PngFormat = sysImg.Imaging.ImageFormat.Png;
bool result = MyApp.SaveImage(MyApp.Fullpathname, PngFormat);
}
