Export Oracle table data to Excel from web Application

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

Answer 1

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

Answer 2

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/

Answer 3

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