from ironxl import WorkBook

# Load an existing Excel spreadsheet.
# Replace 'sample.xlsx' with the path to your Excel file as needed.
workbook = WorkBook.Load("sample.xlsx")
# Select the first worksheet from the workbook
worksheet = workbook.WorkSheets[0]
# Access cell A2 and read its value
cell_value = worksheet["A2"].Value
print(f"Cell A2 has value '{cell_value}'")
# Iterate over the range A2:B10 and print each cell's address and text.
# Indexing a worksheet with a range string returns a Range, which is
# iterable; AddressString is the cell's location, Text its contents.
for cell in worksheet["A2:B10"]:
    print(f"Cell {cell.AddressString} has value '{cell.Text}'")

from ironxl import WorkBook, ExcelFileFormat, BorderType

# Create a new Excel WorkBook document in XLSX format
workbook = WorkBook.Create(ExcelFileFormat.XLSX)
# Set metadata for the workbook
workbook.Metadata.Author = "IronXL"
# Add a new blank worksheet named "main_sheet" to the workbook
worksheet = workbook.CreateWorkSheet("main_sheet")
# Add data to cell "A1"
worksheet["A1"].Value = "Hello World"
# Set the style for cell "A2" with a double bottom border and a specific color
worksheet["A2"].Style.BottomBorder.SetColor("#ff6600")
worksheet["A2"].Style.BottomBorder.Type = BorderType.Double
# Save the Excel file with the specified filename
workbook.SaveAs("NewExcelFile.xlsx")

from ironxl import *

# The guide opens a workbook before this snippet; open one here so the
# example runs on its own.
workBook = WorkBook.Load("sample.xlsx")
workSheet = workBook.WorkSheets[0]

workSheet.SaveAs("NewExcelFile.xls")
workSheet.SaveAs("NewExcelFile.xlsx")
workSheet.SaveAsCsv("NewExcelFile.csv")
workSheet.SaveAsJson("NewExcelFile.json")
workSheet.SaveAsXml("NewExcelFile.xml")

from ironxl import *

# The guide creates a worksheet before this snippet; create one here so
# the example runs on its own.
workBook = WorkBook.Create(ExcelFileFormat.XLSX)
workSheet = workBook.CreateWorkSheet("main_sheet")

# Set cell's value and styles
workSheet["A1"].Value = "Hello World"
workSheet["A2"].Style.BottomBorder.SetColor("#ff6600")
workSheet["A2"].Style.BottomBorder.Type = BorderType.Double

from ironxl import WorkBook

# Import IronXL library for handling Excel files
# Load an existing Excel workbook
# 'sample.xls' is the file name of the Excel workbook to be loaded
workbook = WorkBook.Load("sample.xls")
# Access the first worksheet in the workbook
# WorkSheets is the collection of all sheets in the workbook, 
# and we select the first one using index 0
worksheet = workbook.WorkSheets[0]
# Select a range of cells from A2 to A8 in the worksheet
# This specifies a contiguous range of cells starting from A2 and ending at A8
selected_range = worksheet["A2:A8"]
# Sort the selected range of cells in ascending order
# This operation reorders the values in the specified range from smallest to largest
selected_range.SortAscending()
# Save the changes made to the workbook, including the sorted range
# The workbook's state is updated with the changes after execution
workbook.Save()

from ironxl import *

# The guide creates a worksheet before this snippet; create one here so
# the example runs on its own.
workBook = WorkBook.Create(ExcelFileFormat.XLSX)
workSheet = workBook.CreateWorkSheet("main_sheet")

# Set a formula
workSheet["A1"].Formula = "=SUM(A2:A10)"
# Get the calculated value
sum_ = workSheet["A1"].DecimalValue