I am generating a report which must have 6 sheets when extracting it.
The problem I am facing here is - I customize each sheet and then add all these flow to a single excel Writer. Sometimes, some sheets contain empty table. Hence I am unable to extract it.
These are the things I need to achieve in creating this excel:
- When a sheet generates a empty table, extracted excel sheet must say
“100%Compliance” - Though it generates empty table I must be able to extract them in one excel file.
Please I need to close this report today. Please explain it in layman’s term