How to extract excel information to make a new matrix

First, use the a=rand(m,n) command in MATLAB to generate the matrix, and then double-click matrix A in the workspace, open a **, and copy and paste the data in Excel directly into it. Then, type A into the MATLAB Command window and it will bring up the matrix you want.

Let the original data be in columns A and B, and the new table with extracted data in columns D to I, where cells F1 and D3 are the two 2s in your second table, respectively.

Then enter :in e2

if(sumproduct(($a:$a=$d2)*(b:$b=e$1)),1,0)

Then pull down the horizontal pull fill and you're good to go.

The fastest way:

Copy Excel to a text processing tool such as Emeditor, then use regular expressions, replace text to 0 in batches, then save CSV and import it into MATLAB.

MATLAB can import EXECL data.

If you often want to use such conversions, it is recommended to use VBA to program a macro to solve the problem.

But if it's just a few times, let's be honest with yourself.

There are many tutorials on writing macros, and what others make up may not be easy to use, so you can learn it yourself, which is very good for work and learning.

Check **Copy, then click Paste Menu Selective to check Transpose, and the column becomes a row.

Like you, the name and process are very easy to handle, the key is that the quantity is too troublesome.

Just copy the name and paste it.

For the process, you select the process and the serial number number behind it, right-click "Copy", and then put the mouse to the place where you want to paste and right-click: "Paste Special", and select the hook in front of "Transpose".

1. The first step in entering the matrix is to find two empty cells in Excel**, and then enter the A1 and A2 cells of the matrix, so that column A will be determined.

2. After determining column A, enter B2 and B1, so that column B will be determined, for example, 11 and 12 will be entered, and each horizontal row will also be determined.

3. After confirming, you can pull down to complete your matrix, you can pull horizontally or vertically, and finally form the matrix you need.

4. The matrix is formed, and the law of the matrix is determined by the four numbers entered at the beginning.

5. By the way, I will teach you a simple trick of entering negative numbers, enter a positive number in the cell first, and then put parentheses.

6. After putting the brackets on the paper, you will find that the original positive number has now become a negative number. There are a lot of tricks to make things easier in Excel.

Recently, some students have raised the following questions about excel row and column conversion, hoping to get an answer. I think it's very representative, so I took a moment to write the following tutorial, hoping to bring help and inspiration to your work.

The question is as follows: If there are 10 rows x 10 columns of data in Table 1, how can I put all the data in Table 2 in one column, that is, let A1-A10 in Table 2 put column A in Table 1, and A11-A20 put column B in Table 1? That is to say, it is necessary to achieve the effect of converting the matrix to a single column as shown in the figure below.

Excel column and column conversion issues.

Solution: 1. Complex formula method: Enter the following formula in the A1 cell in Table 2 and pull down 100 rows.

indirect("Table.

The formula method solves the problem of row and column conversion.

2. Simple formula method. (Only use =, do not use other formulas, it is recommended to use this method for conversion): Enter the following formula (=b1) in cell A11 in Table 1 to pull down to just 100 rows, and then pull right to column J.

You will find that the data in column A of Table 1 is the display effect we need, and then add cell A1 of Table 2 = Table 1! A1, pull down 100 rows to get the desired effect, and you're done!

B1 Simple Formula Method.

Conclusion: Excel's column and column conversion, are you still stupidly using copy-paste? Learn the above tips and work efficiently without overtime!

I'm X, I did it like this when I was doing Table A, and I was also drunk.

If you're lucky, have regular pins. The number of rows from the same content to the next one is stable, for example, column B in table b is all registered names, so B2 refers to table A B4, the registered name is row 4, and B3 is the losing segment of cell B4 in table A, and the next row 18 is also the registered name, and the next row is 40 rows

You can use the offset function to check the specific usage yourself.

If you don't have a routine, ask for more blessings.

The matrix is calculated using an array formula, you need to select the appropriate range, and then use the shift+ctrl+enter three keys to enter the formula.

You enter the array formula with enter, and all you get is the first value of the array!

Did you calculate it with mmult()? Here's a note about it:

mmult(array1,array2)

array1 and array2 are the two arrays to be multiplied by the matrix.

The number of columns in array1 must be the same as the number of rows in array2, and only numeric values can be contained in both arrays.

For formulas that return an array result, they must be entered in the form of an array formula.

The basic principle of co-word analysis and the implementation of excel:

Method 1: A = importdata(.]'','Separator','Number of skipped');

data = ;

Method 2: Read it in line by line and check it again. Slow for large files.

fidin=fopen('');

Open it. File. fidout=fopen('','w');

Create. File. while feof(fidin) % is determined to be a valid device.

at the end of the file. tline=fgetl(fidin);

Read from the file. Yes.

if double(tline(1))>48&&double(tline(1))<57 %

Determine the first character.

Whether it's a numeric value or not.

fprintf(fidout,'%s',tline);

If it's a number.

row, write this row of data to a file.

continue %

If it is a non-number.

The word continues to the next cycle.

end end

fclose(fidout);