Private void btncopy_click (Object sender, eventargs E)
{
Try
{
// Excel template path
Filestream file = new filestream (@ "E:/book1.xls", filemode. Open, fileaccess. Read );
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 ");
}
}
Note: 1. If the value in the template is assigned another value: sheet1.getrow (2). getcell (1). setcellvalue (true );
2. If no value is assigned, it is null: sheet1.createrow (3). createcell (3). setcellvalue (12345 );