0

Is there a way we can update an existing Excel file using only PLSQL codes? I saw a working PLSQL code that can create an excel file and write a text into a cell I specified, as well as a PLSQL code that can read an existing excel file and return the text in the cell I specified. But haven't found any code that will update the text in the cell I specified in an existing Excel file.

Thank you in advance.

Karlo Imbat
  • 1

1 Answers1

1

As long as you refer to XLSX format, there are Anton Scheffer's (good old) AS_XLSX and AS_READ_XLSX packages.

peter.hrasko.sk
  • 4,043
  • 2
  • 19
  • 34