#region 添加有效性
DataTable dt = LAbll.LogisticsAccounts(DeptId); //查資料
if (dt.Rows.Count < 20) //有效性字符限制255，一組字符12加分割符=13
{
string[] strs = {};
for (int l = 0; l < dt.Rows.Count; l++)
{
string[] sigle = { "" + dt.Rows[l]["XXX"].ToString() + "" };
strs = strs.Concat(sigle).ToArray();
}
XSSFDataValidationHelper dvHelper = new XSSFDataValidationHelper((XSSFSheet)sheetHead);
XSSFDataValidationConstraint dvConstraint = (XSSFDataValidationConstraint)dvHelper.CreateExplicitListConstraint(strs);
CellRangeAddressList addressList = new CellRangeAddressList(1, 1, 3, 3); //（開始行，結束行，開始列，結束列）
XSSFDataValidation validation = (XSSFDataValidation)dvHelper.CreateValidation(dvConstraint, addressList);
validation.CreatePromptBox("輸入提示", "請從下拉串列中選擇XXX");
validation.CreateErrorBox("輸入值有誤", "請從下拉串列中選擇XXX");
validation.SuppressDropDownArrow = true;
validation.ShowErrorBox = true;
validation.ShowPromptBox = true;
sheetHead.AddValidationData(validation);
}
#endregion
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/119019.html
標籤：C#
上一篇：C#完成 使用異步執行緒定時更新表單標簽內容，并對標簽內容進行求和顯示
下一篇：寫日志