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