Set Number format is not working Aspose Cells in Classic ASP

Aspose.Cells Product Family
,
1

I am trying to set the number format for Excel file, but it is not working.

I am able to generate the excel file in classic asp, but number format to the column not able to set.

I used below code, please help help me!

    set cell = cells.item_3("G2")
    set range = cells.CreateRange ("G2","G200")
set stlflag = CreateObject("Aspose.Cells.StyleFlag")
stlflag.NumberFormat = true
set stl1= cell.GetStyle
stl1.Custom = "#.00"
'Apply style to the range
call range.ApplyStyle ((stl1),(stlflag))

cell.PutValue FormatNumber(rsDet(“exp_amt”),2)

2

@Svas78,
Could you please share your sample project and template file for our testing. We will reproduce the problem and provide our feedback after analysis.

3

Thank you, I managed to get the format. I used cell.PutValue_3 instead of cell.PutValue.

4

@Svas78,
Good to know that your issue is sorted out. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.