NOPI用模板產生excel

 

  private void btnCopy_Click(object sender, EventArgs e)
        {
            try
            {

               //Excel模板的路徑
                FileStream file = new FileStream(@"e:/book1.xls", FileMode.Open, FileAccess.Read);

                HSSFWorkbook hssfworkbook = new HSSFWorkbook(file);
                Sheet sheet1 = hssfworkbook.GetSheet("Sheet1");
                //sheet1.CreateRow(3).CreateCell(3).SetCellValue(12345);
                //string value1=sheet1.GetRow(1).GetCell(1).ToString();
                //sheet1.GetRow(2).GetCell(1).SetCellValue(true);
                //sheet1.GetRow(1).GetCell(1).SetCellValue("Chen");
                //sheet1.GetRow(1).GetCell(1).SetCellValue("sss");
                //sheet1.GetRow(1).GetCell(1).SetCellValue("1111");
                //sheet1.GetRow(2).GetCell(1).SetCellValue(300);
               //Force excel to recalculate all the formula while open
                sheet1.ForceFormulaRecalculation = true;

                if (File.Exists(@"e:/test.xls"))
                {
                    File.Delete(@"e:/test.xls");

                }
                else
                {
                    FileStream file2 = new FileStream(@"e:/test.xls", FileMode.Create);
                    hssfworkbook.Write(file2);
                    file2.Close();
                }
                file.Close();
                MessageBox.Show("SUC");
            }
            catch(Exception ex)
            {
                MessageBox.Show("ERR");
            }
        }

其中需要注意的地方時：1,,如果模板中賦值過的地方再次賦值：sheet1.GetRow(2).GetCell(1).SetCellValue(true);

                                             2，如果沒有賦值，為空白的地方：sheet1.CreateRow(3).CreateCell(3).SetCellValue(12345);