locked
Export Oracle table data to Excel from web Application RRS feed

  • Question

  • User-73514677 posted

    Hi.

    How to bulk export data from Oracle table to Excel, which can be downloaded / opened by end user ?

    I am using C# web application . The data which is available in the table is huge . What is the best way to transfer data to excel ?

    I thought of SSIS option, but here I have the table names which are user input and get changed every time. Also, if SSIS to be used, how to pass the parameter from web application to the SSIS package ? What are the other ways to bulk export the data to Excel using  C# ?

    Thanks

    Tuesday, April 21, 2020 8:05 AM

All replies

  • User1535942433 posted

    Hi venkatzeus,

    Accroding to your description,as far as I think,you could download an external dll in your application.ADO.net read the data from Oracle and return the data to datatable.Then export datatable to excel.

    More details,you could refer to below article:

    https://forums.asp.net/t/2066840.aspx?Best+way+to+export+data+from+a+Datatable+to+Excel+using+C+

    Best regards,

    Yijing Sun

    Wednesday, April 22, 2020 3:00 AM
  • User364663285 posted

    Hi.

    How to bulk export data from Oracle table to Excel, which can be downloaded / opened by end user ?

    I am using C# web application . The data which is available in the table is huge . What is the best way to transfer data to excel ?

    I thought of SSIS option, but here I have the table names which are user input and get changed every time. Also, if SSIS to be used, how to pass the parameter from web application to the SSIS package ? What are the other ways to bulk export the data to Excel using  C# ?

    Thanks

    Hi,

    You can also create ODBC connection from Excel, with Oracle DB. Read

    http://learnexcelmacro.com/wp/2011/11/oracle-connection-string-in-vba/

    Sunday, May 3, 2020 3:38 PM
  • User364663285 posted

    Hi.

    How to bulk export data from Oracle table to Excel, which can be downloaded / opened by end user ?

    I am using C# web application . The data which is available in the table is huge . What is the best way to transfer data to excel ?

    I thought of SSIS option, but here I have the table names which are user input and get changed every time. Also, if SSIS to be used, how to pass the parameter from web application to the SSIS package ? What are the other ways to bulk export the data to Excel using  C# ?

    Thanks

    Hi,
    I think you can also use ODBC to connect to Oracle DB, within Excel file.

    https://www.devart.com/odbc/oracle/docs/excel.htm

    Sunday, May 31, 2020 3:28 PM