CSPro Users Forum

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?

The Excel2CSPro tool can create a dictionary from a spreadsheet if you click on the second tab. Does that not work in your case? I can't say I've tested it on a file with 200 columns but I use it all the time to create dictionaries for lookup files.

Thanks, Josh,
In fact, my fault, I´ve never seen that second tab.
I´ll try with that huge excel of mine and will keep you posted.