Just informing if anybody has suggestions.
We generate a planning view (web) using a html stringgrid an fill it up with html paragraphs.
We also have conditions for each cell where lines need to be colored or backgrounds need to be colored.
Does anybody have an idea how we could easily export this to an Excel-file?
Each cell correspondents to a record in a memory dataset where the whole formatting of the cell is contained in a string. Each record can contain a html tag for the background color of the cell and a number of paragraph items separated by a break. Each paragraph item can also have a color.
The background color on certain text as shown in the screenshot is not necessary, it would be enough if the text itself is colored.
Could we for instance generate a similar record for each cell to be used in Excell with all the formatting?