private void DirectPrint_Click(object sender, EventArgs e)
{
isprint = false;
GenerateExcel_Click(sender, e); //使用NPOI生成excel
if (newsavefilepath != "" && isprint==true)
{
isprint = false; 
ChangeExcel2Image(newsavefilepath); //利用Spire將excel轉(zhuǎn)換成圖片
if (printDialog1.ShowDialog() == DialogResult.OK)
{ 
printDocument1.Print(); //打印
}
} 

}

private void Generate_Click(object sender, EventArgs e)
{
CreateExcel(); //使用NPOI生成excel內(nèi)容
SaveFileDialog savedialog = new SaveFileDialog(); //彈出讓用戶選擇excel保存路徑的窗口
savedialog.Filter = " excel files(*.xlsx)|*.xlsx|All files(*.*)|*.*";
savedialog.RestoreDirectory = true;
savedialog.FileName = string.Format("銷售訂單審批單{0}", DateTime.Now.ToString("yyyyMMddHHmm"));
if (savedialog.ShowDialog() == DialogResult.OK)
{
//newsavefilepath是excel的保存路徑
newsavefilepath = savedialog.FileName.ToString().Trim();
using (FileStream newfs = new FileStream(newsavefilepath, FileMode.Create, FileAccess.ReadWrite))
{
singlexssfwk.Write(newfs); //將生成的excel寫入用戶選擇保存的文件路徑中
newfs.Close();
}
} 
}

using NPOI.XSSF.UserModel;

XSSFWorkbook singlexssfwk;

//注意，不同的NPOI版本調(diào)用的方法不一致，這里使用的版本是2.1.3.1
private void CreatExcel() 
{ 
//獲取模板excel的路徑
string str = System.Environment.CurrentDirectory + "\\XXXX.xlsx";
if (File.Exists(str))
{
using (FileStream fs = new FileStream(str, FileMode.Open, FileAccess.Read))
{
singlexssfwk = new XSSFWorkbook(fs);
fs.Close();
}
//獲取表
XSSFSheet xssfsheet = (XSSFSheet)singlexssfwk.GetSheetAt(0);
//創(chuàng)建行 
XSSFRow xssfrow1 = (XSSFRow)xssfsheet.GetRow(1);
//設(shè)置單元格內(nèi)容
xssfrow1.GetCell(0).SetCellValue("...");
... ...
　　　 }
else{
... ...
}
}

using Spire.Xls; 
public void ChangeExcel2Image(string filename)
{
Workbook workbook = new Workbook();
workbook.LoadFromFile(filename);
Worksheet sheet = workbook.Worksheets[0];
sheet.SaveToImage(imagepath); //圖片后綴.bmp ,imagepath自己設(shè)置
}

//在PrintPage方法中寫截取圖片 的代碼
private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{ 
#region 如果不需要截取圖片，可以不用寫以下代碼
GC.Collect();
Graphics g = e.Graphics; 
//imagepath是指 excel轉(zhuǎn)成的圖片的路徑
using (Bitmap bitmap = new dBitmap(imagepath))
{
//如何截取自己摸索
Rectangle newarea = new Rectangle();
newarea.X = 0;
newarea.Y = 50;
newarea.Width = bitmap.Width;
newarea.Height = bitmap.Height - 120;
using (Bitmap newbitmap = bitmap.Clone(newarea, bitmap.PixelFormat))
{
g.DrawImage(newbitmap, 0, 0, newbitmap.Width - 200, newbitmap.Height - 150);
}
} 
#endregion
}