VB how to deposit the eligible numbers in two arrays into another array

An array is dynamic. There is also a function to determine whether it is a prime number or not.

It's relatively easy to say that it's still this, but if you want to learn it, I suggest you think about it yourself.

Read and write excel sheets:

1. Refer to the Microsoft Excel type library in the project

from"Engineering"menu"References"Column; Select Microsoft Excel Object Library (Excel2007), and then select"OK"。Indicates that the excel type library is to be referenced in the project.

2. Define excel objects in the declaration process of generic objects:

dim xlbook as

dim xlsheet as

3. Common commands to operate excel sheets in the program:

set xlbook = "File name"Open the Excel workbook file that already exists.

set xlbook = "File name"The office slowly creates a new excel workbook file.

true 'Set the visibility (or invisibility) of the hitching of an Excel object

set xlsheet = "Table name") to set up an active worksheet.

for i=1 to 100

for j=1 to 50

numarr(j,i)=, i) '

nextnext

true) 'Close the workbook.

End excel object.

I can help you and DM me if you need to.

There are two ways to do this.

Come and go. Source. For illustrative purposes, two integer arrays a and b are defined, and the values in a are assigned to b.

int a[4] = , b[4];

1. Assign values one by one through array traversal.

Define the cyclic variable int i;

for(i = 0; i < 4; i ++b[i] = a[i];

The function of this program is to iterate through array a and assign values to the corresponding elements of array b one by one.

2. With the help of the memory replication function memcpy, the overall value is assigned.

void *memcpy(void *dst, void *src, size_t size);

The function of this function is to assign the value of the size bytes on the src to the dst.

When calling this function, you need to reference the header file cstring, i.e. include

The ** of the assignment array is.

memcpy(b,a,sizeof(a));

There is no easy way to merge arrays, you can only take them out one dimension at a time and put them into a new array. The new array dimension is the sum of the original two array dimensions.

For example, two arrays a and b

dim newar() 'If two arrays are of the same type, you can define the type.

redim newar(ubound(a)-lbound(a)+1+ubound(b)-lbound(b)+1-1) 'Since array definitions can only define dimensions with constant expressions, dynamic arrays are used.

Add two array items to newar.

dim index as integer

dim i as integer

for i=lbound(a) to ubound(a)newar(index)=a(i)

index=index+1

nextfor i=lbound(b) to ubound(b)newar(index)=b(i)

index=index+1

next

What are the requirements for the merger? To sort or not to sort, you're too simple, right?

Inserting a number equal to the elements in the array gives you two arrays that are still ordered.

All you need to do is split the characters.

dim a() as integer

Split characters with the split method.

a = split(," "split(string, separator) This sentence separates you with a space"1 2 3 4 5 6 7", the effect after the division is:

a(0)=1, a(1)=2 ..a(6) = 7, if there are spaces before and after the string, you can trim() first.

It's simple, char arr = ;

If there is a space, string arr =' ');