Create Excel Data Query pointing to OData Feed

Aspose.Cells Product Family
1

Is it possible to setup a query in Excel via Aspose.Cells - we need to create a query, which is getting its data from an odata feed.

1 Like
2

@lsk,

Aspose.Cells API does not support external sources so creating such a data query may not be possible. However, I have logged it as feature request although it may not be supported in near future.

CELLSNET-46512 - Create Excel Data Query pointing to OData Feed

Once we have an update on it, we will let you know here.

2 Likes
3

@lsk,

Please share a template file with Data Query pointing to OData Feed , we will look into it soon.

4

Hi, I have created a very simple sample with excel / getting data from a public odata feed. Please find attached file.Sample of odata in Excel.zip (109.7 KB)
plus more input in word document (also inside zip file)

5

@lsk,

Thank you for providing the template file and description. We have logged it along with the ticket for later reference.

6

@lsk,

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.