Lesson 14 - Working With MS Excel Documents Using OpenXML SDK in C# .NET New
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
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.
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
.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
folder. In this folder we'll be interested in
...End of the preview...
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.
- Unlimited and permanent access to individual lessons.
- High quality IT knowledge.
- Skills to help you get your dream and well-paid job.
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.