Converting Image to Excel Format
显示 更早的评论
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?
回答（1 个）
Gopichandh Danala
2018-4-27
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);
3 个评论
Birtan Derin
2018-4-27
Gopichandh Danala
2018-4-27
I don't have computer vision toolbox to recreate this
PRACHI Sood
2020-5-3
I am facing the same problem.
类别
在 帮助中心 和 File Exchange 中查找有关 Convert Image Type 的更多信息
2018-4-27
2020-5-3
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
