Best way to populate Excel 2013 worksheet

Question

I want to use Excel as reporting tool. So how can I populate Excel 2013 sheet from Azure database using Visual studio C# web application? Create oData feed? Any better way?

Answer 1

Hi Kamip,

Thanks for posting in the MSDN Forum.

Do you means that you what to populate the data from the sqlAzure to Excel? I think you can use Open Xml SDK to approach your goal.

Have a good day,

Tom

---

Tom Xu [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Hi, Kamip

You should create your data web service as you would for any normal web application. There are several technologies you can use to build your app. For building apps internally, we've had success building a Windows Communication Foundation (WCF) REST service that returns JSON.

If you want some getting-started information on building this type of web service, take a look at Rob Tiffany's blog. It sounds like you're using Windows Azure as well, so you should also read Rob's follow-up post on moving your web service to Azure.

Depending on the scenario you're trying to achieve with the app in Excel, you can choose to either insert large amounts of data at once (setSelectedDataAsync() with coercion type "table") or selectively according to user inputs. 

Let us know if you have more questions! We'd love to hear more about your specific user-scenario.

-Michael