Displaying 1 result from an estimated 1 matches for "xlcsvmsdos".
2009 Jan 13
1
ROR - Excel Export Example
...me.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
GC.start #call Garbage colle...