CODEWITHSUNDEEP
c#.netexport-to-excelexport-to-csv
user1139525
user1139525

Reputation: 11

Multiple Oracle Data Export to individual spreadsheet in a single excel using C#.net

I have 10 Select queries in Oracle PL/SQl(each will return atleast 1000 records). How can I export Each Select Query Data returned in a separate(multiple) spreadsheets in a Single Excel File like Data returned from Query1 should be in spreadsheet1 and data returned from Query2 should be in spreadsheet2 like wise using C#.net.

Thanks in advance

Upvotes: 0

Views: 666

Answers (1)

Joshua Shane Martin
Joshua Shane Martin

Reputation: 21

Use a library like NPIO, which can create and manipulate Excel files. Follow their tutorial at http://www.leniel.net/2009/07/creating-excel-spreadsheets-xls-xlsx-c.html in order to create "worksheets" within the "workbook".

Upvotes: 1

Related Questions