Displaying 1 result from an estimated 1 matches for "exampletable_1".
2011 Sep 15
2
Reading Parts of Excel Files (within a sheet)
...y to only read "parts" of excel files. Ex. Specify
cells (A1:G20), specify rows and columns to start reading at? Or will
I have to hack things together after the fact?
The URL below will let you download an example .xls of the kind of
thing I am working with:
http://www.filedropper.com/exampletable_1
I only want/need the "Code" column names, and the "Code" row names,
and the values. What would be the best way of automating the reading
of these spreadsheets?
Many thanks,
Peter