String substring(intstart):从指定位置开始截取字符串,默认到末尾。 String substring(intstart,intend):从指定位置开始到指定位置结束截取字符串。 案例: ublicclassDemo5_StringMethod { publicstaticvoidmain(String[] args) { //demo1(); //demo2(); //demo3(); //demo4(); String s = "woaikailing"...
6 //创建新的工作表OleDbCommand cmd = myCon.CreateCommand();//创建工作表命令 string sheetName1 = "刀具预估数量"; if (tableName.Contains(sheetName1)) { cmd.CommandText = "DROP TABLE 刀具预估数量"; cmd.ExecuteNonQuery();// 执行创建sheet的语句 } cmd.CommandText = "CREATE...
}try{//1.创建输入流String substring = excelFileName.substring(excelFileName.lastIndexOf(".") + 1);switch(substring) {case"xls"://1、读取输入流HSSFWorkbook hssfWorkbook =newHSSFWorkbook(file.getInputStream());//2.读取工作簿HSSFSheet hssfSheet = hssfWorkbook.getSheetAt(0);//3.读取行//...
List<EnumItem> valueItem = new List<EnumItem>(); selids = ""; selname = new List<string>(); foreach (var pr in entity.DynamicObjectType.Properties) { if (pr.Name.Contains("FCOL")) { int rindex = Convert.ToInt32(pr.Name.Replace("FCOL", "")); if (rindex > valsa.Length) {...
contains(s.substring(j, i))) { f[i] = true; break; } } } if (f[s.length()]) { dfs(s, res, new StringBuilder(), set, 0, max, min); } return res; } private void dfs(String s, List<String> res, StringBuilder sb, Set<String> set, int index, int max, int min) { ...
); if(!color.contains("#")) throw new ServiceException("规则中的颜色代码格式不正确,请使用颜色16进制代码!"); String rgbS = color.substring(1); byte[] rgbB = new byte[0]; // get byte array from hex string rgbB = Hex.decodeHex(rgbS); XSSFColor finalColor = new XSSFColor(rgbB, ...
if(uninstallNode32!=null){varguids=GetGuidsOfOffice(uninstallNode32,excelAppPath);if(string.IsNullOrEmpty(guids)){guids=GetGuidsOfOffice(uninstallNode,excelAppPath);}returnguids.Split('-')[3].Substring(0,1)=="1"?true:false;}else{varguids=GetGuidsOfOffice(uninstallNode,excelAppPath);...
Class<?> fieldType = field.getType(); if (String.class == fieldType) { String s = Convert.toStr(val); if (StringUtils.endsWith(s, ".0")) { val = StringUtils.substringBefore(s, ".0"); } else { val = Convert.toStr(val); } } else if ((Integer.TYPE == fieldType || ...
(name); } } /// < 增加Id处理 List<Map<String, Object>> valuesTemp = _values; if (bShowId && !titles.contains("id")) { /// < 标题添加 titles.add(0, "id"); /// < 字段添加 for (int i = 0, j = index; i < _values.size(); i++, j++) { _values.get(i).put("...
} /** * 重新执行下载任务 * * @param taskId * @return */ @Override public Result<String> rerunTask(Integer taskId) { DownloadTask downloadTask = getDownloadTaskById(taskId); if (downloadTask == null) { return Result.fail("未找到该任务,请刷新后重试"); } if (downloadTask.getState(...