topic Re: Abap2xlsx display Bar code in excel in Application Development and Automation Discussions

Abap2xlsx display Bar code in excel

Former Member — Thu, 02 Jun 2016 12:12:59 GMT

Hi Friends,

I am generating the excel by using abap2xlsx code.

Now want to display the bar code in one cell using abap2xlsx or any other way.

As cleared i want to display bar code in excel and not in smart form.

Thanks,

Dinesh.K

Re: Abap2xlsx display Bar code in excel

Juwin — Thu, 02 Jun 2016 12:42:14 GMT

You can generate Barcode bitmap in SAP and then include that in the XLSX file using Microsoft technologies. I am not an expert on ABAP2XLSX, hence can't comment on that tool.

Thanks,

Juwin

Re: Abap2xlsx display Bar code in excel

Former Member — Fri, 03 Jun 2016 06:22:15 GMT

Hi juwin,

The requirement is when every PO created then we need to create Bar code for that PO.

Need Dynamically creating the Bar code in excel.

Thanks,

Dinesh.K

Re: Abap2xlsx display Bar code in excel

Former Member — Fri, 03 Jun 2016 06:37:38 GMT

Hi,

I think you have to use Excel "Add-ins" to achieve this functionality.

Regards,

Venu

Re: Abap2xlsx display Bar code in excel

Juwin — Fri, 03 Jun 2016 12:05:56 GMT

Yes, it is possible to dynamically create barcode images in SAP - the same way Smartforms generate barcode images (Ref: ). Then, including a picture inside Excel is explained on the Microsoft website documentation.

Thanks,

Juwin

Re: Abap2xlsx display Bar code in excel

LukaszPegiel — Fri, 03 Jun 2016 12:35:38 GMT

And that's the most proper way I guess.

Other way would be to setup proper font in excel, but then every PC where excel will be opened, should have the bar-code font installed. You cannot embed fonts into excel as far as I know.

Re: Abap2xlsx display Bar code in excel

Former Member — Mon, 06 Jun 2016 06:49:55 GMT

Hi Venu,

How to do that excel Add-ins and i don't want to install anything.

I want to generate a bar code dynamically in excel..

Because i am generating the excel dynamically and sending the mail as a attachment that y.

Thanks,

Dinesh.K

Re: Abap2xlsx display Bar code in excel

Juwin — Tue, 07 Jun 2016 15:16:23 GMT

Excel Addins are also something which you need to install. Have you tried the method of generating the image and attaching it to Excel? If you face any trouble during the process, we are all still here to help you. But, atleast give it a try.

Thanks,

Juwin