Refresh data from http link with Aspose

Aspose.Cells Product Family
1

Hello,

I am trying to refresh the data of cell “A1” of “inputDocument.xlsx” with Aspose.

My 1st link was a link to a file in a folder (=‘C:\Users\FHAU\Desktop\test[test_link.xlsx]Feuil1’!$A$1)

I changed the value in cell A1 of “test_link.xlsx” and when I execute the code and the data was refresh in cell “A1” of “inputDocument.xlsx”.

But in Excel it’s possible to use a http link (=‘[http://fhau/test/[test_link.xlsx]Feuil1](http://fhau/test/%5Btest_link.xlsx%5DFeuil1)’!$A$1) for refreshing the data.

Is it possible to refresh the data with an http link in Aspose as well? if yes do you have an example.

In attachment the code, the document I’ve used for the test. test.zip (13.2 KB)

ASPOSE.CELL 23.7

Thank you, best regards.

2

@ISIWARE,

Could you please zip and attach a sample Excel file having a valid http link in tact for a formula of the cell, we will check it soon.

3

Hi,
For the http link I’ve use IIS to create a local website with some folder containing my Excel source file and I use the HTTP link in Excel to access to the data, but I don’t think I can give you access to that. Can you do something similar on your side?

Thank you, best regards.

4

@ISIWARE,

Aspose.Cells can only open/read Excel spreadsheets either via file path (physical) or via streams. I think you may get Excel file from http/URL into streams by yourselves (using your own code) and then open/read it into Aspose.Cells.Workbook object model for parsing.