Abap2xlsx display Bar code in excel

[Former Member]

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

[Former Member]

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

[Juwin]

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

[Former Member]

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

[Juwin]

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

[LukaszPegiel]

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.

[Former Member]

Hi,

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

Regards,

Venu

[Former Member]

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

[Juwin]

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