Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Tue Mar 26, 2019 3:09 am

Hey,

Using Spire.XLS is it possible to refresh all external data connections as shown below?

Untitled.png
Untitled.png (12.46 KiB) Viewed 1700 times


Thanks,
Dylan

Dylan_Spire
 
Posts: 18
Joined: Wed Jun 15, 2016 1:28 am

Tue Mar 26, 2019 6:51 am

Hello Dylan,

Thank you for contacting.
Sorry that our Spire.XLS doesn’t support refreshing all external data connections at present. If there is any other question, just feel free to write back.

Sincerely,
Lisa
E-iceblue support team
User avatar

Lisa.Li
 
Posts: 1261
Joined: Wed Apr 25, 2018 3:20 am

Tue Mar 26, 2019 7:23 am

Hi,

Thanks for the fast reply. Would there be any alternative or work around? I was reading that Spire.xls could refresh pivot tables, so wouldn’t the this be similar?

Dylan_Spire
 
Posts: 18
Joined: Wed Jun 15, 2016 1:28 am

Tue Mar 26, 2019 7:57 am

Hello Dylan,

Sorry that there isn't any alternative or workaround for this. Our Spire.XLS could refresh pivot tables, at present it is also only for internal data sources. If there are external data connections, Spire.XLS also couldn't refresh pivot tables. Thanks for your understanding.

Sincerely,
Lisa
E-iceblue support team
User avatar

Lisa.Li
 
Posts: 1261
Joined: Wed Apr 25, 2018 3:20 am

Thu Apr 09, 2020 9:05 am

Is this a function that will become available?

tom.princen
 
Posts: 1
Joined: Mon Apr 06, 2020 3:22 pm

Thu Apr 09, 2020 9:31 am

Hi Tom,

Thanks for your inquiry.
Sorry to tell that this function is not planned in current upgrade list of our Spire.XLS.
If there is anything else we can do for you, please feel free to let us know.

Sincerely,
Rachel
E-iceblue support team
User avatar

rachel.lei
 
Posts: 1571
Joined: Tue Jul 09, 2019 2:22 am

Return to Spire.XLS