Excel Interop Code Examples

Writing code in C# with Excel Interop.

All code examples begin and end with

Excel.Application app = new Excel.Application(); // Create Excel object instance
app.DisplayAlerts = false; // Don't display any Excel prompts
Excel.Workbook wb = app.Workbooks.Open(input_filepath); // Create workbook instance

[ANY CODE EXAMPLE]

wb.Close(); // Close workbook
app.Quit(); // Quit Excel application

Find and remove data connections

int count_conn = wb.Connections.Count;
if (count_conn > 0)
{
    for (int i = 1; i <= wb.Connections.Count; i++)
    {
        wb.Connections[i].Delete();
        i = i - 1;
    }
    count_conn = wb.Connections.Count;
    Console.WriteLine("--> Data connections detected and removed");
}

wb.Save(); // Save workbook

Remove author, subject and comments from file property details

if (wb.Author != "" || wb.Subject != "" || wb.Comments != "") // Inform user of removal of file property details
{
    Console.WriteLine("--> Removed file property details");
}

wb.Author = ""; // Remove author information
wb.Subject = ""; // Remove subject information
wb.Comments = ""; // Remove comments information

wb.Save(); // Save workbook

Convert to .xlsx Strict

wb.SaveAs(filepath, 61); // Save workbook as .xlsx Strict