Citect SCADA Reading And Writing Values in Excel

[@kholidahmad1357]

Sir ..I need help you
If Run program , there error message OPC error and numeric #BAD
How it solution?
Thanks...

[@filipe_brito]

How can I use SQL in Citect?

[@AliSherKhan-qd1oq]

How would vijeo citect knows which excel file to write or read ? You are just entering the sheet number.

[@starautomation]

File which is currently open in excel application is been written. So we are mentioning on sheet number.
If excel application is not open then it will not be written

[@techsoftwaresolutionn]

Sir I need your help
M india se hu
M scada s 7.20
Omron PLC cp1e se rs232 par communication karna h or value aa rahi h ya nahi check karna h karana h can you help me please

[@MultiASHIRWAD]

How can i generate reports in citect scada v7.5 without using cicode

[@starautomation]

You can get simple report in .rtf format (Rich Text Format).
However, for reports in excel format using cicode is compulsory.

[@MultiASHIRWAD]

@@starautomation Any demo video for reporting in rtf format. How to create a report format file?

[@TheControlPhilosopher]

If you are using the Excel available on Office-2021 on Windows 10/11, the add-in doesn't work. To fix this you will have to install MSExcel from Office-2010 or lower in addition to your existing Office 2021 installation. So you will need to run 2 versions of Excel on your PC! . This is the only way to use excel to edit your Citect database tables.

[@AliSherKhan-qd1oq]

How would vijeo citect knows which excel file to read or write ? You are only entering the sheet number

[@starautomation]

Excel application is opened first by code, then we use sheet number

[@appum6031]

Sir, please share the code for Excel opening.