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'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
This article is licensed: Premium, by buying this article, you agree with the terms of use.
- 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.
