Creating a CSpro dictionary from an excel file
Posted: November 13th, 2020, 8:52 am
In order to use the "Excel to Cspro" tool create a csdb file from an excel file, we need first to have a cspro dictionary, and there is where it comes the problem:
I have an excel file with almost 200 columns, and writing a cspro dictionary for that file, by hand, well.
I thought about writing a cspro program to read this excel file (as text, in csv format), reading the first line to capture the future variable names, and then, for each column, see if there is letters or just numbers (this would define if the variable would be alpha or numeric).
And also see the maximum cell size for each column (this would determine the variable size).
Does anybody already wrote a program like that?
Or does it have another available solution for that problem?
I have an excel file with almost 200 columns, and writing a cspro dictionary for that file, by hand, well.
I thought about writing a cspro program to read this excel file (as text, in csv format), reading the first line to capture the future variable names, and then, for each column, see if there is letters or just numbers (this would define if the variable would be alpha or numeric).
And also see the maximum cell size for each column (this would determine the variable size).
Does anybody already wrote a program like that?
Or does it have another available solution for that problem?