Very convenient because you can manipulate an Excel file as if it is a DBMS. However, OleDbConnection dosen’t support special behaviors like adding a color to a cell. MDAC(OleDbConnection needs it) also dosen’t support x64 or ‘ANY CPU’ platform.
Office components should be installed. If your application use this, it should be built for x86 platform. Other platforms are not supported by Office components.
supports special behaviors
supports x86, x64, and ‘ANY CPU’ platforms
- Using OpenXml SDK is not easy because references and resources are rare. Sometimes XML manipulation is required.
- Currently, OpenXml SDK only supports Office 2007.