Converting Image to Excel Format

Question

Birtan Derin 2018-4-27

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/397800-converting-image-to-excel-format

评论： PRACHI Sood 2020-5-3

I have screenshots of some data that I want to convert to excel format. Data is in a row/column format. I want to keep the formatting.

I am using Computer Vision (OCR) and Image Processing Toolbox to do this. Here is my code:

 rawimage = imread('Capture.png');
grayimage = rgb2gray(raw_image);
threshold = graythresh(grayimage);
bw = imbinarize(grayimage,threshold);
imshow(bw);
results = ocr(bw,'TextLayout','Auto');
text = results.Text;
filename = 'csvtest.csv';
csvwrite(filename,text)

So this code successfully reads my data. There is no problem with the OCR. However, the text result given in only one cell. After I export this into csv format with the last line of code, it exports every single character into one cell. I want the words, numbers, sentences, not each character in one cell.

Can anyone help?

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

请先登录，再进行评论。

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

Answer 1

Gopichandh Danala 2018-4-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/397800-converting-image-to-excel-format#answer_317573

在 MATLAB Online 中打开

Here I am considering a cell arrray and splitting them into multiple cells based on spaces then saving into csv with each word in a next line

String = {'Some random string seperating words by space'};
strings = strsplit(char(String));
fid = fopen('junk.csv','w');
fprintf(fid,'%s\n',strings{1,:});
fclose(fid);