Home Products Support Blog Contact

Generate Bar codes in Office 365

Keywords: office 365, code 39, code 128, UPC-A, EAN13, code 93, code 25, interleaved 2 of 5, gs1128, msi plessey

How to create barcode in Excel 365 spreadsheet?

How to create barcode in MS Word 365 document?

Office 365 is a cloud-based subscription to a suite of MS Office software including Office 2016.

With Barcodesoft Web Service, you can generate different types of bar codes in Word 365, Excel 365, Access 365 and Publisher 365.

No download needed! No 3rd-party software installation needed!

All you need is just internet access.

Parameter Description Sample URL
s s means Symbology. It is always the first parameter for this web service. Accepted value could be one of the following:
Code39,Code39Ext, CODE128A, CODE128B, CODE128C, GS1128, UPCA, UPCE, EAN13, EAN8, Bookland,INTERLEAVED25, Code11,MSI, Code25,CODE93, Codabar,TELEPEN, Datamatrix, QRCODE, Aztec and PDF417.
Default symbology is QRCode.
http://barcode.barcodesoft.com/barcode.ashx?s/aztec/text/ABCD1234
text string to encode. http://barcode.barcodesoft.com/barcode.ashx?s/qrcode/text/ABCD1234
token A 14-digit token for each user. If you leave it blank, or your token subscription has expired, your barcode will have a demo watermark. http://barcode.barcodesoft.com/barcode.ashx?s/code39/text/ABCD1234/token/xxxx
addon UPC-A and EAN13 addon string. http://barcode.barcodesoft.com/barcode.ashx?s/upca/text/234567890123/addon/12345
hr show human readable text or not, accepted value could be either true or false. Default value is true. http://barcode.barcodesoft.com/barcode.ashx?/s/code39/text/ABCD1234/hr/false
orientation barcode image orientation. Accepted value could be one of the following: left, top, right and bottom. Default value is bottom. http://barcode.barcodesoft.com/barcode.ashx?/s/code39/text/ABCD1234/orientation/2
format format means image format. Accepted value could be one of the following: TIFF, PNG, GIF, Jpeg, BMP. Default value is BMP. http://barcode.barcodesoft.com/barcode.ashx?s/code39/text/ABCD1234/format/gif
r format resolution. Accepted value could be one of the following: 96, 200, 300, 400, 500, 600. Default value is 96. http://barcode.barcodesoft.com/barcode.ashx?s/code39/text/ABCD1234/r/300
h barcode image height. Leave it blank for automatic height. http://barcode.barcodesoft.com/barcode.ashx?s/code39/text/ABCD1234/h/300
w barcode image width. Leave it blank for automatic width. http://barcode.barcodesoft.com/barcode.ashx?s/code39/text/ABCD1234/w/300
df data matrix target size. Only available when symbology is Data Matrix. Accepted value ranges between 1 and 30. http://barcode.barcodesoft.com/barcode.ashx?s/datamatrix/text/ABCD1234/s/5
qe QRCode error correction level. Accepted value ranges between 1 and 4. Only available when symbology is QRCode. http://barcode.barcodesoft.com/barcode.ashx?s/qrcode/text/ABCD1234/qe/2
qs QRCode target size. Accepted value ranges between 1 and 40. Only available when symbology is QRCode. http://barcode.barcodesoft.com/barcode.ashx?s/qrcode/text/ABCD1234/qs/2
ae Aztec error correction level. Accepted value ranges between 1 and 20. Only available when symbology is Aztec. http://barcode.barcodesoft.com/barcode.ashx?s/aztec/text/ABCD1234/ae/2
as Aztec target size. Accepted value ranges between 1 and 36. Only available when symbology is Aztec. http://barcode.barcodesoft.com/barcode.ashx?s/aztec/text/ABCD1234/qs/2
pcm PDF417 compaction mode. Accepted value ranges: 1, 2, 3. Only available when symbology is PDF417. http://barcode.barcodesoft.com/barcode.ashx?s/pdf417/text/ABCD1234/pcm/1
psl PDF417 security level. Accepted value ranges between 1 and 8. Only available when symbology is PDF417. http://barcode.barcodesoft.com/barcode.ashx?s/pdf417/text/ABCD1234/psl/3
pmr PDF417 max rows. Only available when symbology is PDF417. http://barcode.barcodesoft.com/barcode.ashx?s/pdf417/text/ABCD1234/pmr/3
pfc PDF417 fixed columns. Only available when symbology is PDF417. http://barcode.barcodesoft.com/barcode.ashx?s/pdf417/text/ABCD1234/pfc/2
ptc PDF417 truncated option. Accepted value is either true or false. Only available when symbology is PDF417. http://barcode.barcodesoft.com/barcode.ashx?s/pdf417/text/ABCD1234/ptc/true
gs1 This option is for GS1-Data Matrix only. http://barcode.barcodesoft.com/barcode.ashx?s/datamatrix/text/ABCD1234/gs1/true

