
Doing this, places your data ridiculously close to both, the row and column headers (A,B,C,… and 1,2,3,…) making things look squished.

The excel spreadsheet surely looks like a table but even then you don’t need to use all the cells, especially the first row ‘ROW 1’ and the first column ‘COLUMN A’. Keep reading for some pro Excel formatting tips! Don’t use column A or row 1 This will remove your dependency to create ZPL for passing parameters.By Harshita Srivastava on Decemin Excel FormattingĪ well formatted Excel spreadsheet looks really impressive. pass this zpl to the printer for printing as it will contain Zpl = zpl.Replace("", valueForTheParamter) Public string replaceParameterValues(string zplForLabel) Now instead of passing parameter values using ZPL file use the ZPL file which has been generated and replace the values in place of the paramter name as follows: //pass the zpl generated from Zebra Designer Pro into this menthod The ZPL file which will be generated will consist of the parameter names as mentioned in the text wizrd dialog box. Generate the ZPL for the file using print to file option in Print dialogbox. Note that the string should be such that it can be searched and replaced with the parameter value from database.

String printerInstruction = GetPrinterInstruction(templateName, variables, numberOfCopies) ĬodePrinter.SendStringToPrinter(printerName, labelTemplateName, printerInstruction) ĮxceptionManager.HandleException(ex, ExceptionPolicies.Service) īelow please find the ZPL file which is being generated to pass parameters to the template on the printer: ^XAīut the data which is getting printed on the labels is consistent and gets misplaced as we are not getting data in right placeholders. PrinterInstruction.AppendLine(templateName) įor (var i = 1 i variables, int numberOfCopies) start the label format and sets the field origin StringBuilder printerInstruction = new StringBuilder()

Method to create the label is below: private string GetPrinterInstruction(string templateName, IList variables, int numberOfCopies) We are doing this by creating ZPL in the code and appending various parameter values which we want to print in the ZPL.

We have placed various labels on the templates to which we pass values dynamically through the code at the runtime. We are using Zebra Designer Pro to create the templates.
