Displaying 3 results from an estimated 3 matches for "xlcsv".
2009 Jan 13
1
ROR - Excel Export Example
...9;'] =
contact.middle_name.to_s
excel.Range("d" + line_count.to_s.strip )[''Value''] =
(contact.first_name.to_s + " " + contact.middle_name.to_s + " " +
contact.last_name.to_s).strip
end
# Here are some common file formats:
xlCSV=6
xlCSVMac=22
xlCSVMSDOS=24
xlCSVWindows=23
xlCurrentPlatformText=-4158
xlExcel9795=43
xlTextMSDOS=21
xlTextPrinter=36
xlTextWindows=20
workbook.SaveAs ''contacts_export.csv'', xlCSV
excel.Quit
excel = nil #release the excel object...
2009 Jun 15
2
[OT] VBA to save excel as csv
Hi all,
This is a little off-topic, but it is on the general topic of getting
data in R. I'm looking for a excel macro / vba script that will
export all spreadsheets in a directory (with one file per tab) into
csv. Does anyone have anything like this?
Thanks,
Hadley
--
http://had.co.nz/
2005 Jun 16
3
Excel files first row not being read
hi,
i am using the RODBC package to read excel files using
odbcConnectExcel and susequently sqlFetch to read the contents of the
file.
the file that i use is just a matrix of numbers thats all. no headers
and column names. what happens is that the sqlFetch is not reading my
first row of numbers.
i have tried different combinations of colnames and rownames logical
values but that first row is not