使用Aspose.Cells修改现有的SQL数据连接

使用 Aspose.Cells 修改现有 SQL 数据连接

以下示例说明了如何使用Aspose.Cells修改工作簿的SQL数据连接。你可以从以下链接下载用于此代码的源Excel文件和代码生成的输出Excel文件。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getDataDir(ModifyExistingSQLDataConnection.class);
// Create a workbook object from source file
Workbook workbook = new Workbook(dataDir + "DataConnection.xlsx");
// Access first Data Connection
ExternalConnection conn = workbook.getDataConnections().get(0);
// Change the Data Connection Name and Odc file
conn.setName("MyConnectionName");
conn.setOdcFile(dataDir + "MyDefaulConnection.odc");
// Change the Command Type, Command and Connection String
DBConnection dbConn = (DBConnection) conn;
dbConn.setCommandType(OLEDBCommandType.SQL_STATEMENT);
dbConn.setCommand("Select * from AdminTable");
dbConn.setConnectionInfo(
"Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False");
// Save the workbook
workbook.save(dataDir + "outxput.xlsx");