Print barcodes, data matrix codes, part numbers and more directly from Excel without using labels!
Process optimisation in production: cost-effective barcode generation in Excel.
This is why process owners, production managers and QM managers often go looking for cost-effective solutions to produce barcodes or data matrix codes on site at the respective workstations. Two questions always come up:
• What system environment will be used to design the machine-readable imprints? Will it be used from a database?
• How can direct printing be done in the end?
The ideal solution:
• is "very simple" throughout,
• has a high degree of automation,
• can be used on any material,
• offers cost-effective printing, and
• ensures reliable label replacement!
Combining REINER® marking devices with the common spreadsheet software Microsoft Excel is a good way to make barcode printing more efficient!
A free barcode generator is integrated into the device software on REINER® marking devices.
What do you do if you need to combine more data? Can additional, further and/or different information be integrated into the data matrix code or the barcode in the scope of work processes, without missing traceability requirements?
Find some practical examples for the vast variety of process information that can be easily provided via a barcode generator or data matrix code generator in Excel below. The final transfer of the QR code from Excel to the mobile REINER® marking device is a breeze at the end. It's become just a simple print job.
Barcode and data matrix code generator for code creation and data transfer to the mobile inkjet printer with an Excel add-in
The right device for almost every requirement.
We offer different inject printers depending on your needs and area of application.
Select the right marking device for you from our product variety:
To the handheld inkjet printer
Excel barcodes: How can various pieces of information from an Excel table be integrated into a machine-readable 1D barcode?
Microsoft Excel offers many great functions that bring about amazing results very easily. One is its simple input mask to insert data of any kind into tables regularly and recurrently. Finally, one of Excel's many useful add-ins, a barcode generator, will convert the data line into a 1D barcode or into various 2D codes such as data matrix or QR codes.
Direct printing: The benefits of creating changing QR codes with Excel and applying information directly to products.
There are hardly any industrially manufactured products or components without individual numbering or at least a batch number! Large series or industrial production on the assembly line often use laser engraving or stationary printers. Many small series and multi-stage production processes also require marking of workpieces or products. Since this must be done manually, the barcode printer is vital for mobile use in such an environment. Marking must be permanent and machine-readable as far as possible for reliable traceability.
How can the barcode generator in Excel cost-effectively create, print and apply barcodes without labels?
A handy marking device from the REINER jetStamp® family uses the part number, lot number or batch number right from Excel. The output range of the final imprint is determined in Excel once using the "Set print area" function. All other settings and combinations of information can be made directly in Microsoft Excel.
Are you looking for an authorized dealer near you? Simply enter your country and postal code and the nearest marking partners will be displayed.
To REINER® MarkingPartner
Automation: What other options does Excel offer for automatically importing, combining and printing data?
Such data forms are called input masks in Microsoft Excel. They make entering new data into a table or database very easy. Existing data can be edited and searched. All of this has become default functions that do not need any Excel macros or VBA programming at all. Barcode information can usually be imported into Excel with the enclosed barcode reader software (barcode scanner). Excel offers add-ins for the same purpose as well. Pre-existing, manually entered or scanned data from an existing barcode can be turned into a new barcode this way.
The best way of using and combining these many combinations in Excel must be assessed from case to case on site. A successful application example of printing data matrix code efficiently is reflected in our user report on Würth Elektronik. The REINER jetStamp® models print codes directly onto a semi-finished product with an Excel data matrix code generator.
The data matrix code offers a robust and common industry standard for machine-readable identification. Printing data matrix codes has become a standard function of REINER® marking devices, which come with this option even in their most basic form!
Direct printing of batch and lot numbers onto packaging or product with an Excel macro
Machine readability requires high-contrast, unblurred print images of the data and resilience against environmental influences. The REINER® marking devices offer this by default, in particular if using quick-drying and smear-resistant special ink! An Excel macro facilitates data transfer to the mobile printer and guarantees accurate marking by employees who work in the production hall or in packaging. Automatically generated print images with precise data reduce errors.
This results in direct transfer of the print image from Excel to REINER®'s mobile handheld inkjet via USB or Bluetooth, avoiding any intermediate steps!
The special features of printing via Excel macro with REINER® marking devices at a glance:
• Preventing errors by automatic data transfer to the device
• Cost-effective marking by connection to existing software via Excel macro
• Fast printing and transfer
• Marking dimensional, machine-readable codes as well as batch IDs
• Traceability of the produced parts is ensured by clearly legible and smear-resistant marking.