I would like to configure a window to allow the user to generate a report in Excel format. Instead of exporting data from directly dataset to Excel, can I configure the script where I can write data to specific cells in the spreadsheet.
are you talking about writing to an existing spreadsheet or generating a new spreadsheet?
To an existing spreadsheet
Here is an example of how to do this.
Using the window provided, your excel sheet must match roughly the same layout as the source test file. Really, you need a header row as the first row. Check the cellUpdate event for an example of how to edit the file.
Also, you need the module located here
Office Document Module
This module is a licensed module, but the methods from the module that are used in the above example as not licensed. They will run even after the module has expired.
On a side note, we are looking at making an Excel component. Anyone interested in a more feature rich component?
Test Source Excel file is located here
what exactly are you talking about? I know some of my customers would like things like being able to color cells and such on exports, which I dont think can be done in ignition currently.
@diat150 did you ever get this to work? I’m tasked with the same problem, and I’m curious how it turned out for you, and would you be interested in being hired to do the same for me? @Kyle_Chase you may have someone you can recommend for handling this, assuming you aren’t interested? I just now saw this was over 5 years ago, so this topic may have changed over that time.
This can all be done relatively easily with the XlsxWriter library.
I just responded to your email. We should be able to help you out.