Hi,
I am using this simple code:
IO = New FileStream(fp, FileMode.Open, FileAccess.ReadWrite, FileShare.ReadWrite) WB = Workbook.Load(IO, False) WB.Recalculate() WB.Save(IO) Catch ex As Exce
The problem is that existing Connections to databases are removed when saving. How can I retain them?
thanks
The Excel library does not currently support round-tripping database connections. I have forwarded this post to the Developer Support Manager to create a feature request on your behalf.
Henrik,
I have submitted your idea to our product management team. The reference number for this request is PI13020080. A support case has also been opened for you with case number CAS-110531-R2S6Z9. If you would like to follow up on your product idea at a later point you may contact Developer Support via email. You can reach Developer Support management through this e-mail address: dsmanager@infragistics.com. Thank you for your request.
I will submit this as a Feature Request on your behalf.