Is there a way to change the format (string versus number) of a column using the post import code? The first values in the imported Excel table are not indicative of the format. I want to force all the columns to text using the import then switch some of them to numeric after the import. I know I can do this in the interface but I want to automate it each time the file imports.
I just tried to set the columns B-F as Text in Excel and import. Column B has a mixture of numbers and text in FlexSim. I need them to be all text. The data is on the "schedule" tab.
If you import using the "Values Only" method, I think they will come in as mixed numbers and text. Then you could write post-import code like this:
Table myTable = Table("tableName");
for (int i = 1; i <= myTable.numRows; i++) {
Variant value = myTable[i][col_index];
if (value.type == VAR_TYPE_NUMBER) {
myTable[i][col_index] = string.fromNum(value);
}
}
8 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.