Get up to 40 % extra points for free! More info
Only this week sale up to 80 % on e-learning courses of Java
Java week

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

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.

Limited offer: Learn all knowledge and save money

Buy lessons and exercise submitting one by one 120 points
Buy all currently available lessons with exercise submitting and other features for an exclusive price 102 points ($9.18)
Currently, you have 0 points
By buying this exclusive package, you'll have access to all 25 lessons in this course including exercise submitting while saving $1.62. This offer is limited for the first lessons only with an additional exclusive 15% discount.
You gain 102 points for adding an article to the site, or for $10.80 $9.18

Warning, by buying just this lesson you'll lose the limited 15% discount for the package of all the lessons.

Buy only the lesson 10 points
Currently, you have 0 points
You gain 10 points for adding an article to the site, or for $0.90

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 points 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 (4)