Creating a CSpro dictionary from an excel file

Other discussions about CSPro
Post Reply
AriSilva
Posts: 433
Joined: July 22nd, 2016, 3:55 pm

Creating a CSpro dictionary from an excel file

Post by AriSilva » 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?
Best
Ari

josh
Posts: 2291
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: Creating a CSpro dictionary from an excel file

Post by josh » November 13th, 2020, 9:11 am

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.

AriSilva
Posts: 433
Joined: July 22nd, 2016, 3:55 pm

Re: Creating a CSpro dictionary from an excel file

Post by AriSilva » November 13th, 2020, 12:43 pm

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.
Best
Ari

Post Reply