coldfusioncoldfusion-10cfmlcfspreadsheet

can I use cfspreadsheet to update data within in an already existing template without losing styles in it?

can I use cfspreadsheet to update/add some data within in an already existing template without losing styles in it? I got a template with some column headers and tabular styling in it with some colors n all, so can I process that file and update data into it.

Any thoughts on this line will be much appreciated.

Thanks,

Solution

  • Just answering myself if it helps some one else...

    1. Read file template using read action and specify sheet.
    2. Use SpreadsheetSetCellValue() to update the values in the corresponding cells you needed(it wont disturb any other cells or their data).
    3. Then use write action with overwrite true and specify sheet name...that's it

    and this is all works in CF10