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();
}
}
