el-table merges cells with the same value + multi-level header

<el-table border :data=”costList” :span-method=”objectSpanMethod” > <el-table-column label=”Category” prop=”Category” width=”120″> </el-table-column> <el-table-column label=”Expense Account” prop=”Expense Account” width=”120″> </el-table-column> <el-table-column v-for=”(item, index) in costTitle” :key=”index” :label=”item.name” width=”120″ :prop=\ “item”> <el-table-column :label=”item.amount” width=”120″> <el-table-column v-for=”(val, ind) in item.data” :key=”ind” :label=”val.substr(val.length – 2)” :prop =”val” width=”120″> </el-table-column> </el-table-column> </el-table-column> </el-table> export default {<!– –> name: “OaZyfy”, data() {<!– –> […]

EXCEL super search function, dynamically search cell data in real time

The excel search function is not powerful enough, so I wrote a small plug-in that can dynamically search and locate across workbooks. Private Sub Cmd_Find_Click() ‘Start searching only when the number of characters is greater than 4 If Len(T_FindStr.Text) < 4 Then MsgBox “Please enter more than 4 characters to search, otherwise the search will […]

The essence of character device driver registration and registration and cancellation steps, and the role of the struct inode/file structure

1. The essence of character device registration and registration and cancellation steps The essence of character device driver registration As long as a certain information exists on the operating system, there must be an object describing this information in the operating system. The character device driver is registered into the kernel, and there must be […]

XSS types || Defense methods || Bypass || Principle || Miscellaneous knowledge || mxss || uxss || cookie || session || jwt

XSS types || Defense methods || Bypass || Principle || Miscellaneous knowledge || mxss || uxss || cookie || session || jwt Three types of XS attacks **Reflective XSS: **Not persistent. It is a type that needs to trick users into clicking on a specific link to trigger. Usually, it is necessary to trick users […]

angular merge cells tilt column header dynamic column

Rendering: html code: <nz-table #groupingTable [nzData]=”listOfDisplayData” nzBordered nzSize=”middle” nzShowPagination=”false” [nzWidthConfig]=”widthConfig” [nzScroll]=”scrollConfig” nzFrontPagination=”false” > <thead> <tr style=”position: relative;background-color: blueviolet;” > <th colspan=”4″ class=”fontWhite” style=”background-color: blueviolet;border: none;”>Pilot Job Task Analysis (JTA)</th> <th colspan=”1″ nzWidth=”120px” class=”firstTh” style=”background-color: chartreuse;border: none;”>Task Competency Level</th> <th colspan=”1″ nzWidth=”120px” class=”firstTh” style=”background-color:darkgrey;border: none;”>PF / PM / Both (B)</th> <th *ngFor=”let skill of Skills” colspan=”1″ […]

easyExcel custom merged cell export

Dependency package <dependency> <groupId>com.alibaba</groupId> <artifactId>easyexcel</artifactId> <version>3.2.1</version> </dependency> Controller export code /** * Export * * @return */ @ApiOperation(value = “Export”, notes = “Export”, httpMethod = “GET”) @RequestMapping(value = “/export”, method = RequestMethod.GET, produces = CTRL_PRODUCE) public void export(HttpServletResponse response) throws IOException {<!– –> response.setContentType(“application/vnd.openxmlformats-officedocument.spreadsheetml.sheet”); response.setCharacterEncoding(“utf-8”); String fileName = “Supplier Evaluation Summary Table” + LocalDate.now(); fileName […]

[Parsing and verification of Excel cell types] Java uses POI to parse excel data

1. Maven dependencies used: <dependency> <groupId>com.alibaba</groupId> <artifactId>easyexcel</artifactId> <version>2.1.7</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>4.1.2</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>4.1.2</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml-schemas</artifactId> <version>4.1.2</version> </dependency> 2. Verify the uploaded file type and file size //TODO==Upload verification file name suffix, size limit if (org.springframework.util.StringUtils.isEmpty(file)) {<!– –> return new ResultVO(“Please upload files!”); } if (file.getSize() > 20971520 || […]

Excellent practice of Cucumber + Selenium automated testing!

As we all know, Cucumber is a very good BDD-oriented testing tool that uses Gherkin’s plain text functional descriptions to run acceptance tests. The biggest benefits of using the Cucumber BDD framework are: Tests are first documented before implementation is developed Tests are easy to understand for users who don’t understand the functionality. It effectively […]