Problem with cell number format
When you insert a value into an Excel file, a number may appear as text (that is, there is a green triangle in the upper-left corner), so that the value of the cell cannot participate in the Operation Npoi. This is because a string is used to assign a value to the Setcellvalue when the cell value is set, and is converted to a character type by default. If you need a pure digital type, set the numeric variable to setcellvalue.
The sample code for the above two questions is as follows:
//Create a blank workbookIworkbook Workbook =NewHssfworkbook ();//Create a worksheet in a workbookIsheet sheet =workbook. Createsheet ();//populating the filtered contentSheet. CreateRow (0). Createcell (0). Setcellvalue ("Provinces"); sheet. CreateRow (1). Createcell (0). Setcellvalue ("Hebei province"); sheet. CreateRow (2). Createcell (0). Setcellvalue ("Hunan Province");//Verifying number format problemsSheet. GetRow (1). Createcell (2). Setcellvalue ("123"); sheet. GetRow (2). Createcell (2). Setcellvalue (123);//set up automatic filtering for ExcelCellrangeaddress C = cellrangeaddress.valueof ("A1"); sheet. Setautofilter (c);//Write a fileusing(FileStream fs =NewFileStream ("Haha.xls", FileMode.Create, FileAccess.Write)) {Workbook. Write (fs);}
The final effect shows:
Set the automatic filtering feature for Excel