jeudi 14 juillet 2016

Java POI api to update excel data in background without closing excel?

Is there any way to update excel content in background when the sheet is in open state.
I am using Apache POI Spreadsheet API (java based API) to read and write content in excel sheet.
By using user API, I am saving data to excel sheet, but I didn't find any API to update excel data in background(without closing excel file, content should be updated).
Please help me to find an API to achieve this by using Apache POI or any other API.
(I observed by using VB script we can achieve this. but first preference is Java, if there is no other API available then VB Script).

Aucun commentaire:

Enregistrer un commentaire