Laxmi_1
15 years agoOccasional Contributor
Read and Write Data into Excel
Hi,
In our application, we open some excel documents from data base and read\write data into that excel document and perform some calculations.
When i try to record excel document, i see that individual cells in the excel are not recorded and instead pixel positions are recorded.
Is there some way to read and write data into excel which is already opened.
I found some code for reading data from Excel, but it specified the path where excel is present. But it may not help us as we dont have excel's stored in the machine. We fetch them from DataBase.
Please help me find a way to do this.
Thanks in advance,
Laxmi.
In our application, we open some excel documents from data base and read\write data into that excel document and perform some calculations.
When i try to record excel document, i see that individual cells in the excel are not recorded and instead pixel positions are recorded.
Is there some way to read and write data into excel which is already opened.
I found some code for reading data from Excel, but it specified the path where excel is present. But it may not help us as we dont have excel's stored in the machine. We fetch them from DataBase.
Please help me find a way to do this.
Thanks in advance,
Laxmi.