using IronXL; using System; using System.Linq; // Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV WorkBook workBook = WorkBook.Load("sample.xlsx"); // Select worksheet at index 0 WorkSheet workSheet = workBook.WorkSheets[0]; // Get any existing worksheet WorkSheet firstSheet = workBook.DefaultWorkSheet; // Select a cell and return the converted value int cellValue = workSheet["A2"].IntValue; // Read from ranges of cells elegantly. foreach (var cell in workSheet["A2:A10"]) { Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text); } // Calculate aggregate values such as Min, Max and Sum decimal sum = workSheet["A2:A10"].Sum(); // Linq compatible decimal max = workSheet["A2:A10"].Max(c => c.DecimalValue);

VIDEOS

How to Edit Workbook Metadata in C#

Name: IronXL
Brand: Iron Software
Availability: InStock
Rating: 4.67 (175 reviews)

Regan Pun

May 26, 2024

In this video tutorial, coders are guided through the process of editing workbook metadata using IronXL in C#. The tutorial starts with setting up a C# project in Visual Studio and ensuring IronXL is installed via the NuGet Package Manager. By navigating to the program.cs file, users learn to integrate IronXL into their project by adding the using IronXL directive at the top. The tutorial then demonstrates loading an Excel file named 'sample.xlsx' using the IronXL workbook class. Users are shown how to add metadata such as author, title, comments, and keywords to the Excel file, broadening its informational capacity. Additionally, the tutorial explains how to retrieve and set the file creation and last printed dates. After making these changes, users save their work to a new file named 'edited_metadata.xlsx'. Upon execution, the program applies the changes successfully, allowing users to compare the original and edited files side by side. The video concludes by highlighting IronXL's capabilities and encouraging viewers to explore further functionalities. Viewers are encouraged to subscribe for more tutorials and check out the IronXL software through the provided link.

Get stated with IronXL now.

Regan Pun

Chat with engineering team now

Software Engineer

Regan graduated from the University of Reading, with a BA in Electronic Engineering. Before joining Iron Software, his previous job roles had him laser-focused on single tasks; and what he most enjoys at Iron Software is the spectrum of work he gets to undertake, whether it’s adding value to sales, technical support, product development or marketing. He enjoys understanding the way developers are using the Iron Software library, and using that knowledge to continually improve documentation and develop the products.

< PREVIOUS
How to Group and Ungroup Rows and Columns in Excel

NEXT >
How to Create and Edit Excel Charts in C#