.Cells access in Excel from WinCC OA

Find and share HowTos to various installations / configurations!
1 post • Page 1 of 1
ZEVs
Posts:16
Joined: Thu Dec 06, 2012 8:21 pm

.Cells access in Excel from WinCC OA

Post by ZEVs »

hello,

objXL = createComObject(“Excel.Application”);
objXLWorkbooks = objXL.Workbooks;
objXLWorkbook = objXLWorkbooks.Open(“”);

Range = objXL.Range(“A3”);
Range.Value2 = 2;


How to use Cells?

objXL.Worksheets(“”).Cells()?
Range(Cells(), Cells())
objXL.ActiveWorkbook.ActiveWorksheet.Cells()

How to write or read value in any cell by using Visual Basic procedures in Excel Document in function createComObject. Does it only work with procedure .Range("")? Can you give an example write value in cell, with procedure .Cells

Thanks in advance

1 post • Page 1 of 1