Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

wincc advanced V 13 SP1 and Excell

Created by: automatizzando at: 1/30/2015 12:36 PM (2 Replies)

Rating (0)

Thanks 0

3 Entries

1/30/2015 12:36 PM	Rate (0)
automatizzando Bronze Member Joined: 3/11/2007 Last visit: 9/24/2023 Posts: 222 Rating: (13)	Good morning, I can not find an example of how to print the values of certain variables in a spreadsheet excell. On the web I found the examples but I could not make them work. You can have a working example? Thank you for your help ------------------------------------------------------------------------------------------------- Buongiorno, non riesco a trovare un esempio di come stampare i valori di alcune variabili in un foglio excell. In rete ho trovato degli esempi ma non sono riuscito a farli funzionare. Si può avere un esempio funzionante? Grazie per l'aiuto

Suggestion To thank Quote Answer

1/30/2015 5:14 PM	Rate (0)
eisenpferdreiter Posts: 1058 Rating: (93)	automatizzando Good morning, I can not find an example of how to print the values of certain variables in a spreadsheet excell. On the web I found the examples but I could not make them work. You can have a working example? Thank you for your help ------------------------------------------------------------------------------------------------- Buongiorno, non riesco a trovare un esempio di come stampare i valori di alcune variabili in un foglio excell. In rete ho trovato degli esempi ma non sono riuscito a farli funzionare. Si può avere un esempio funzionante? Grazie per l'aiuto Hello automatizzando, exporting data to Excel has already been discussed here: exporting data from Taglogging uncompressed archive to excel sheet Exporting Alarm loggin archived files to detect fails to Excel Problem exporting HMI Alarm texts to an excel file Archieve data to Excel Report Copy tag to Excel hope it will help you regards
eisenpferdreiter Posts: 1058 Rating: (93)
Suggestion To thank Quote Answer

1/30/2015 10:12 PM	Rate (0)
automatizzando Bronze Member Joined: 3/11/2007 Last visit: 9/24/2023 Posts: 222 Rating: (13)	I used this method: Carryover for simplicity only part of the code. Very simple and functional. Especially because it is saved with the .xlsx format that is used by Excel 2010-2013. The alignment is perfect as it is written directly in the selected box. If the file exists, or something is successful is not just the classic dialog windows to inform us that the file exists. If required, even the path with which to save the file can be selected by means of the variable. 'Dichiarazione delle variabili Dim oExcel Dim oBook Dim oSheet Dim today_string Dim File_name Set oExcel = CreateObject("Excel.Application") Set oBook = oExcel.Workbooks.Add 'Assemblo la data per utilizzarla come parte del nome del file today_string = CStr(Year(Now))&"_"& CStr(Month(Now))&"_"& CStr(Day(Now)) Set oSheet = oBook.Worksheets(1) 'Stampo un testo a mio piacimento nella cella n° A1 oSheet.Range("A1").Value = "Cliente" 'Stampo nella cella A2 un valore contenuto all'interno di una variabile utilizzata nel progetto . . ' Evidenzio in grassetto il valore contenuto in un certo numero di caselle oSheet.Range("A1:A11").Font.Bold = True . . . 'Salvo il tutto in un file di formato xlsx 'Il file prende il nome del cliente che ho lavorato con la data precedentemente rilevata oBook.SaveAs "C:\Storage\" & today_string & "_" & HmiRuntime.SmartTags("Generico_Ricetta_Name client")& ".xlsx" oExcel.Quit

Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Related topics by keywords:

TIA WinCC Adv System functions/Scripting

Follow us on