There are 2 types of write cell:
- Write Cell (Excel Activities)
- This one will write value/formula
- Write Cell (Workbook Activities)
- This one will write text
I need to use write cell (excel activities) because I need excel application scope to do something in Excel. If i call write cell (workbook activities) inside Excel Application scope, it will thrown error the .xlsx is being used by Other apps.
My problem is:
I would like to write “24 Jan” in cell A1 as text, but Write Cell will convert 24 Jan into 24-Jan
This will cause problem to other apps when read the file.
How to write cell as text using Excel Activities for my issue?