public void ChangeExcel2Image(string filename) { Spire.Xls.Workbook workbook = new Spire.Xls.Workbook(); workbook.LoadFromFile(filename); Spire.Xls.Worksheet sheet = workbook.Worksheets[0]; sheet.SaveToImage("选型结果.jpg"); //图片后缀.bmp ,imagepath自己设置 }
private void export_Click(object sender, EventArgs e) { var path = @"D:\test\WorkOrder.xls"; var outPath = @"D:\\test\\aspose"; //HSSFWorkbook wk = null; //using (FileStream fs = File.Open(path, FileMode.Open, FileAccess.ReadWrite, FileShare.ReadWrite)) //{ // wk = new HSSFWorkbook(fs); // fs.Close(); //} //ISheet sheet = wk.GetSheet("Sheet1"); using (Spire.Xls.Workbook workbook = new Spire.Xls.Workbook()) { workbook.LoadFromFile(path); Spire.Xls.Worksheet sheet = workbook.Worksheets[0]; const string main_Dir = @"c:/WenTest"; if (!Directory.Exists(main_Dir)) { //Directory.CreateDirectory(main_Dir); } else { ExportImg.DeleteFolder(main_Dir); Directory.CreateDirectory(main_Dir); } //string mypath = Environment.CurrentDirectory+"\\test"; if (File.Exists(outPath)) { File.Delete(outPath); Directory.CreateDirectory(outPath); } else { Directory.CreateDirectory(outPath); } //sheet.SetRowHeightPixels() //sheet.SaveToImage(outPath+"\\msample.png"); sheet.SaveToImage(sheet.FirstRow, sheet.FirstColumn, sheet.LastRow, sheet.LastColumn).Save(outPath + "\\test.jpg"); //IWorkbook workbook = new IWorkbook(); } }