s-news
[Top] [All Lists]

importData skips blank Excel cells

To: s-news@lists.biostat.wustl.edu
Subject: importData skips blank Excel cells
From: Daniel Murphy <chiefmurphy@gmail.com>
Date: Mon, 9 Mar 2009 09:49:44 -0700
Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=5JgM8+7d7feAdS2zvPvaBo6vfmJekzJoqoxdWCnBlhk=; b=ajHlG5fkICdc0kq56us5Y+ZpwSmICY+vHDFfBpgWxeCblNUuj24CA9cOsaCIQdz2ok rrRJpRiJtyzYu5Rrs2P9rs1Ck8Rj1HaWr24BHAZlqe4DLVjgPRG5IGh8RByLNMS3cFLO CGToX1sTsxAh563480X/uSFHluowCq36msUJo=
Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=v+e7+jFCAbCvHm4QQzWnodCIhIVoj0ncDGTba+Hdm+N52PFDjVsbbAImrp5Hd8t/gk 9SESMQmKQ0JmP6bpP4LMoyU0W5QwGf7wKVA5zBJP7NPsBhds+gmEIdDW/ujFZ4k52jdx p2hKPgit0XQR/ogAa87+U+0bzAusna3EUBR2E=
My excel spreadsheet ("test.xls") has nothing in A1, "B1" in B1, and "C1" in C1.
The importData command
> importData("test.xls",startRow=1,endRow=1,startCol=2,endCol=3)
results in
  C3
1 C1

Why doesn't S+ start with the "B1" value in column 2 as I requested?
Thanks.
Dan
<Prev in Thread] Current Thread [Next in Thread>
  • importData skips blank Excel cells, Daniel Murphy <=