Are there any resources available to manipulate incoming spreadsheet data?
I’m importing cable descriptions for post stress concrete. There is a variety of data (string, integer, double). i need to capture the point data (double) as well the description data (anchor type, size, etc…). I do need to organize the data into lists for geometry and table creation. I’m having difficulty finding the right tools to find the data and then isolate it for further refinement and utilization.
I’m looking for code snipets, and any guidelines for taking apart the spreadsheet. the incoming data is column labeled so I do transpose the data upon import. However, it creates a number of levels in the lists that make it difficult to understand how and what I should be going after.
Any help would be appreciated!