im attempting to read data from excel and extract values from the file...
the excel data is pulled into a dataset and I would like to extract literals from this file that are in multiple columns...
the first column spans 4 columns (in column 2 of the spreadsheet) of which I want the literals.... then each of these 4 columns span 3 columns (in column 3 of the spreadsheet) of which I also want the litereals.. so I woul dwant the 12 literals that relate
to the column 1 (from columns 2 then 3 )
so im wondering if there is a way to drill down.. im not sure if these would load up as related to each other as they appear in excel?
hope this makes sense....
Go to the complete details ...