64-bit Excel add-in MaPara

Kirvesmies · Post by **Kirvesmies** » Thu Nov 11, 2021 12:23 pm

Just got a new laptop and I would not want to change Excel to 32-bit.
Is there any workaround or MaPara available for 64-bit?

leoknipp · Post by **leoknipp** » Thu Nov 11, 2021 2:08 pm

The MaPara Excel Add-In and also the Excel Report are only available for 32bit Excel.

Best Regards
Leopold Knipp
Senior Support Specialist

funkey · Post by **funkey** » Thu Nov 11, 2021 3:43 pm

You can save your Import-Excel-File as a tap separated file. Then change it from ANSI to UTF8 code if you have Umlauts in text.
After that you can use a batch file to direct start WCCOAASCII app for importing.

Here is my batch file, you may have to adapt it:

Code: Select all

rem %1 ist der Pfad zur ASCII-Import-Liste
rem %2 ist der DPT; z.B. Antriebe oder Analogwerte

C:\Siemens\Automation\WinCC_OA\3.17\bin\WCCOAASCII -in %1 -PowerConfig -filterDpType %2 -user root: -config C:\pvss\WinCC_Project\config\config -log +stderr 1>Import_Error.txt 2>&1

Hope this helps.

Bugs / Problems