1 of 12

QR Code

Generator

​

-using python

A

B

C

D

E

F

G

H

I

J

K

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

2 of 12

01

02

03

04

Name of the group members

Roll no:-14

Backend

Kunal Shendage

Roll no:-08

creatives

Nayan Savekar

Roll no:-07

Reports

Shruti Sable

Roll no:-13

Backend

Kritik Shelar

A

B

C

D

E

F

G

H

I

J

K

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

3 of 12

01

02

03

04

Table of Contents

General introduction to the topic

Introduction

Purpose of the project

Problem definition

The flowchart and algorithm for the code

Flowchart and Algorithm

Use of the project in real life

Advantages

A

B

C

D

E

F

G

H

I

J

K

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

4 of 12

INTRODUCTION

Nowadays we all use QR code for multiple purposes like making payments, sharing WiFi, etc.

This project will generate QR codes and insert them into excel sheets and also keep track of records using them.

A

B

C

D

E

F

G

H

I

J

K

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

5 of 12

QR Code is a machine-readable matrix barcode that uniquely represents information. With the increase in optical capabilities of smartphones, the use of QR codes started increasing.

In this project, we will build a QR Code generator using Python Modules.

​

​

A

B

C

D

E

F

G

H

I

J

K

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

6 of 12

Problem Definition

It is dificult to keep records of every single objects,people and stuff

Real life issue

A unique QR for them and updating in Excel sheets makes it easy

Solution

A

B

C

D

E

F

G

H

I

J

K

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

7 of 12

Problem Definition

Taking attendance

Real life issue

A unique QR for them and updating in Excel sheets with flowcharts

Solution

A

B

C

D

E

F

G

H

I

J

K

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

8 of 12

Flowchart

A

B

C

D

E

F

G

H

I

J

K

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

9 of 12

Algorithm

Step 1 :- Start

Step 2:- Inserting libraries for QR code generation and Excel sheet linking

Step 3:- QR code generation code

Step 4:- Linking Excel sheets with python using openpyxl library

Step 5:- Code for updating the data in the sheets

Step 6:- End of program

A

B

C

D

E

F

G

H

I

J

K

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

10 of 12

Code for QR

# Import QRCode from pyqrcode

import pyqrcode

import png

from pyqrcode import QRCode

​

​

# Generate QR code

url = pyqrcode.create(s)

# Create and save the svg file naming "myqr.svg"

url.svg("myqr.svg", scale = 8)

# Create and save the png file naming "myqr.png"

url.png('myqr.png', scale = 6)

A

B

C

D

E

F

G

H

I

J

K

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

11 of 12

Applications

Updating the data in excel sheet makes it easy to make a survey

Survey

QR codes make it easy to open links also in Excel

Opening links

It is easy to maintain attenddace of studentsin the class

Attendance

QR code makes it easy to track items

Tracking goods

A

B

C

D

E

F

G

H

I

J

K

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

12 of 12

SECTION A

01

You can describe the topic of the section here

A

B

C

D

E

F

G

H

I

J

K

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16