Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
Excel post process script error
-
These are the functions which are supposed to exist in the post process script engine, setString being one of them.
String getString(int sheet, int column, int row) - get a String representation of the value of the cell String getString(String sheetName, int column, int row) - get a String representation of the value of the cell void setString(int sheet, int column, int row, String value) - set a cell to string type and with a string value void setString(String sheet, int column, int row, String value) - set a cell to string type and with a string value void setNumeric(int sheet, int column, int row, double value) - set a cell to numeric type and with a double value void setNumeric(String sheet, int column, int row, double value) - set a cell to numeric type and with a double value void setDate(int sheet, int column, int row, long value) - set a cell to date type and with a long value void setDate(String sheet, int column, int row, long value) - set a cell to date type and with a long value void openNamedRange(String namedRange, boolean append) - open a named range, optionally begin at its last cell void writeStringToNamedRange(String namedRange, value) - write a string value into the next cell of the named range void writeNumericToNamedRange(String namedRange, value) - write a numeric value into the next cell of the named range -
@psysak said in Excel post process script error:
ReferenceError: "setString" is not defined in <eval> at line number 16 in <eval> at line number 16
Sorry psysak, I'm not much help here. I can't find the code in github to see what should be happening. See if you can log your variables and ensure that you're inside a post process instance, that's the only way I can think of telling that you have inherited those set{dataType} methods.
Fox
-
No problem. I wonder if I'm invoking them wrong somehow but the documentation doesn't state anything specific. They're supposed to be part of ExcelReportUtility
The ExcelReportUtility is available in the post processing script of an Excel report. It enables one to read or write values to cells, and to write values into named ranges. One can "print(ExcelReportUtility);" from the post processing script entry to see a list of functions available. They are, String getString(int sheet, int column, int row) - get a String representation of the value of the cell String getString(String sheetName, int column, int row) - get a String representation of the value of the cell void setString(int sheet, int column, int row, String value) - set a cell to string type and with a string value void setString(String sheet, int column, int row, String value) - set a cell to string type and with a string value void setNumeric(int sheet, int column, int row, double value) - set a cell to numeric type and with a double value void setNumeric(String sheet, int column, int row, double value) - set a cell to numeric type and with a double value void setDate(int sheet, int column, int row, long value) - set a cell to date type and with a long value void setDate(String sheet, int column, int row, long value) - set a cell to date type and with a long value void openNamedRange(String namedRange, boolean append) - open a named range, optionally begin at its last cell void writeStringToNamedRange(String namedRange, value) - write a string value into the next cell of the named range void writeNumericToNamedRange(String namedRange, value) - write a numeric value into the next cell of the named range -
@psysak
try
ExcelReportUtility.setString(sheet,column,.row,"string")or create a var that hosts the ExcelReportUtility?
var ERU = new ExcelReportUtility() ERU.setString(sheetNum,col,row,string); -
Exactly what I just went off and tried and... it works :) Thanks @MattFox
-
Anytime!
:D -
Thanks Fox!
To clarify,
ExcelReportUtility.setString(sheet,column,row,"string")is the correct syntax. I don't think the instantiation of a
new ExcelReportUtility()would work. -
@phildunlap maybe this isn't the thread to ask this but it comes up in this context for me. Could you please explain a little bit about DataPointRT to me? CONTEXT_POINTS returns a DataPointRT object with an id and a name. I notice that I can get the ID just by referencing the property directly with .id, however .name is not a thing. How come and how would I get it?
-
You can see the functions in the class, and why it prints the string it does: https://github.com/infiniteautomation/ma-core-public/blob/main/Core/src/com/serotonin/m2m2/rt/dataImage/DataPointRT.java#L757
So you would have to go through the
.getVO()function to get the DataPointVO, which has a.name -
Ooooh ok, thanks Phil
-
You guys don't have some kind of visual representation for how all these things link together do you? I'm not a full time developer so it's really difficult to understand how all these little things bind to each other and why.
-
No such eureka! picture exists. If you clone the code into an IDE you can at least view the definition of one or another function with a hotkey like F3, which can let you scoot around the code faster.
Generally scripts were intended to get something like the name or other DataPointVO information via the DataPointWrapper in the script documentation, like,
p.getDataPointWrapper().getName();
