IRONSOFTWARE
  • PRODUCTS
  • ENTERPRISE
  • FREE TOOLS
  • USE CASES
  • COMPANY
  • CONTACT US
205 N. Michigan Ave. Chicago, IL 60601, USA
+1 (312) 500-3060
CONTACT US
Icon Triangle related to 
									Start Here
  • Sales
  • Support
  • Partnerships
  • Corporate
Live Chat 24/5
  • En
      Icon Triangle related to 
									Start Here
    • English
    • Español
    • Deutsch
    • Français
    • 日本語
    • 简体中文
    • 繁體中文
  • Icon Triangle related to 
									Start Here
    • Customers Case Studies
    • Industry White Papers
    Icon Triangle related to 
									Start Here
    • About Us
      Icon Text Wearehiring related to 
									Start Here
    • Company News
      Icon Text Wearehiring related to 
									Start Here
    • Customers & Case Studies
      Icon Text Wearehiring related to 
									Start Here
    • Environmental Commitments
      Icon Text Wearehiring related to 
									Start Here
    • Startup Impact Grant
      Icon Text Wearehiring related to 
									Start Here
    • Beta Program
      Icon Text Wearehiring related to 
									Start Here
    • Year in Review: 2024
      Icon Text Wearehiring related to 
									Start Here
    • Careers
      Icon Text Wearehiring related to 
									Start Here
    • Consulting Partners
    • Content Creators
    • Resellers Partners
    • Technology Partners
    • Microsoft MVPs
    • Affiliates
    • Global Resellers
    • Merchant of Record
    • Trust Center
    • Sales
    • Support
    • Partnerships
    • Corporate
    Live Chat 24/5
    Icon Triangle related to 
									Start Here
    Icon Logo Ironsuite related to 
									Start Here

    IRONSUITE

    All 10 for the Price of 2

    Save 80% with Iron Suite
    Logo 1 Percent related to 
									Start Here
    Logo IronPDF
    Logo IronPDF

    Create, read, and edit PDFs

    Logo IronPPT
    Logo IronPPT

    Edit PowerPoint Files. No Office Interop required

    Logo IronQR
    Logo IronQR

    Read and write QR codes with ML detection

    Logo IronWebscraper
    Logo IronWebscraper

    Extract structured data from website

    Logo IronWord
    Logo IronWord

    Edit DOCX Word Files. No Office Interop required

    Logo IronOCR
    Logo IronOCR

    Image to text in 127 languages

    Logo IronPrint
    Logo IronPrint

    Customized Printing Files

    Logo IronXL
    Logo IronXL

    Edit Excel & CSV Files. No Office Interop required

    Logo IronBarcode
    Logo IronBarcode

    Read and write Barcodes

    Logo IronZIP
    Logo IronZIP

    Zip and unzip archives

    Icon Triangle related to 
									Start Here
    Icon Logo Ironsuite related to 
									Start Here
    Icon Text Ironsuite related to 
									Start Here

    Enterprise Licensing

    Icon Logo Ironsecuredoc related to 
									Start Here
    Icon Text Ironsecuredoc related to 
									Start Here

    PDF Security & Compliance

    Icon Triangle related to 
									Start Here
    Icon Logo Irondrawing related to 
									Start Here
    Icon Text Irondrawing related to 
									Start Here

    System.Drawing.Common Replacement

    Icon Logo Ironfreetools related to 
									Start Here
    Icon Text Ironfreetools related to 
									Start Here

    Free Software Development Tools

    IronSecureDoc
    • Home
    • REST API
    • Licensing
      • Licensing
      • EULA
      • Start Free Trial
    • Demos
      • Book a Live Demo
    • Docs
      • Get Started
      • Tutorials
      • How-Tos
      • Troubleshooting
      • Product Updates
    Search
    Ctrl
    K
    Start for Free
    Free Download Start Free Trial
    Logo Icon related to 
									Start Here
    IronSecureDoc
    for
    .NET
    • IRONSOFTWARE HOME
    • PRODUCTS
      • IRONSUITE

      • IRONPDF
        UPDATED
      • IRONWORD
      • IRONXL
      • IRONPPT
      • IRONOCR
      • IRONBARCODE
      • IRONQR
      • IRONZIP
      • IRONPRINT
      • IRONWEBSCRAPER
    • ENTERPRISE
      • IRONSUITE ENTERPRISE
      • IRONSECUREDOC
    • OPEN SOURCE
      • IRONDRAWING
      • IRONFREETOOLS
    • ABOUT US
      • About Us
      • Company News
      • Customers
      • Environmental Commitments
      • Beta Program
      • Year in Review: 2024
      • Live Chat
      • Global Resellers
      • Join our team
    • CONTACT US
    • HOME
    • REST API
    • LICENSING
      • Licensing
      • EULA

      • Start Free Trial
    • DEMOS
      • Book a Live Demo
    • DOCS
      • Get Started
      • Tutorials
      • How-Tos
      • Troubleshooting
      • Product Updates
    Message icon
    Start Here
    Start Here
    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()

    Start Here

    Related Docs Links

    Ready to get started? Version: 2024.10 just released

    Start for Free
    Free Download Start Free Trial
    View Licenses >
    Try IronSecureDoc for Free
    Get Set Up in 5 Minutes
    Icon Lightbulb related to 
									Start Here
    Python Module Download for Excel
    Install with Docker
    Version: 2024.10
     docker pull ironsoftwareofficial/ironsecuredoc
    https://hub.docker.com/r/ironsoftwareofficial/ironsecuredoc
    1. Pull the image:
      docker pull ironsoftwareofficial/ironsecuredoc:latest
    2. Run the Docker container:
      docker container run --rm -p 8080:8080 -e IronSecureDoc_LicenseKey= -e ENVIRONMENT=Development -e HTTP_PORTS=8080 ironsecuredoc:latest
    3. Open your web browser and navigate to `http://localhost:8080/swagger/index.html`⁠

    Have a question? Get in touch with our development team.

    15 1000 1
    Docker Logo
    Now you've installed with Docker
    Your browser is now downloading IronSecureDoc

    Next step: Start free 30-day Trial

    No credit card required

    • Test in a live environment
    • Fully-functional product
    • 24/5 technical support
    Get your free 30-day Trial Key instantly.
    Thank you.
    If you'd like to speak to our licensing team:

    badge_greencheck_in_yellowcircle
    The trial form was submitted
    successfully.

    Your trial key should be in the email.
    If it is not, please contact
    support@ironsoftware.com

    Schedule a call
    Have a question? Get in touch with our development team.
    No credit card or account creation required
    15 1000 1
    Docker Logo
    Now you've installed with Docker
    Your browser is now downloading IronSecureDoc

    Next step: Start free 30-day Trial

    No credit card required

    • Test in a live environment
    • Fully-functional product
    • 24/5 technical support
    Thank you.
    View your license options:
    Thank you.
    If you'd like to speak to our licensing team:
    View Licensing
    Schedule a call
    Have a question? Get in touch with our development team.
    Have a question? Get in touch with our development team.
    ironsecuredoc

    Get started for FREE

    No credit card required

    Test in a live environment

    Test in production without watermarks.
    Works wherever you need it to.

    bullet_test
    Fully-functional product

    Get 30 days of fully functional product.
    Have it up and running in minutes.

    bullet_calendar
    24/5 technical support

    Full access to our support engineering team during your product trial

    bullet_support
    Support Team Member 6 related to 
									Start Here									Support Team Member 14 related to 
									Start Here									Support Team Member 4 related to 
									Start Here									Support Team Member 2 related to 
									Start Here
    ironsecuredoc
    Get your free 30-day Trial Key instantly.

    bullet_checkedNo credit card or account creation required

    badge_greencheck_in_yellowcircle
    The trial form was submitted
    successfully.

    Your trial key should be in the email.
    If it is not, please contact
    support@ironsoftware.com

    Trusted by Millions of Engineers Worldwide
    • aetna_logo
    • wwf_logo
    • nasa_logo
    • usda_logo
    • 3m_logo
    • tesla_logo
    ironsecuredoc

    Get started for FREE

    No credit card required

    Test in a live environment

    Test in production without watermarks.
    Works wherever you need it to.

    bullet_test
    Fully-functional product

    Get 30 days of fully functional product.
    Have it up and running in minutes.

    bullet_calendar
    24/5 technical support

    Full access to our support engineering team during your product trial

    bullet_support
    Support Team Member 6 related to 
									Start Here									Support Team Member 14 related to 
									Start Here									Support Team Member 4 related to 
									Start Here									Support Team Member 2 related to 
									Start Here
    ironsecuredoc
    Get your free 30-day Trial Key instantly.
    Install with DockerHub
    View Licensing

    Licenses from $749. Have a question? Get in touch.

    Trusted by Millions of Engineers Worldwide
    • aetna_logo
    • wwf_logo
    • nasa_logo
    • usda_logo
    • 3m_logo
    • tesla_logo
    IronSecureDoc
    Book Free Live Demo

    Book a 30-minute, personal demo.

    No contract, no card details, no commitments.

    Iron Software Product Demo Team
    Here's what to expect:
    • A live demo of our product and its key features
    • Get project specific feature recommendations
    • All your questions are answered to make sure you have all the information you need.
      (No commitment whatsoever.)
    CHOOSE TIME
    YOUR INFO
    Book your free Live Demo
    Booking Badge related to 
									Start Here

    Trusted by Over 2 Million Engineers Worldwide

    Iron Software's customer logos
    Experience the full power of IronSecureDoc Start Free Trial
    Logo 1 Percent related to 
									Start Here
    Textlogo Iron Suite related to 
									Start Here

    IronSecureDoc is a part of
    IRONSUITE UNLIMITED

    10 .NET API products for your office documents

    Get 10 products for the price of 2   Start Free Trial
    • Icon Hash related to 
									Start Here
      ironpdf_logo
      - Create, read, and edit PDFs. HTML to PDF for .NET.
    • Icon Hash related to 
									Start Here
      ironword_logo
      - Edit DOCX Word Files. No Office Interop required.
    • Icon Hash related to 
									Start Here
      ironxl_logo
      - Edit Excel & CSV files. No Office Interop required.
    • Icon Hash related to 
									Start Here
      ironppt_logo
      - Create, read, and edit presentations. No Office Interop required.
    • Icon Hash related to 
									Start Here
      ironocr_logo
      - OCR (extract text from images) in 127 languages.
    • Icon Hash related to 
									Start Here
      ironbarcode_logo
      - Read and write QR & Barcodes.
    • Icon Hash related to 
									Start Here
      ironqr_logo
      - Read and write QR codes.
    • Icon Hash related to 
									Start Here
      ironzip_logo
      - Zip and unzip archives.
    • Icon Hash related to 
									Start Here
      ironprint_logo
      - Print documents in .NET applications.
    • Icon Hash related to 
									Start Here
      ironwebscraper_logo
      - Scrape structured data from websites.
    1% for the Planet
    IronSecureDoc is a part of
    IRONSUITE UNLIMITED

    10 .NET API products for your office documents

    Unlimited Enterprise Licensing
       Start Free Trial 
    • ironpdf_logo
      - Create, read, and edit PDFs. HTML to PDF for .NET.
    • ironword_logo
      - Edit DOCX Word Files. No Office Interop required.
    • ironxl_logo
      - Edit Excel & CSV files. No Office Interop required.
    • ironppt_logo
      - Create, read, and edit presentations. No Office Interop required.
    • ironocr_logo
      - OCR (extract text from images) in 127 languages.
    • ironbarcode_logo
      - Read and write QR & Barcodes.
    • ironqr_logo
      - Read and write QR codes.
    • ironzip_logo
      - Zip and unzip archives.
    • ironprint_logo
      - Print documents in .NET applications.
    • ironwebscraper_logo
      - Scrape structured data from websites.
    IronSecureDoc

    The Enterprise PDF Security & Compliance Server.

    Search

    CtrlK

    Tutorials

    • Get Started and Setup
    • Use the REST API
    • Use the C# Client
    • Blog

    Hosting Tutorials

    • Host on Windows
    • Host on Mac
    • Host on Linux
    • Host on Azure
    • Host on AWS

    Licensing

    • Buy a License
    • Use the Trial / License Key
    • EULA

    Try IronSecureDoc Free

    • Download on Docker
    • Start Free Trial
    1. IronSecureDoc
    2. Code Examples
    3. Excel Group & Ungroup Rows, Columns
    Back to top
    Iron Software
    205 N. Michigan Ave. Chicago, IL 60601 USA +1 (312) 500-3060
    • About Us
    • News
    • Customers
    • Careers
    • Academy
    • Webinars
    • Contact Us
    • English
      • English
      • Español
      • Deutsch
      • Français
      • 日本語
      • 简体中文
      • 繁體中文
    Github related to 
									Start Here									Youtube related to 
									Start Here									Twitter X related to 
									Start Here									Facebook related to 
									Start Here									Linkedin related to 
									Start Here
    Slack Icon related to 
									Start Here									Join Iron Slack

    Supporting Teamseas

    Copyright © Iron Software 2013-2025

    • Terms
    • Privacy
    • Cookie