Skip to main content
Solved

Data table

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

View original
Did this topic help answer your question?

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.

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings