Greetings,
I apologize in advance if this has been answered already. I looked but couldn't find an answer to the problem I am facing.
OBJECTIVE:
Open an existing excel file (template), this file has two tabs, the (Data) tab which is where the data get written to, and the (Report) tab, which contain a chart control, title, etc.
METHOD USED:
1 - Workbook (Create)
2 - ReadFromFile (open the existing file/template)
3 - GetWorkSheetByName (the "data" sheet)
4 - OnWriteCellData (populate the data in the "data" sheet)
5 - WriteToFile (Save + Overwrite) -- this would be a new file, with different name + path, not the template file
ISSUE:
No errors encountered, however, when I open the new (saved) file, I see the data sheet contains all the data (expected behavior), however, the "Report" sheet is blank (the chart is gone, and the text is gone)!
DESIRED OUTCOME:
Retain the text and the chart control with all the formatting (including cell merging), and formulas.
Any ideas/Suggesting/Help would be much appreciated.
Thank you