Skip to main content
P
Pushpi
Cadet | Tier 2
August 28, 2024
Solved

Data table

  • August 28, 2024
  • 2 replies
  • 150 views

Hi , while I was trying to fetch the data table from database  it's asking me to download that data in CSV file. Can't we download it as a Excel.

Best answer by Aravindh483

You can only save as csv by using read from database. if you need to store in excel file. please add below logic.

  1. Open csv file.
  2. Read csv and store the data in table.
  3. close csv
  4. create excel workbook
  5. write from Datatable

 

Thanks,

Aravindh S

aravindhkumar002@gmail.com

2 replies

A
Aravindh483Answer
Navigator | Tier 3
August 29, 2024

You can only save as csv by using read from database. if you need to store in excel file. please add below logic.

  1. Open csv file.
  2. Read csv and store the data in table.
  3. close csv
  4. create excel workbook
  5. write from Datatable

 

Thanks,

Aravindh S

aravindhkumar002@gmail.com

P
PushpiAuthor
Cadet | Tier 2
August 30, 2024

Thanks bro, it's working.

Terms & ConditionsAccessibility statement