In my Web applications when we click excel button it saves the excel file to the selected location. It is generated dynamically and I need to check if the excel file contain the correct data or not. So I want to open that dynamically created excel file (which has the name of the current day current time including seconds ). How to open this file and how to change the name of the file

Share |

Create a script to find the Excel file path link in your web application and store it in your local system.

There should be some way to find/identify the link path. I can mention the code and object repository entry details if If see your web application.

And then, you can access the saved Excel using createobject as below.



Using this objExcel, you will be able to do whatever (including renaming file) you can do with Excel manually.

You can refer this article for sample usage of this excel object.

Share |

Yes, I agree with Rajamanickam this is a proper way to get Solution to your problem. You can easily create this kind of script with the help of javascript.

Share |

This information really helped me. Also, the article link worked good for me.

Share |