Embedding an excel document into an application with excel online

0 votes

In order to embed an excel document on our internal website, I have been trying the Excel online shared link. However, this approach is impractical because the private nature of the data prevents us from creating a public link.

I wanted to know if there was another way to embed an excel document. I can also say that we require an add-in for an excel document. In my test, my add-in didn't appear in the embedded version of the document, thus I may have made a mistake. I also observed a significant reduction in functionality. I could input some data even with read-write access, but I was unable to delete any of it, which wasn't very helpful in our situation.

Our goal is to be able to :

  1. embed excel document into an application.
  2. feed external data into the excel document when opened or on user input (done by an add-in)
  3. user interaction (read-write-delete according to defined locks and column visibility)
  4. save the relevant data to storage (done by an add-in)
  5. save the document to OneDrive and/or to a specific location.

I am wondering if there are any solutions (now or in progress) that would allow us to have most of the functionality of excel online while being managed by an application.

Possible solutions?:

Oct 1, 2022 in Others by Kithuzzz
• 38,000 points
870 views

1 answer to this question.

0 votes

You have to do the heavy lifting in JavaScript I'm afraid and add-ins are out of the question. See a very rudimentary example of how to interact with an embedded Excel file here: http://www.jkp-ads.com/Articles/embeddedexcel00.asp

answered Oct 2, 2022 by narikkadan
• 63,640 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

How to get the JasperReports into Excel format with proper alignment

Remove at least one parameter: exporter.setParameter(JRXlsExporterParameter.IS_COLLAPSE_ROW_SPAN,Boolean.TRUE) Note that JRXlsExportParameter is deprecated the correct ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
• 63,640 points
3,810 views
0 votes
1 answer

How to print an Excel Sheet using VBA with Nitro PDF Creator in Excel 2016

you can use the built-in excel facilities ...READ MORE

answered Sep 24, 2022 in Others by narikkadan
• 63,640 points
1,310 views
0 votes
1 answer

IF function in combination with an Round function Excel

I'm not sure if it is a ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 63,640 points
3,485 views
0 votes
1 answer

Excel automatically converting 7 digit CAS number to another number (date?)

Looks like you could use: The formula in D2: =SUBSTITUTE(F ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 63,640 points
986 views
0 votes
1 answer

JavaScript API does not work for Excel 2013?

Each method in the Office.js APIs is ...READ MORE

answered Sep 26, 2022 in Others by narikkadan
• 63,640 points
746 views
0 votes
1 answer

Open SAP from Excel VBA

It just means that there is no ...READ MORE

answered Sep 30, 2022 in Others by narikkadan
• 63,640 points
4,429 views
0 votes
1 answer

How to merge two cells in excel with same field name

Insert 2 new columns, G & H. Enter ...READ MORE

answered Oct 7, 2022 in Others by narikkadan
• 63,640 points
1,574 views
0 votes
1 answer

How to open an Excel Online document as a PDF

In light of your comment above, I ...READ MORE

answered Oct 18, 2022 in Others by narikkadan
• 63,640 points
512 views
0 votes
1 answer

How to insert info into online excel spreadsheet with python selenium

I recently discovered one of my options, ...READ MORE

answered Oct 24, 2022 in Others by narikkadan
• 63,640 points
1,282 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP