Hi,
Using Cell_WriteByIndex to format excel(downloading) cell in date format. "CellType" given as "datetime", however upon downloading I could see data in number format instead of date. Please suggest to resolve this issue.
Regards,
Pujitha
Hi @Pujitha Chalasani,
I assigned this post to the Advanced Excel forge asset, as it is specific to it.
Assigning a Forge asset to your posts will make it easier for people with the right insight to help you, namely the team that maintains it.
There have also been several other posts regarding this, you can search the Advanced Forge support forum, there might already be some answer that applies to your case.
Hope this helps!
You can try by changing the CellType as "Text". That can help you to display data in datetime format instead of text.
I hope this will help you.
Gayatri Kapadi
Hello Pujitha Chalasani,
While exporting data on excel, this kind of formatting issue occurs. However, it is always better to make it in the text format so that you can export it as it is.