Import data to excel from the given folder
-
- Posts: 4
- Joined: Fri May 23, 2014 7:53 am
Import data to excel from the given folder
Can i import data to excel from the folder? eg: i have folder named Path which includes diiferent file names. and i want all the file names in that folder should automatically displayed in excel sheet which i am using to bound variables from my Script.
Re: Import data to excel from the given folder
Hi Komal,
this is more of an Excel programming related question. You have to use Macro programming to make this happen.
Here is an MSDN how-to about getting the file of a folder: http://msdn.microsoft.com/en-us/library/kf41fdf4.aspx
And to start macro programming: just use macro recordig, do some stuff in excel, and look the generated code. After that just use google. Make sure to include "vb" in your search term.
Kind Regards,
Zoltan
this is more of an Excel programming related question. You have to use Macro programming to make this happen.
Here is an MSDN how-to about getting the file of a folder: http://msdn.microsoft.com/en-us/library/kf41fdf4.aspx
And to start macro programming: just use macro recordig, do some stuff in excel, and look the generated code. After that just use google. Make sure to include "vb" in your search term.
Kind Regards,
Zoltan
Re: Import data to excel from the given folder
I think what he looks for is updating an existing excel data connector with some new data? I'm afraid, there is not an easy way to do so. I would suggest to check this post...
http://www.ranorex.com/forum/updating-e ... t4820.html
http://www.ranorex.com/forum/updating-e ... t4820.html
Pavel Kudrys
Ranorex explorer at Descartes Systems
Please add these details to your questions:
Ranorex explorer at Descartes Systems
Please add these details to your questions:
- Ranorex Snapshot. Learn how to create one >here<
- Ranorex xPath of problematic element(s)
- Ranorex version
- OS version
- HW configuration