哪位兄弟能给我解释一下这段程序,不是很难!谢谢!

来源:百度知道 编辑:UC知道 时间:2024/05/21 22:04:45
public void EduceExcel(Byte[] blob)
{
string picPath = Directory.GetCurrentDirectory() + "\\Excelpic.jpg";
string ExcelName = "e:\\1.xls";
Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
app.Visible = true;
Workbook objbook = app.Workbooks.Add(ExcelName);
Worksheet worksheet = (Worksheet)objbook.Worksheets[1];
Pictures pics = (Pictures)worksheet.Pictures(Type.Missing);
MemoryStream stream = new MemoryStream(blob, 0, blob.Length); Bitmap bitmap = new Bitmap(stream);
bitmap.Save(picPath, System.Drawing.Imaging.ImageFormat.Jpeg);
int TD = 1;
int p = 1;
if (File.Exists(picPath))
{
stream.Close();
Range range_1 = worksheet.get_Range('A' + TD.ToString(), 'A' + TD.ToString());
pics.Insert(picPath, Type.Missing);
Picture pic = (Picture)pics.Item(p);
pic.Left = (double)range_1.Left;

public void EduceExcel(Byte[] blob)
{
//这里是设定图片物理路径,从程序运行当前目录取得路径
string picPath = Directory.GetCurrentDirectory() + "\\Excelpic.jpg";

//这个是xls的路径
string ExcelName = "e:\\1.xls";

//这里是初始化excel对象,也就是在打开excel程序
Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
app.Visible = true;

//这里是将e:/1.xls打开。
Workbook objbook = app.Workbooks.Add(ExcelName);
Worksheet worksheet = (Worksheet)objbook.Worksheets[1];

//这里是将excel里面的图片打开,并将之载入流传送对象,放在内存。
Pictures pics = (Pictures)worksheet.Pictures(Type.Missing);
MemoryStream stream = new MemoryStream(blob, 0, blob.Length); Bitmap bitmap = new Bitmap(stream);

//内存里面的图片,保存到指定的路径,也就是图片的物理路径。
bitmap.Save(picPath, System.Drawing.Imaging.ImageFormat.Jpeg);
int TD = 1;
int p = 1;

//这里是判断物理路径上的图片是否存在(也就是上面的保存是否成功了)
if (File.Exists