Ronan T wrote:

Hi Ronan T,

Can you explain what you exactly meant by converting the xls to csv. ?

1. If you want to export you result as csv file while downloading , then just append '.csv' after your file name.

2.If you want to download the file from you resource then just update the name as suggested in point 1.(see screen shot)

Pranav Pandey wrote:

Hi,

after converting xls to csv like as u said ,still we are getting file in xls format only.

Ronan T wrote:

Hi , Can you try updating the Mime-Type in the download property to

"text/plain"

and try again.

Pranav Pandey wrote:

"text/plain"

Hi,

I have tried with mime type as "text/plain" but it didn't work.

what i need is i have list of records and i need to generate/download it in .CSV file.

Not every clear what you intend to do here. But from what I can understand , you want to import some data form and xls file, make some changes(or maybe not) and then export it as a csv. 

If yes, 

then first step would be to import the xls in a record list . Then this record list can be exported as a csv. Outsystems download widget can be used for download. As well as a heap of forge components are present to choose from . 

I would go with below two components.

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

export :  https://www.outsystems.com/forge/component-overview/23/csv

Let me know if this helps. 

Cheers,

TP

Tushar Panpaliya wrote:

Ronan, have you given Tushar's direction a try?

An xls file is binary data, where as csv is text.  Simply adding .csv to the filename will result in a xls file that is named like a csv.  To get the desired result, I suggest following Tushar's approach:

1. Import the Excel sheet with the Advanced Excel component
2. Iterate through the records and build a CSV using the CSV component
3. Replace your End node with a file download node of the result of the CSV component.

Craig St. Jean wrote:

Hi,

It worked as Tushar Panpaliya said ,Thank you