Get up to 80 % extra points for free! More info:

Lesson 17 - Working With MS Excel Documents Using OpenXML SDK in C# .NET

In the previous lesson, Working with MS Word Documents using Open XML SDK in C# .NET, we introduced the Open XML SDK library and finished working with .docx files.

In today's C# .NET tutorial, we'll introduce the xlsx format and start working on a simple database that stores information about cities that the user enters.

The xlsx Format

Xlsx is a format used by the MS Excel spreadsheet processor from the popular MS Office. It allows you to store data in tables that consist of rows and columns. These contain cells with data or formulas that work with data. This format is defined by the Office OpenXML specification.

SpredsheetML

Like a docx file, an xlsx file is basically a ZIP with XML files inside. Here, XML is called SpredsheetML. Microsoft calls an xlsx file a workbook. Each workbook then consists of worksheets (or only sheets) in which data is stored in cells.

Let's try to create a document in MS Excel, then change the extension from .xlsx to .zip and extract it to see how the data is stored in the file. Let's create this simple table:

In the newly created folder, among others, there is the xl\ folder. In this folder we'll be interested in


 

...End of the preview...
Continue further

You will gain knowledge worth hundreds of thousands for a few crowns

You've come here and that's great! We believe that the first lessons showed you something new and useful
Do you want to continue the course? Go to the premium section.

Buy this course

Buy all currently available lessons with exercise submitting and other features for just $10.80
Current account balance $0
By buying this package, you'll have access to all 19 articles (19 lessons) in this course.

This article is licensed: Premium, by buying this article, you agree with the terms of use.

What will you get from us in the next lessons?
  • Unlimited and permanent access to individual lessons.
  • High quality IT knowledge.
  • Skills to help you get your dream and well-paid job.

Article description

Requested article covers this content:

In the C# .NET tutorial, we'll learn to work with MS Excel files using the OpenXML SDK library, which we'll use for a small city database.

You gain credits by supporting our network. This is done by sending a helpful amount of money to support the site, or by creating content for the network.

Article has been written for you by Filip Smolík
Avatar
Activities