Only this week 80 % discount on e-learning courses of C# .NET
Get up to 60 % extra points for free! More info
discount  week 60

Lesson 18 - Finishing Our City Database using MS Excel Files in C# .NET

In the previous lesson, Working With MS Excel Documents Using OpenXML SDK in C# .NET , we introduced the MS Excel file format and started working on a simple city database.

In today's C# .NET tutorial, we'll finish our simple database that stores city data using xlsx files.

A TableManager Class

We'll add a new TableManager class, which will take care of saving and loading data from an xlsx file. In this class, we'll first add necessary using statements and create a variable with the file's path. For simplicity, we'll save the file directly to the program's folder:

using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;
using System.Collections.Generic;
using System.IO;
using System.Linq;

namespace CityDatabase
    class TableManager
        string filePath = @"database.xlsx";

A CreateDocumentBasis() Method

Next, we'll add


...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 80 points ($7.20)
Currently, you have 0 points
By buying this exclusive package, you'll have access to all 26 lessons in this course including exercise submitting while saving $3.60. This is a time limited offer for all lessons in this course. Buy it now and gain a limited 33% discount.
You gain 80 points for adding an article to the site, or for $10.80 $7.20
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 finish our simple city database using MS Excel files. We'll learn how to write to these files and how to read from them.

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