Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on May 9th, 2012  |  syntax: None  |  size: 0.67 KB  |  hits: 8  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. var fso = new ActiveXObject("Scripting.FileSystemObject")
  2.  
  3. var file = fso.GetFile(WScript.Arguments.Item(0))
  4. var dirname = file.ParentFolder.Path
  5. var basename = file.Name
  6. var name = basename.replace(/\.xlsx?$/i, "")
  7.  
  8. var Excel = {
  9.   xlCSV : 6
  10. }
  11.  
  12. var excel = new ActiveXObject("Excel.Application")
  13. try {
  14. //  excel.Visible = true
  15.   excel.DisplayAlerts = false
  16.  
  17.   update_links = null
  18.   readonly = true
  19.   book = excel.Workbooks.Open(file.Path, update_links, readonly)
  20.   sheets = book.Sheets
  21.  
  22.   for (var i = 1; i <= sheets.Count; i++) {
  23.     sheet = sheets.Item(i)
  24.     sheet.Select()
  25.     book.SaveAs(dirname + "\\" + name + "-" + i + ".csv", Excel.xlCSV)
  26.   }
  27. } finally {
  28.   excel.Quit()
  29. }