How can I write the results of my 'Video OCR' script to an excel document in the following format?
7 次查看（过去 30 天）
Good Afternoon, I'm attempting to write a script that will
- Break up a video into its component frames (Check)
- Use the OCR function (computer vision toolbox) to find text in each of these frames (Check)
- write this text to an excel document (this is where I am experiencing difficulty)
So for the sake of this question lets say that I am simply trying to write a script that will read names from the bottom of say a CNN video. I would have a series of names as such (John Doe firm x, Jane Doe firm y,...) and would like this written in an excel spreadsheet under column A(A1,A2,A3,...). Thus far I have only been able to have Matlab write the first frames recognized characters to excel which each character taking up its own column. Below I have copied my script thus far and additionally inserted a screenshot of my resultant excel file:
nFrames = vid.NumberOfFrames;
roi=[7 595 1273 93];
for f = 1:7
ocrResults(f) = ocr(frame,roi);
filename = 'textResults.xls';
Any help would be greatly appreciated.