Spreadsheetgear: Example

Use .Value for raw data, .Text for formatted display.

To run the following , you will need to add the library to your project. You can do this via NuGet Package Manager in Visual Studio.

Reading an existing file is just as easy. Here is a that loads a file and reads data. spreadsheetgear example

public FileResult OnGet() // Open a template that already has your branding and styles SpreadsheetGear.IWorkbook workbook = SpreadsheetGear.Factory.GetWorkbook("template.xlsx"); SpreadsheetGear.IWorksheet worksheet = workbook.Worksheets[0]; // Fill the template with dynamic data IRange dataRange = worksheet.Cells["B2:B5"]; dataRange.Formula = "=RAND() * 1000"; // Dynamic calculation example // Save to a memory stream for the browser System.IO.Stream stream = workbook.SaveToStream(SpreadsheetGear.FileFormat.OpenXMLWorkbook); stream.Seek(0, System.IO.SeekOrigin.Begin); return File(stream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "Report.xlsx"); Use code with caution. Source: Live Razor Pages Sample . 3. High-Performance Calculations

// 8. Auto-fit columns for readability worksheet.Cells["A:D"].Columns.AutoFit(); Reading an existing file is just as easy

: It can perform complex calculations and data transfers significantly quicker than Excel.

sheet.Cells["A:A"].Columns.AutoFit();

SpreadsheetGear allows developers to perform complex spreadsheet tasks without having Excel installed on the machine. Key features include: High-Performance Calculation:

// 4. Add sample data (normally from DB) worksheet.Cells["A2"].Value = "Widget A"; worksheet.Cells["B2"].Value = 150; worksheet.Cells["C2"].Value = 12.99; Source: Live Razor Pages Sample

The best part? All code above runs on any .NET platform (Framework, Core, 5/6/7/8), in any thread, without popups, without licenses for deployment (royalty-free runtime). You pay once for development and distribute unlimited.

We will cover the basics of setup, explore the creation of workbooks from scratch, demonstrate how to utilize formulas, and show you how to leverage the unique SpreadsheetGear for .NET Windows Forms control.