All possible methods of Excel.Application ComObject

Find and share HowTos to various installations / configurations!
Search

Post Reply
8 posts • Page 1 of 1
Alexey_R
Posts: 4
Joined: Mon May 27, 2019 3:34 pm

All possible methods of Excel.Application ComObject

Post by 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.

User avatar
kilianvp
Posts: 337
Joined: Fri Jan 16, 2015 10:29 am

Re: All possible methods of Excel.Application ComObject

Post by kilianvp »

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

Alexey_R
Posts: 4
Joined: Mon May 27, 2019 3:34 pm

Re: All possible methods of Excel.Application ComObject

Post by Alexey_R »

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

User avatar
leoknipp
Posts: 2675
Joined: Tue Aug 24, 2010 7:28 pm

Re: All possible methods of Excel.Application ComObject

Post by 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
Posts: 4
Joined: Mon May 27, 2019 3:34 pm

Re: All possible methods of Excel.Application ComObject

Post by 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.

User avatar
leoknipp
Posts: 2675
Joined: Tue Aug 24, 2010 7:28 pm

Re: All possible methods of Excel.Application ComObject

Post by 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
Posts: 4
Joined: Mon May 27, 2019 3:34 pm

Re: All possible methods of Excel.Application ComObject

Post by 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
Posts: 12
Joined: Fri Jul 14, 2017 10:10 am

Re: All possible methods of Excel.Application ComObject

Post by 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

Post Reply
8 posts • Page 1 of 1