using System;
using System.Windows.Forms;
using Aspose.Cells.Rendering;
using Aspose.Cells;
using System.Drawing.Imaging;

namespace FileWatcher
{
    public partial class Form5 : Form
    {
        public Form5()
        {
            InitializeComponent();
        }

        private void label12_Click(object sender, EventArgs e)
        {

        }

        private void textBox7_TextChanged(object sender, EventArgs e)
        {

        }

        private void textBox3_TextChanged(object sender, EventArgs e)
        {

        }

        public void ExportRangeAsJpg()
        {
            Workbook book = new Workbook(@"C:\\Users\\callm\\Desktop\\新建文件夹\\99001-91A1C2079.xls");

            for (int i = 0; i < book.Worksheets.Count; i++)
            {
                Worksheet sheet = book.Worksheets[i];
                Console.WriteLine(sheet.CodeName);
                Console.WriteLine(sheet.Name);
                sheet.PageSetup.LeftMargin = 0;
                sheet.PageSetup.RightMargin = 0;
                sheet.PageSetup.BottomMargin = 0;
                sheet.PageSetup.TopMargin = 0;
                ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
                imgOptions.ImageFormat = ImageFormat.Png;
                imgOptions.OnePagePerSheet = true;
                imgOptions.PrintingPage = PrintingPageType.IgnoreBlank;
                SheetRender sr = new SheetRender((Aspose.Cells.Worksheet)sheet, imgOptions);
                sr.ToImage(0, sheet.Name + ".png");
            }
        }


        private void Form4_Load(object sender, EventArgs e)
        {
            ExportRangeAsJpg();
            return;
            CheckForIllegalCrossThreadCalls = false;
            //Workbook workbook = new Workbook();
            //workbook.LoadFromFile(@"C:\Users\callm\Desktop\新建文件夹\99001-91A1C2079.xls");
            //workbook.ConverterSetting.JPEGQuality = 100;
            //workbook.ConverterSetting.XDpi = 600;
            //workbook.ConverterSetting.YDpi = 600;
            //List<Worksheet> list = new List<Worksheet>();
            //List<string> filename = new List<string>();
            //OperatResult.AppendText("一共Sheet: " + workbook.Worksheets.Count + "\n");
            //try
            //{
            //    IFont font1 = workbook.CreateFont();
            //    for (int i = 0; i < workbook.Worksheets.Count; i++)
            //    {
            //        OperatResult.AppendText("正在解析Sheet" + workbook.Worksheets[i].Name + "\n");
            //        for (int k = 0; k < workbook.Worksheets[i].TextBoxes.Count; k++)
            //        {
            //            if (workbook.Worksheets[i].TextBoxes[k].RichText.Text.Length > 1)
            //            {
            //                workbook.Worksheets[i].TextBoxes[k].RichText.Text = workbook.Worksheets[i].TextBoxes[k].RichText.Text;
            //            }
            //        }
            //        Workbook bw = new Workbook();
            //        Worksheet she = bw.CreateEmptySheet();
            //        she.Name = workbook.Worksheets[i].Name;
            //        she.CopyFrom(workbook.Worksheets[i]);
            //        var myThread = new Thread(() => SaveFileToJPG(she));
            //        myThread.Start();
            //        //filename.Add(she.Name + ".jpg");
            //    }
            //}
            //catch (Exception ex)
            //{
            //    OperatResult.AppendText(ex.Message + "\n");
            //}

        }

        //private void SaveFileToJPG(Worksheet sheet)
        //{
        //    try
        //    {
        //        //DataHelper dh = new DataHelper();
        //        OperatResult.AppendText("解析图片【" + sheet.Name + ".jpg】添加水印" + "\n");
              
        //        ExcelPicture picture = sheet.Pictures.Add(@"图片\电子受控章.png");
        //        picture.Width = 113;
        //        picture.Height = 38;
        //        picture.LeftColumn = 20;
        //        picture.TopRowOffset = 20;
        //        ExcelPicture picture1 = sheet.Pictures.Add(@"图片\签名.png");
        //        picture1.Width = 100;
        //        picture1.Height = 38;
        //        picture1.LeftColumn = 15;
        //        picture1.TopRowOffset = 600;
        //        sheet.SaveToImage(@"C:\Users\callm\Desktop\" + "新建文件夹"+ @"\" + sheet.Name + ".jpg");
        //        OperatResult.AppendText("解析图片【" + sheet.Name + ".jpg】" + "\n");
        //        Dictionary<string, object> dic = new Dictionary<string, object>();
        //        dic.Add("em_name", "管理员");
        //        dic.Add("em_code", "ADMIN");
        //        dic.Add("caller", "ProductSOP");
        //        OperatResult.AppendText("上传文件【" + sheet.Name + ".jpg" + "】\n");
        //    }
        //    catch (Exception ex)
        //    {
        //        OperatResult.AppendText(ex.Message + ex.StackTrace);
        //    }
        //}

        //private void SaveFileToPDF(Worksheet sheet)
        //{
        //    //if (!Directory.Exists(Application.StartupPath + @"\" + pr_code.Text))
        //    //{
        //    //    Directory.CreateDirectory(Application.StartupPath + @"\" + pr_code.Text);
        //    //}
        //    sheet.SaveToPdf(@"C:\Users\callm\Desktop\" + "新建文件夹" + @"\" + sheet.Name + ".pdf");
        //    OperatResult.AppendText("解析PDF【" + sheet.Name + ".pdf】" + "\n");
        //    Dictionary<string, object> dic = new Dictionary<string, object>();
        //    dic.Add("em_name", "管理员");
        //    dic.Add("em_code", "ADMIN");
        //    dic.Add("caller", "ProductSOP");
        //    OperatResult.AppendText("上传文件【" + sheet.Name + ".pdf" + "】\n");
        //}

        private void ExcelDocViewer(string fileName)
        {
            try
            {
                System.Diagnostics.Process.Start(fileName);
            }
            catch { }
        }

        private void textBox4_TextChanged(object sender, EventArgs e)
        {

        }
    }
}