All possible methods of Excel.Application ComObject

[Alexey_R]

Hello, where can i see all possible methods and synax of Excel ComObject for CTRL scripts?
Many methods are missing from the online help, such as saving and merging cells.

[kilianvp]

It's not WinCC OA related.. check MS Documentation https://docs.microsoft.com/en-us/office ... on(object)

[Alexey_R]

Are there other ways to create Excel or Word documents in WinCC OA?
Which is the most functional way?

[leoknipp]

Do you really need to create Excel/Word documents?
If you want to export data to a file which can be read in Excel you can also use a "comma" or "tab" separated text file.

Best Regards
Leopold Knipp
Senior Support Specialist

[Alexey_R]

In fact, I need to generate a PDF document.
I was planning to convert it from excel, because I have not seen examples of pdf creation in WinCC.

[leoknipp]

Which kind of data shall be saved in the pdf document?
The function printPanel() in WinCC OA offers the possibility to save the screenshot of the panel in a pdf file.
For details please have a look at the WinCC OA documentation.

Best Regards
Leopold Knipp
Senior Support Specialist

[Alexey_R]

Which kind of data shall be saved in the pdf document?

I need to save a formatted table with data that is generated in the panel.

The function printPanel() in WinCC OA offers the possibility to save the screenshot of the panel in a pdf file.

I cannot merge cells in the panel table, so this method is not suitable. This is problematic to do in the panel, so I do it in Excel.

Thanks for answers.

[Houns]

Hello,

we create PDFs in a somewhat complicated way. But the design options are extensive.

We create AsciiDoc format files via CTRL. (https://asciidoctor.org/docs/asciidoc-writers-guide/)
It is a Markdown language with some nice features.

We convert the created text files into PDFs with the programme "asciidoctor".
It takes some time to get used to. The results look nice and are customisable via templates.
For us, it was especially important that the whole thing can be created dynamically via the configuration of the system.

If you are interested I will try to truncate our code to a short example.


Kind regards

Houns

[Alexey_R]

Hello,
this is a nice interesting method!
I would be interested in seeing your code example.


Best Regards
Alex