Posted 9 April 2023, 10:39 pm EST - Updated 9 April 2023, 10:46 pm EST
Hi Team,
I am new to this library and trying to utilize excel template capability of GcExcel.
I have predefined template associated with datasource object. After generating report, values are coming correct but position is getting changed.
Output:
Expected Output:
Template:
Data structure: (Just dummy structure)
datasource={
BudgetYear:2024,
Unit:{
Name:“test”,
Abbreviation:“test”
},
UnitItems:[
{
Name:“Test Item 1”,
Field: [
{
Name:“Field1”,
Title:“Field1”,
Amount:585
},
{
Name:“Field2”,
Title:“Field2”,
Amount:5845
}
]
}
],
ProjectItems:[
{
Name:“Test Item 1”,
Field: [
{
Name:“Field1”,
Title:“Field1”,
Amount:585
},
{
Name:“Field2”,
Title:“Field2”,
Amount:5845
}
]
}
],
UnitTotalItems:{
Name:“SubTotal”,
Amount:585
},
UnitTotalDiffItem:[{
Name:“Diff1”,
Amount:58%
},{
Name:“Diff2”,
Amount:-8%
}],
ProjectTotalItems:{
Name:“SubTotal”,
Amount:585
},
ProjectTotalDiffItem:[{
Name:“Diff1”,
Amount:58%
},{
Name:“Diff2”,
Amount:-8%
}],
GrandTotalItems:{
Name:“Total”,
Amount:585
},
GrandTotalDiffItem:[{
Name:“Diff1”,
Amount:58%
},{
Name:“Diff2”,
Amount:-8%
}],
}