[Advanced Excel] How to use Cell_WriteRangeWithFormat

Forge Component
(44)
Published on 2018-10-08 by Hanno
44 votes
Published on 2018-10-08 by Hanno

the action cannot insert anything into excel when use 

Cell_WriteRangeWithFormat


HI Reasoll,

Are you sure you are passing correct input required to this Action? I have used it and worked for me. It actually writes the data from a list (Data Set) to the defined row position & column position to the no of records in the Dataset.

It also has an additional input CellFormat in which you can pass the font related information to be written in the workbook cell.



Regards,

-PJ-

Hi PRAMOD JAIN,

this is i do,but the data cannot be written to the Worksheet


thanks for your answer

Solution

Hi Reasoll,

I will try again at my end and will share the oml with you.


Regards,

-PJ-

Solution

PRAMOD JAIN wrote:

Hi Reasoll,

I will try again at my end and will share the oml with you.


Regards,

-PJ-


Thanks a lot ! I have already solved this problem.


However, when I insert an excel function into a cell ,this funtion cannot be worked.I have to double click the cell so that the correct value can be displayed.