在操作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 = -