Here is the pricing list of office 365 barcode web service.
This price include all linear barcode symbologies listed below:
Code39,Code39Ext, CODE128A, CODE128B, CODE128C, GS1128, UPCA, UPCE, EAN13, EAN8, Bookland,INTERLEAVED25, Code11,MSI, Code25,CODE93, Codabar,TELEPEN

License Small Business License Developer License 5 Developer License Unlimited Developer License
Price CAD199 (Up to 5,000 barcodes generation per month) CAD399 (Up to 30,000 barcodes generation per month) CAD599 (Up to 100,000 barcodes generation per month) CAD799 (Up to 300,000 barcodes generation per month)

Generate Code39 Barcode in office 365 Word

1. Start Microsoft® Office 365 Word®.

2. Click menu Insert. Then click Pictures from toolbar as shown below.


3. Type in the URL of the barcode web service in the filename textbox:
http://barcode.barcodesoft.com/barcode.ashx?s/code39/text/23456/w/240/h/160/token/xxxx



4. Click Insert button. You will get a code 39 barcode in your Word document. If you don't have a valid token, your barcode will have a demo watermark as shown below.



Please subscribe Barcodesoft Web Service and use your own token to replace 'XXXX' in the macro above.

Generate Code39 Barcode in office 365 Excel Spreadsheet

1. Start Microsoft® office 365 Excel® first.

2. Click menu Insert. Then click Pictures as shown below.


3. Type in the URL of barcode web service in the filename textbox: http://barcode.barcodesoft.com/barcode.ashx?s/code39/text/23456/token/xxxx



4. Click Insert button. You will get a code 39 barcode in your office 365 Excel spreadsheet as shown below. If you don't have a valid token, your barcode will have a demo watermark.



5. If you have lots of barcodes to generate, you can modify the macro below to automate the process.

ActiveSheet.Pictures.Insert("http://barcode.barcodesoft.com/barcode.ashx?s/code39/text/234567890123/w/240/token/xxxx").Select
Selection.ShapeRange.IncrementLeft 200

ActiveSheet.Pictures.Insert("http://barcode.barcodesoft.com/barcode.ashx?s/upca/text/234567890123/w/240/token/xxxx").Select
Selection.ShapeRange.IncrementLeft 400

ActiveSheet.Pictures.Insert("http://barcode.barcodesoft.com/barcode.ashx?s/code128b/text/234567890123/w/240/token/xxxx").Select
Selection.ShapeRange.IncrementLeft 600

ActiveSheet.Pictures.Insert("http://barcode.barcodesoft.com/barcode.ashx?s/code93/text/234567890123/w/240/token/xxxx").Select
Selection.ShapeRange.IncrementLeft 800

Please subscribe Barcodesoft Web Service and use your own token to replace 'XXXX' in the macro above.

Generate Code 39 Barcode in office 365 Publisher

1. Start Microsoft® Office 365 Publisher®.

2. Click menu Insert. Then click Pictures from toolbar as shown below.


3. Type in the URL fo barcode web service in the filename textbox:
http://barcode.barcodesoft.com/barcode.ashx?s/code39/text/23456/w/240/h/160/token/xxxx



4. Click Insert button. You will get a code 39 barcode in your Publisher. If you don't have a valid token, your barcode will show a demo watermark.



Please subscribe Barcodesoft Web Service and use your own token to replace 'XXXX' in the macro above.