[R] reading in from xlsx files

Jim Lemon drjimlemon at gmail.com
Wed Mar 25 04:11:01 CET 2015

Hi Bob,
Most likely you didn't save the resulting Excel file before sourcing the R
code. I would close Excel (which given the time elapsed since your message
you probably have done) and open the XSLX file again. If the changes are
there in Excel, they should show up when you run the R code (using the xlsx
package, we assume?)

Although Sarah's answer may be more sensible.


On Wed, Mar 25, 2015 at 5:00 AM, John McKown <john.archie.mckown at gmail.com>

> On Tue, Mar 24, 2015 at 7:40 AM, Robert Lyons <RLyons at m2s.com> wrote:
> > I'm sorry if this is well below the level of this forum.
> > Using R Console v3.1.3 32-bit
> > Both of our R Programming sources left the company and I'm in need of
> some very basic help.
> > The code is reading in column and row information from two xlsx files.
> > I made what I thought were some basic changes to the contents of those
> files, one was a correction to a typo for a row, the other was flipping two
> columns that were in the wrong order.
> > When I Source the R Code neither change shows up in the output.
> Well, first of all, nobody can help you with code unless you actually
> post the code in question. Hard to fix the car while you're driving
> it. [grin]
> Second, if you do post some code, you __REALLY__ need to disable
> posting in HTML. HTML messages normally come across on this forum as
> junk and most won't even try to read them.
> I may be off base on the following and likely be corrected if I am.
> But, unless the "fix" is simple, which from your post seems likely,
> you might be better off hiring a contractor who is an R programmer.
> Especially, as it appears in the case, that this is a for-profit
> company. TANSTAAFL, although many will help if they are curious and
> have time.
> >
> > Thank you for your time.
> >
> > Cordially,
> > Bob Lyons
> >
> --
> If you sent twitter messages while exploring, are you on a textpedition?
> He's about as useful as a wax frying pan.
> 10 to the 12th power microphones = 1 Megaphone
> Maranatha! <><
> John McKown
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.

	[[alternative HTML version deleted]]

More information about the R-help mailing list