How can I write the results of my 'Video OCR' script to an excel document in the following format?

Question

Jordan Jefferson 2015-1-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/171017-how-can-i-write-the-results-of-my-video-ocr-script-to-an-excel-document-in-the-following-format

评论： ayça kepçe ，2019-7-3

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:

clear all
close all
clc
vid=VideoReader('/Users/me/Documents/MATLAB/Video 2.mp4');
nFrames = vid.NumberOfFrames;
roi=[7 595 1273 93];
for f = 1:7
    frame=read(vid,f);
    ocrResults(f) = ocr(frame,roi);
end
Text=ocrResults.Text
filename = 'textResults.xls';
xlswrite(filename,Text)

Any help would be greatly appreciated.

0 个评论
显示 -1更早的评论隐藏 -1更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Dima Lisin 2015-2-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/171017-how-can-i-write-the-results-of-my-video-ocr-script-to-an-excel-document-in-the-following-format#answer_167338

You can write your output into a .csv (comma-separated values) file using the csvwrite function. Excell can read a .csv file, and it will put every comma-delimited item into its own cell.