Can someone please post a code example of how to read from and write to particular cells in MS Excel documents? And does the excel report have an NC-only option like the basic reports do?
Writing to specific cells, you're going to have to do so with a script. I probably went the hard way because I didn't know (and still don't know much) about VB.
I wrote it to a CSV, then used a script to convert it to an Excel format. Then copied the cells from that Excel into a dedicated, network-based Excel document for all to see.
Writing to specific cells, you're going to have to do so with a script. I probably went the hard way because I didn't know (and still don't know much) about VB.
I wrote it to a CSV, then used a script to convert it to an Excel format. Then copied the cells from that Excel into a dedicated, network-based Excel document for all to see.