Extract Theme Data from Excel File

C# code to extract theme data from Excel file

The following sample code extracts the Theme name applied to source workbook and then it extracts the Theme color applied to cell A1 and Theme color applied to the bottom border of the cell.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
// Create workbook object
Workbook workbook = new Workbook(dataDir + "source.xlsx");
// Extract theme name applied to this workbook
Console.WriteLine(workbook.Theme);
// Access first worksheet
Worksheet worksheet = workbook.Worksheets[0];
// Access cell A1
Cell cell = worksheet.Cells["A1"];
// Get the style object
Style style = cell.GetStyle();
if (style.ForegroundThemeColor != null)
{
// Extract theme color applied to this cell if theme has foregroundtheme color defined
Console.WriteLine(style.ForegroundThemeColor.ColorType);
}
else
{
Console.WriteLine("Theme has not foreground color defined.");
}
// Extract theme color applied to the bottom border of the cell if theme has border color defined
Border bot = style.Borders[BorderType.BottomBorder];
if (bot.ThemeColor != null)
{
Console.WriteLine(bot.ThemeColor.ColorType);
}
else
{
Console.WriteLine("Theme has not Border color defined.");
}