How to enter permission Matrix by Excel

This article introduces how to enter the permission matrix of Excel, the content is very detailed, interested friends can refer to, hope to be helpful to you.

The leader wants to enter the data of a permission matrix into the database and ask me if there is any good way.

Can you say no?

The whole Excel is similar to the following matrix, there are many matrices, each matrix is also very large.

Create a test table.

Create table t (

Id int primary key auto_increment

F varchar (32) not null

T varchar (32) not null

P int

);

The first step is to change the check box in Excel to 1.

Step 2, enter the formula at cell E2

= CONCATENATE (Barri1, ",", $A2, ",", $B2)

$B (number) as you drag and copy, the number increases. But B$ (number) does not increase the number by dragging and copying.

The third part is the drop-down copy formula

You can see that the formula for cell E4 is = CONCATENATE (bread1, ",", $A4, ",", $B4).

Manually modify the formula of E2 by changing = CONCATENATE (Basil, ",", $A2, ",", $B2) to = CONCATENATE (Basi1, ",", $A2, ", Basi2).

The formula of E3 and E4 is also modified.

Part IV, Transverse drag Formula

Step 5, paste to generate SQL

Text editor operation, generating SQL

On how to enter the Excel permission matrix to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.