Helper function to parse full excel address into sheet, row, column. Removes
'
from sheet names. If given a cell range, returns only the address of the first cell.
Arguments
- address
Character string of excel address, including sheet.
Value
list, with $sheet
giving sheet name, $rows
givng the row number, $cols
giving the column number.