Use pyA2L for export to excel

[HemanthMChakravarthy]

I'm trying to use pyA2L for exporting the A2L file into excel file. Is there an API for that?
Or could you help me with a sample implementation?

[christoph2]

Hi Hemanth,

I've just written a bare minimum
[getting started] (https://github.com/christoph2/pyA2L/tree/master/docs/getting_started.rst), which should you enable to import an A2L file.

Regarding Excel:
I'm pretty sure you're running Windows, so I highly recommend to install pywin32, if not already done.

Now you can "connect" to Excel this way:

from win32com import client
excel = client.Dispatch("Excel.Application")

That's it!
Here is a nice tutorial.

Just ask, how to put the loose ends together :-)

Cheers Christoph

[henkelma]

I would recommend using

https://xlsxwriter.readthedocs.io

to generate the excel file. It is pretty easy to use and works out of the box, independent of platform and preinstalled software.

[krishnarayapudi25]

Hi @HemanthMChakravarthy did you succesfully converted a2l file into excel?if yes, could you help me ,as i was trying to do the same.