读取和写入XLS和XLSB文件的外部连接
Contents
[
Hide
]
可能的使用场景
Aspose.Cells已经支持读取和写入XLSX文件的外部连接,现在它也支持XLSB和XLS文件的此功能。然而,所有格式的代码都是相同的。
读取和写入XLS/XLSB文件的外部连接
以下示例代码加载了示例XLSB文件(XLS也可以被加载),并读取其第一个外部连接,这实际上是一个Microsoft Access DB连接。然后修改了DBConnection.Name属性并将其保存为输出的XLS/XLSB文件。截屏展示了在执行代码后示例XLSB文件和输出XLSB文件上的效果。请还参阅下面给出的示例代码的控制台输出以供参考。
示例代码
以下代码可以加载和保存具有适当扩展名的XLSB和XLS文件。
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
//Load the source Excel Xlsb file | |
Workbook wb = new Workbook("sampleExternalConnection_XLSB.xlsb"); | |
//Read the first external connection which is actually a DB-Connection | |
Aspose.Cells.ExternalConnections.DBConnection dbCon = wb.DataConnections[0] as Aspose.Cells.ExternalConnections.DBConnection; | |
//Print the Name, Command and Connection Info of the DB-Connection | |
Console.WriteLine("Connection Name: " + dbCon.Name); | |
Console.WriteLine("Command: " + dbCon.Command); | |
Console.WriteLine("Connection Info: " + dbCon.ConnectionString); | |
//Modify the Connection Name | |
dbCon.Name = "NewCust"; | |
//Save the Excel Xlsb file | |
wb.Save("outputExternalConnection_XLSB.xlsb"); |
控制台输出
Connection Name: Cust
Command: Customer
Connection Info: Provider=Microsoft.ACE.OLEDB.12.0;Password="";User ID=Admin;Data Source=C:\TempSha\Cust.accdb;Mode=Share Deny Write;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=6;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False;Jet OLEDB:Bypass UserInfo Validation=False;Jet OLEDB:Limited DB Caching=False;Jet OLEDB:Bypass ChoiceField Validation=False