from ironxl import * # Supported for XLSX, XLS, XLSM, XLTX, CSV, and TSV workbook = WorkBook.Load("sample.xlsx") # Select worksheet at index 0 worksheet = workbook.WorkSheets[0] # Get any existing worksheet first_sheet = workbook.DefaultWorkSheet # Select a cell and return the converted value cell_value = worksheet["A2"].IntValue # Read from ranges of cells elegantly. for cell in worksheet["A2:A10"]: print("Cell {} has value '{}'".format(cell.AddressString, cell.Text)) # Calculate aggregate values such as Min, and Sum total_sum = worksheet["A2:A10"].Sum()
#Supported for XLSX, XLS, XLSM, XLTX, CSV, and TSV #Select worksheet at index 0 #Get any existing worksheet #Select a cell and return the converted value #Read from ranges of cells elegantly. #Calculate aggregate values such as Min, and Sum 'INSTANT VB TODO TASK: The following line uses invalid syntax: 'from ironxl import * workbook = WorkBook.Load("sample.xlsx") worksheet = workbook.WorkSheets[0] first_sheet = workbook.DefaultWorkSheet cell_value = worksheet["A2"].IntValue for cell in worksheet["A2:A10"]: print("Cell {} has value '{}'".format(cell.AddressString, cell.Text)) total_sum = worksheet["A2:A10"].Sum()