Web forum is in read-only mode. Login as active registered customer for write access
  Forum Search   New Posts New Posts

Data connection

 Post Reply Post Reply
Author
Coetzee Dirk View Drop Down
New Member
New Member
Avatar

Joined: 10 May 2018
Posts: 5
Post Options Post Options   Quote Coetzee Dirk Quote  Post ReplyReply Direct Link To This Post Topic: Data connection
    Posted: 10 May 2018 at 4:12pm
Hi, is there any way of reading the connection details, like a DSN name,  from a xlsx file using Flexcel.Net?
Back to Top
Adrian Gallero View Drop Down
TMS Support
TMS Support
Avatar

Joined: 18 May 2010
Posts: 1213
Post Options Post Options   Quote Adrian Gallero Quote  Post ReplyReply Direct Link To This Post Posted: 19 May 2018 at 3:59pm
Hi,
Sorry about the delay answering. Currently there is no way to read the data connections in a sheet, but I was hoping we could add it for the next release today so I kept delaying the answer until I knew it was possible.

Sadly we didn't got enough time to make it and test it for this release, so currently this is not possible. But I am hoping we can add this feature in the coming weeks.
Back to Top
Coetzee Dirk View Drop Down
New Member
New Member
Avatar

Joined: 10 May 2018
Posts: 5
Post Options Post Options   Quote Coetzee Dirk Quote  Post ReplyReply Direct Link To This Post Posted: 21 May 2018 at 1:53pm
Hi Adrian,

Many thanks. Do you have an ETA when the next release will be done, and possibly have this feature added?
Back to Top
Adrian Gallero View Drop Down
TMS Support
TMS Support
Avatar

Joined: 18 May 2010
Posts: 1213
Post Options Post Options   Quote Adrian Gallero Quote  Post ReplyReply Direct Link To This Post Posted: 21 May 2018 at 2:23pm
it will likely be mid of next month. I'll do what is possible to have it added.

Just to be sure, what exact data do you need on the connections?  Also, do you just want to read them or also would need to modify them?
Back to Top
Coetzee Dirk View Drop Down
New Member
New Member
Avatar

Joined: 10 May 2018
Posts: 5
Post Options Post Options   Quote Coetzee Dirk Quote  Post ReplyReply Direct Link To This Post Posted: 21 May 2018 at 2:40pm
All the details I can get:
DSN name and or connection string
only need to read them
Many thanks Adrian
Back to Top
Adrian Gallero View Drop Down
TMS Support
TMS Support
Avatar

Joined: 18 May 2010
Posts: 1213
Post Options Post Options   Quote Adrian Gallero Quote  Post ReplyReply Direct Link To This Post Posted: 27 Jun 2018 at 1:54am
Hi,
FlexCel 6.20 was just released and it includes a new GetDataConnections method that will return all the data on all the connections in the file. There is a SetDataConnections too in case you needed to modify some.
Back to Top
Coetzee Dirk View Drop Down
New Member
New Member
Avatar

Joined: 10 May 2018
Posts: 5
Post Options Post Options   Quote Coetzee Dirk Quote  Post ReplyReply Direct Link To This Post Posted: 27 Jun 2018 at 7:27am
Hi Adrian,

Many thanks
Downloading new version now.
Back to Top
Coetzee Dirk View Drop Down
New Member
New Member
Avatar

Joined: 10 May 2018
Posts: 5
Post Options Post Options   Quote Coetzee Dirk Quote  Post ReplyReply Direct Link To This Post Posted: 29 Jun 2018 at 6:56am
Working like a charm sir....
Thank you very much
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down