Converting Image to Excel Format

14 次查看（过去 30 天）
Birtan Derin
Birtan Derin 2018-4-27
评论： 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?

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

回答（1 个）

Gopichandh Danala
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 个评论
显示 1更早的评论
Gopichandh Danala
Gopichandh Danala 2018-4-27
I don't have computer vision toolbox to recreate this

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Convert Image Type 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by