automatic certificate generation using matlab
clc clear all close all filename = 'Registration_Details.xls'; [num,txt] = xlsread(filename) % Read Excel sheet % seperately from numbers len=length(txt) blankimage = imread('1.png'); % Read blank certificate image for i=1:len for j= 2:2 text_names(i,j)=txt(i,j) end end % Obtain names from the txt variable which are in 2nd column for i=1:len for j= 3:3 text_topic(i,j)=txt(i,j) end end % Obtain topics from the txt variable which are in 3rd column %Ignore first row which is heading for i=2:len text_all=[text_names(i,2) text_topic(i,3)] % combine names and topics position = [100 258;120 416]; % obtain positions to insert on image, MSPaint or any image editor RGB = insertText(blankimage,position,text_all,'FontSize',28,'BoxOpacity',0,'TextColor','white'); %Provide parameters for function insertText %Font size is 22 and opacity of box is 0 means 100% transparent figure imshow(RGB) %Obtain and display figure in color y=i-1 filename=['Certificate_Topic_' num2str(y)] lastf=[filename '.png'] saveas(gcf,lastf) % generate and save files with .png extension end
