FAQ Barcode Studio
My Barcodes Are Displayed Much Too Large in Excel
My Barcodes Are Displayed Much Too Large in Excel
When inserting the barcodes into the Excel spreadsheet, the size of the exported barcodes does not match the preset size. This can have two causes:
- GIF export format instead of JPG or PNG:
GIF does not save the DPI in the file (Excel can only estimate the resolution). JPG and PNG, however, save the DPI - this can make a difference when importing.
- Data list contains other data than used for the barcode configuration:
If the barcode is configured with less demo data than is later encoded in the data list, the barcode may become larger when exported. To prevent this, configure the barcode with the data that will later be encoded in the data list - then the size in the precalculation is also correct. Also make sure to export the file as JPG or PNG .
The bar code add-in TBarCode/Office works more comfortably directly in Excel. No diversions via image files (but it is a different product = different licence).