C# 读取excel里的图片并显示在页面上

在操作excel的时候，除了制作chart之外，很多时候还要读取excel里的图片到数据库里。下面简单介绍下从excel里抓图片到db,并从db里捞出来。

 

  1 using System;
  2  using System.Collections.Generic;
  3  using System.Linq;
  4  using System.Text;
  5  using System.Data.SqlClient;
  6  using System.Data;
  7 using Microsoft.Office.Interop.Excel;
  8 using System.Configuration;
  9 using System.Windows.Forms;
 10 using System.Drawing;
 11 using System.IO;
 12 namespace a_stock
 13 {
 14     class ExcelWithPicture
 15     {
 16         //excel里有图片的路径
 17         public static readonly string path = "C:\\GDS\\NBQAA Mockup DFM Report(1126).xls";
 18         //数据库连接字符串
 19         public static readonly string conStr = ConfigurationSettings.AppSettings["strConn"].ToString();
 20         public static void Read_excel_withpicture()
 21         {
 22             Microsoft.Office.Interop.Excel.Application MyExcel = new Microsoft.Office.Interop.Excel.Application();
 23             //打开excel
 24             MyExcel.Workbooks.Open(path, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
 25             Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
 26             Microsoft.Office.Interop.Excel.Workbook It_book = null;
 27             Microsoft.Office.Interop.Excel.Worksheet It_sheet = null;
 28             Microsoft.Office.Interop.Excel.Range It_rang = null;
 29             MyExcel.DisplayAlerts = false;
 30             It_book = MyExcel.Workbooks[1];
 31             //获取sheet表
 32             It_sheet = (Worksheet)It_book.Worksheets[1];
 33             //initial the data
 34             int Priority = -