Import data to excel from the given folder

Ask general questions here.
Komal Jadhav
Posts: 4
Joined: Fri May 23, 2014 7:53 am

Import data to excel from the given folder

Post by Komal Jadhav » Thu Jun 05, 2014 7:47 am

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.

mzperix
Posts: 137
Joined: Fri Apr 06, 2012 12:19 pm

Re: Import data to excel from the given folder

Post by mzperix » Thu Jun 05, 2014 8:40 am

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

User avatar
odklizec
Ranorex Guru
Ranorex Guru
Posts: 7470
Joined: Mon Aug 13, 2012 9:54 am
Location: Zilina, Slovakia

Re: Import data to excel from the given folder

Post by odklizec » Thu Jun 05, 2014 10:28 am

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
Pavel Kudrys
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