Modify existing SQL Data Connection using Aspose.Cells
Contents
[
Hide
]
Aspose.Cells supports modifying existing SQL Data Connection. The article will explain how to use Aspose.Cells to modify different properties of SQL Data Connection.
You can add or see Data Connections inside Microsoft Excel by following Data > Connections menu command.
Similarly, Aspose.Cells provides the means to access and modify the Data Connections using Workbook.getDataConnections() collection.
Modify existing SQL Data Connection using Aspose.Cells
The following sample illustrates the use of Aspose.Cells to modify SQL Data Connection of the workbook. You can download the source Excel file used in this code and the output Excel file generated by the code from the following links.