Edit excel file within OutSystems Application

Edit excel file within OutSystems Application

  

Has anyone developed the capability to edit a spreadsheet (stored in the database as a binary format file) within the window of an OutSystems application?

I know this sort of functionality is possible using tools like Sharepoint but I would like to store and edit the files I am managing in OutSystems if possible.

Excel and Sharepoint are both Microsoft so they work well together because Sharepoint would be a terrible file repository if it couldn't edit its own files.

OutSystems can

1) upload an excel

1) read an Excel into a record list

2) provide you with an editable table for records changing

3) save records into excel

4) save binary into database

So yes, you can edit a database stored Excel in OutSystems, as long as it has a limited number of columns and you don't need formulas (because you'd need to create the edit/calculate/show webblock).

Are you motivated to do it like this?

Hi Nuno,

That method is great for simple and well defined spreadsheets that have a consistent structure, however, we have very differing structures and sometimes a complex content which would be good to almost have an Excel plugin such as in OneDrive/Sharepoint or Sheets for Google Docs, that can be made use of in order to edit the spreadsheet and save back to the same location in OutSystems app.

Daniel Asserati wrote:

Hi Nuno,

That method is great for simple and well defined spreadsheets that have a consistent structure, however, we have very differing structures and sometimes a complex content which would be good to almost have an Excel plugin such as in OneDrive/Sharepoint or Sheets for Google Docs, that can be made use of in order to edit the spreadsheet and save back to the same location in OutSystems app.

Last night I've tried to do something for the basic scenario, and only the "edit mode/view mode" is hard. The references to other cells are crazy.

Save to the same place may be complicated since it is into DB. Do plugins implement anything like that?

Nuno Reis wrote:

Daniel Asserati wrote:

Hi Nuno,

That method is great for simple and well defined spreadsheets that have a consistent structure, however, we have very differing structures and sometimes a complex content which would be good to almost have an Excel plugin such as in OneDrive/Sharepoint or Sheets for Google Docs, that can be made use of in order to edit the spreadsheet and save back to the same location in OutSystems app.

Last night I've tried to do something for the basic scenario, and only the "edit mode/view mode" is hard. The references to other cells are crazy.

Save to the same place may be complicated since it is into DB. Do plugins implement anything like that?

Thats exactly what I have been thinking about.  Ideally we could call an excel plugin and pass in the binary to open in "Excel Web" which when saved then sends back the new binary.