You can use 'list.files()' to get the list of all the Excel file names and then the XLConnect package makes it easy to read in the files and extract the data that you want from them.
On Thu, Mar 28, 2013 at 4:24 AM, Tammy Ma <metal_lical...@live.com> wrote: > Hello, > > I have created many excel files in my working dir. each excel file contain > one country's data. In the excel, I have dataframe in sheet1, where each > product and its relative information is > in each row as following: > > Product PE Retail_price_Band Country Model_Fit > A -2.5 0-50 CN 84% > B -2.1 51-100 CN 90% > ..... > > > not every product presents in each country, in other words, they may have > common products or not. > How do I create program in R to search each excel file in my working dir > in order to make the list of the such product for each > country based on my input(for example, I want to have all information > related to product B in each country) > the result what I want: > > > Product PE Retail_price_Band Country Model_Fit > B -2.4 51-100 IN 80% > B -2.1 51-100 CN 90% > > > How do I achieve this? thanks. > > Kind regards, > Lingyi > > > > > > > > > > > > > > > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > -- Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to do it. [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
