Modify existing SQL Data Connection

Aspose.Cells for Python via .NET supports modifying existing SQL Data Connection. The article will explain how to use Aspose.Cells for Python via .NET 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 for Python via .NET provides the means to access and modify the Data Connections using Workbook.DataConnections collection.

Modify existing SQL Data Connection using Aspose.Cells for Python via .NET

The following sample illustrates the use of Aspose.Cells for Python via .NET 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.

• Source Excel File
• Output Excel File

from aspose import pycore
from aspose.cells import Workbook
from aspose.cells.externalconnections import DBConnection, OLEDBCommandType

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
#  Create workbook object
workbook = Workbook(dataDir + "DataConnection.xlsx")
#  Access first Data Connection
conn = workbook.data_connections[0]
#  Change the Data Connection Name and Odc file
conn.name = "MyConnectionName"
conn.odc_file = "C:\\Users\\MyDefaulConnection.odc"
#  Change the Command Type, Command and Connection String
dbConn = pycore.as_of(conn, DBConnection) if pycore.is_assignable(conn, DBConnection) else None
dbConn.command_type = OLEDBCommandType.SQL_STATEMENT
dbConn.command = "Select * from AdminTable"
dbConn.connection_info = "Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False"
#  Save the workbook
workbook.save(dataDir + "output_out.xlsx")