599
Views
3
Comments
Solved
I want to create excel template and download
Application Type
Traditional Web


I want to create excel template and download

Can anyone tell me how to create template as below 

If you can attach sample OML, it will be very helpful


2020-11-13 07-48-15
Khuong Truong
Solution

Hi Hash,

The excel template is fixed or dynamic?

If it's fixed so you can create an excel file and import resource (right click Resource folder under Data tab).

Then for downloading, you can use server action to get binary data.

Hope you get the idea,

Khuong

2022-02-07 08-52-30
Pranav Pandey

Hi HASH AMR,

As Khuong Truong suggested if it's a static one then you just need to create a template and save it in your resource area. But if you want to read the data from the file or want to generate a dynamic template, you need to make use of some extension. Have a look at the below link. I have used this extension for reading/writing data from a particular cell of an excel sheet.

https://www.outsystems.com/forge/component-overview/355/advanced-excel

I hope this would be usedful.

Thanks 

Pranav

2023-03-16 16-29-51
Paulo Rosário

Hello HASH AMR

I attached an OML with a simple link to download a resource and some screenshots. 

Hope it helps! 

Paulo Rosário

ResourceDwonload.oml
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.