Learn how to use text recognition functions in Excel

How to add a text recognition function in excel

'Add it to the macro module and you can use it like a formula.

Function ColorSum(Rng As Range, Color As Range) As Double

Dim Tmp As Range

ColorSum = 0

For Each Tmp In Rng

'Process numbers with the same color as the specified color in the selected range, and exclude text cells of the same color

If Tmp.Interior.ColorIndex = Color.Interior.ColorIndex And IsNumeric(Tmp.Value) Then

ColorSum = ColorSum Tmp.Value

End If

Next

End Function

How to identify file format

Read the file header to solve the problem. For example, you want to check whether a picture is "really" in "jpg" format. Then you need to extract 2 bytes. If the file header is "255216", it means it is in "jpg" format. code show as below:

FileStream fs = new FileStream(@"C:\1.jpg", FileMode.Open, FileAccess.Read);

byte[] imagebytes = new byte[fs.Length];

BinaryReader br = new BinaryReader(fs); //Binary file reader

imagebytes = br.ReadBytes(2); //Read 2 bytes from the current stream into the byte array

string s = "＂";

for (int i = 0; i {

s = imagebytes[i];

}

if(s==＂255216＂)

Console.WriteLine("is jpg format");

else

Console.WriteLine("not jpg format");

The file headers of various file formats occupy different bytes, for example: jpg, 2 bytes; png, 8 bytes; gif, 6 bytes. You only need to change the number of bytes read and then judge.

How to use c language to determine the file type of an unknown file

It is easy to open a file, easy to read a few characters, but difficult to determine the type.

The following program determines the .exe .jpg .gif format

The first 20 bytes read are in char s[20].

You are willing to regard it as decimal or hexadecimal.

Input format:

Executable program name File name to be judged

For example:

ccalb.exe file.gif

#include

#include

main(int argc, char *argv[]){

FILE *fin;

char namein[80];

char s[20];

if (argc

printf(＂Usage: \007 %s filename\n＂,argv[0]);

return 0;

}

strcpy(namein,argv[1]);

fin = fopen(namein,"rb");

if (!fin){

printf(＂Open %s error\n＂,namein);

return 0;

}

fread(s,20,1,fin);

fclose(fin);

if (s[0]=='M' & s[1]=='Z') printf(＂It is .exe file\n＂);

else if (s[6]=='J' & s[7]=='F' & s[8]=='I' & s[9]=='F')printf(＂It is .jpg file\n＂);

else if (s[0]=='G' & s[1]=='I' & s[2]=='F' ) printf(＂It is .gif file\n＂);

else printf(＂other file＂);

return 0;

}

The above is the detailed content of Learn how to use text recognition functions in Excel. For more information, please follow other related articles on the PHP Chinese website!