Skip to Content (Press Enter)
UserImage.jpg
reasoll wang
532Views
5Comments
Solved
[Advanced Excel] How to use Cell_WriteRangeWithFormat
Question
Forge
advanced-excel
Service icon
Advanced Excel (O11)
Forge asset by Carlos Freitas

the action cannot insert anything into excel when use 

Cell_WriteRangeWithFormat


0
0
15 Apr 2019
Copy Link
2025-08-22 10-19-44
Pramod Jain
 
MVP
Solution

Hi Reasoll,

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


Regards,

-PJ-

See solution in context
0
0
16 Apr 2019
Copy Link
UserImage.jpg
reasoll wang

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.

0
0
16 Apr 2019
Copy Link
2025-08-22 10-19-44
Pramod Jain
 
MVP

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-

0
0
15 Apr 2019
Copy Link
UserImage.jpg
Vishnu shankar

Hi @Pramod Jain ,

Could you tell me what data you passed to the DataSet field? I would also like to know the structure of that dataset. 

Thanks in advance.

Vishnu shankar

0
0
05 Dec 2025
Copy Link
UserImage.jpg
reasoll wang

Hi PRAMOD JAIN,

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


thanks for your answer

0
0
16 Apr 2019
Copy Link
2025-08-22 10-19-44
Pramod Jain
 
MVP
Solution

Hi Reasoll,

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


Regards,

-PJ-

0
0
16 Apr 2019
Copy Link
UserImage.jpg
reasoll wang

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.

0
0
16 Apr 2019
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.