hiv_workflow.lib.utils.io.excel module¶
-
hiv_workflow.lib.utils.io.excel.read_block(ws, range)¶ Reads data from the specified range. Result is a list of data by row, each of those being a list (by col). Converts all ‘’ strings to None. :param ws: an openpyxl worksheet object :param range: an openpyxl range object :return: data from the requested 2D worksheet range, in row-major order (list of lists)
-
hiv_workflow.lib.utils.io.excel.read_list(ws, range)¶ Read in a linear 1xN or Nx1 range of cells from an excel spreadsheet :param ws: an openpyxl worksheet object :param range: an openpyxl range object :return: data from the requested row/column as a list of items