Skip to main content
Solved

Data table

  • August 28, 2024
  • 2 replies
  • 85 views
P
Forum|alt.badge.img+3

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
Forum|alt.badge.img+4
  • Aravindh483
  • Navigator | Tier 3
  • 20 replies
  • Answer
  • 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
Forum|alt.badge.img+3
  • Pushpi
  • Author
  • Cadet | Tier 2
  • 4 replies
  • August 30, 2024

Thanks bro, it's working.


Terms & ConditionsCookie settingsAccessibility statement