基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：78630559

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

excel转换成image

例如：原始excel内容为：

截图后保存的图片效果为:

using Spire.Xls;
using System;
using System.Data;
using System.Windows.Forms;

namespace ExcelToImage
{
    public partial class Form1 : Form
    {
        private OpenFileDialog openF;
        DataTable dt = new DataTable();
        public Form1()
        {
            InitializeComponent();
        }

        private void Button1_Click(object sender, EventArgs e)
        {
            for(int i=0; i< dataGridView1.Rows.Count;i  )
            {
                string wjmc = dataGridView1.Rows[i].Cells["文件名称"].Value.ToString();
                string wjlj = dataGridView1.Rows[i].Cells["文件路径"].Value.ToString();
                try
                {
                    Workbook workbook = new Workbook();
                    workbook.LoadFromFile(wjlj);
                    //将第一张工作表保存为图片
                    Worksheet sheet = workbook.Worksheets[0];
                    sheet.SaveToImage(Application.StartupPath   @"\ImageList\"   wjmc   ".jpg");
                }
                catch (Exception)
                {

                }
            }
            dt = null;
            dataGridView1.DataSource = dt;
            System.Diagnostics.Process.Start(Application.StartupPath   @"\ImageList\");
        }

        private void Button2_Click(object sender, EventArgs e)
        {
            openF = new OpenFileDialog();
            openF.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory);
            if (openF.ShowDialog() != DialogResult.OK)
            {
                return;
            }
            DataRow dr = dt.NewRow();
            dr["文件名称"] = openF.SafeFileName.Remove(openF.SafeFileName.LastIndexOf("."));
            dr["文件路径"] = openF.FileName;
            dt.Rows.Add(dr);
            dataGridView1 .DataSource= dt;
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            dt.Columns.Add("文件名称", typeof(string));
            dt.Columns.Add("文件路径", typeof(string));
        }
    }
}