CODEWITHSUNDEEP
office365apps-for-office
Ruediger Jungbeck
Ruediger Jungbeck

Reputation: 2964

Getting complete Excel sheet data in Office Add In

It is easy to get the selected part of a Excel 365 document with

 Office.context.document.getSelectedDataAsync()

But how do I get the complete sheet?

Upvotes: 0

Views: 95

Answers (1)

Christine Matheney
Christine Matheney

Reputation: 108

Right now, the only two things you can do are 

Office.context.documents.getSelectedDataAsync();

and

Office.context.document.getFileAsync();

We're unable to pull a sheet directly. Though, depending on the amount of data you're pulling, you may be able to use

Office.FilterType.OnlyVisible

Upvotes: 1

Related Questions