Book Image

Blazor WebAssembly by Example, 2e - Second Edition

By : Toi B. Wright
5 (1)
Book Image

Blazor WebAssembly by Example, 2e - Second Edition

5 (1)
By: Toi B. Wright

Overview of this book

Blazor WebAssembly helps developers build web applications without the need for JavaScript, plugins, or add-ons. With its continued growth in popularity, getting started with Blazor now can open doors to new career paths and exciting projects – and Blazor WebAssembly by Example will make your first steps easier. This is a project-based guide that will teach you how to build single-page web applications with Blazor, focusing heavily on the practical over the theoretical by providing detailed step-by-step instructions for each project. The author also includes a video for each project showing her following the step-by-step instructions, so readers can use them if they're unsure about any particular step. In this updated edition, you'll start by building simple standalone web applications and gradually progress to developing more advanced hosted web applications with SQL Server backends. Each project will cover a different aspect of the Blazor WebAssembly ecosystem, such as Razor components, JavaScript interop, security, event handling, debugging on the client, application state, and dependency injection. The book’s projects get more challenging as you progress, but you don’t have to complete them in order, which makes this book a valuable resource for beginners as well as those who just want to dip into specific topics. By the end of this book, you will have experience and lots of know-how on how to build a wide variety of single-page web applications with .NET, Blazor WebAssembly, and C#.
Table of Contents (15 chapters)
13
Other Books You May Enjoy
14
Index

Reading Excel files

We can read and write to Microsoft Excel files using the Open XML SDK. It provides the tools for us to work with not only Excel files but also Word and PowerPoint files. To use the Open XML SDK, we need to add the DocumentFormat.OpenXml NuGet package to our project.

Modern Excel files with the XLSX file extension are made up of a compressed collection of XML files. To view the individual files, change the file extension from XLSX to ZIP and view the files using a .zip viewer. You can also extract the files.

When using the Open XML SDK, the Excel document is represented with the SpreadsheetDocument class. This is the hierarchy of the elements in the class:

  • workbook – the root element of the document
  • sheets – the container for the sheets
  • sheet – the pointer to the sheet definition file
  • worksheet – the sheet definition that contains the sheet data
  • sheetData – the data
  • row –...