public void ExportRangeAsJpg(string filename)
        {
            Excel.Application xl = new Excel.Application();
            Excel.Workbook excelWorkbook = xl.Workbooks.Open(filename,
                    0, true, 5, "", "", false, Excel.XlPlatform.xlWindows, "",
                    true, false, 0, true, false, false);

            Excel.Workbook wb = xl.ActiveWorkbook;
            Excel.Range r = wb.ActiveSheet.UsedRange;// wb.ActiveSheet.Range["A1:A2"];
            r.CopyPicture(Excel.XlPictureAppearance.xlScreen, Excel.XlCopyPictureFormat.xlPicture);
           
            if (Clipboard.GetDataObject() != null)
            {
                IDataObject data = Clipboard.GetDataObject();
                image = GetMetaImageFromClipboard();
                pictureBox1.Image = image;
            }
            else
            {
                MessageBox.Show("Clipboard Empty !!");
            }

            excelWorkbook.Close(false);
            if (excelWorkbook != null)
                Marshal.FinalReleaseComObject(excelWorkbook);

            excelWorkbook = null;
        }