How to read barcode from Microsoft Office?

back to home  >  Tech FAQ  >  Scan barcode from Microsoft Office in C# .NET project

Question:

Hi,I have a list of barcode images in excel cells. Now, I want to recognize these barcodes out. Can your .net barcode reader software provide this reading feature?

---- Hugo

Answer:

Hi, Hugo.

We don't provide Microsoft Office barcode reader plug-in right now, so that it can't scan the barcodes in the excel directly. However, if you have ability to export the barcode images out from Excel to your computer disk, our .net barcode reader control can read the barcode data to you.

As you used Excel, it's a little complex to save the barcode images out of worksheet to Windows pc. One way is save whole worksheet as html type, so the images in the cells can be saved to disk at the same time. Another way is using screen capture software, such as Photoshop.

If there are barcode images in the Microsoft Word or PPT, it's much easier. Just right click the barcode image in the Word document or PPT, and select "Save as picture", then this barcode picture will export to your pc.

After exporting the barcode images out, now you can use our .net barcode reader component to decode these barcodes. In this way, you can scan the barcode from Microsoft Office(Excel, Word and PPT) in 2003, 2007, 2010 and 2013 versions. What's more, we support almost most popular 1D barcodes(Code 128, Code 39, EAN 8, EAN 13, UPC A, UPC E, Codabar, Code 93, ITF 14) and 2D barcodes(Aztec Code, QR Code, PDF 417, Data Matrix) from Office document.

In the following C# sample code, we will introduce you how to decode barcodes in Windows form or asp.net applications.

Bitmap image = Bitmap.FromFile("office-image.bmp");

BarcodeResult[] results = BarCodeScanner.Scan(image);

foreach (BarcodeResult result in results)
{
    Console.Write(result.Data.ToString());
    Console.Write(result.BarType.ToString());
}

Hope the C# code can be helpful.

---- pqScan Support Team

Online Demo Download Trial Can I Read Barcode in PDF document using C#? Need help for reading barcode with unconventional position? How to read barcode from Microsoft Office? Can I read barcode image from report in C# .NET? Can I read color barcode image in C# .NET? Is it available for reading all of the barcode in a picture by one time? How to scan barcode from webcam or other device? Can I use your barcode reading SDK in Mono? I can't scan barcode from my images with different DPI. How to scan barcode in asp.net web application? How to scan barcode in WPF project using C# language? Can I run your .net barcode reader library in Windows7 or Windows8? How to scan rotated barcode in .net project?