raksrules Oracle Feb 24, 2010 #1 Is there any way that i can read / write excel files (with multiple worksheets) using PL/SQL code units ? I know that csv is easily possible but excel is something i have never done. Any help appreciated.
Is there any way that i can read / write excel files (with multiple worksheets) using PL/SQL code units ? I know that csv is easily possible but excel is something i have never done. Any help appreciated.
Konquerror Inactive Forerunner Feb 24, 2010 #2 Make a csv file and open it in excel. Then save as excel workbook. I think this would work.
raksrules Oracle Feb 26, 2010 #3 ^^ Yes that would work but we also want to make multiple worksheet excel using PL SQL itself.