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