Hi,

I need to convert xls to csv and download the file how can I achieve it.


Thanks,

Ronan T

Ronan T wrote:

Hi,

I need to convert xls to csv and download the file how can I achieve it.


Thanks,

Ronan T

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)


Solution

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

Solution

Pranav Pandey wrote:

Ronan T wrote:

Hi,

I need to convert xls to csv and download the file how can I achieve it.


Thanks,

Ronan T

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)


Hi,

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





Ronan T wrote:

Pranav Pandey wrote:

Ronan T wrote:

Hi,

I need to convert xls to csv and download the file how can I achieve it.


Thanks,

Ronan T

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)


Hi,

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





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

"text/plain"

and try again.

Pranav Pandey wrote:

Ronan T wrote:

Pranav Pandey wrote:

Ronan T wrote:

Hi,

I need to convert xls to csv and download the file how can I achieve it.


Thanks,

Ronan T

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)


Hi,

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





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

"text/plain"

and try again.

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.



Ronan T wrote:

Pranav Pandey wrote:

Ronan T wrote:

Pranav Pandey wrote:

Ronan T wrote:

Hi,

I need to convert xls to csv and download the file how can I achieve it.


Thanks,

Ronan T

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)


Hi,

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





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

"text/plain"

and try again.

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.




Need to check it . Let me do some RND.

Ronan T wrote:

Hi,

I need to convert xls to csv and download the file how can I achieve it.


Thanks,

Ronan T


Hi there Ronan.

You can see this component below:

https://www.outsystems.com/forge/component/23/csv/


Regards,

Carlos Alfradique

Tushar Panpaliya wrote:

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

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:

Tushar Panpaliya wrote:

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

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.


Hi,

It worked as Tushar Panpaliya said ,Thank you


Ronan T wrote:

Craig St. Jean wrote:

Tushar Panpaliya wrote:

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

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.


Hi,

It worked as Tushar Panpaliya said ,Thank you


Cheers.


Tushar