+ Post New Thread
Results 1 to 2 of 2
Scripts Thread, Exporting to excel sheets in Coding and Web Development; Hey, here is another problem that you could probably help me with. I have exported all the data to an ...
  1. #1

    Join Date
    Sep 2011
    Posts
    16
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Exporting to excel sheets

    Hey, here is another problem that you could probably help me with.
    I have exported all the data to an excel sheet, but it is in a weird format. When I write to a .xls file, the data skips columns for some reason. Here is the line:

    if (FileSize >= bytesToMB) and (FileSize < bytesToGB) then
    totalSize = FileSize / bytesToMB
    objOut.WriteLine ComputerName & " " & FileType & " " & counter _
    & " " & objFolder.Path & " " & totalSize & " MB"

    It skips columns after counter and after obj.Folder.Path. I played around with the number of spaces I have in between each parameter to see if it would change anything, but didn't work. Any suggestions?

  2. #2

    Join Date
    Sep 2011
    Posts
    16
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    SOLVED: put commas in between quotes on the objOut.WriteLine line, and output to a .csv file, which can be opened by excel.

SHARE:
+ Post New Thread

Similar Threads

  1. Adding trusted location to Excel
    By Jobos in forum Office Software
    Replies: 3
    Last Post: 4th July 2011, 10:54 PM
  2. BETT moves to ExCeL London from 2013
    By russdev in forum BETT 2014
    Replies: 11
    Last Post: 22nd June 2011, 10:07 AM
  3. [SIMS] Exporting to Fronter - missing reg groups
    By adamf in forum MIS Systems
    Replies: 3
    Last Post: 11th October 2010, 04:00 PM
  4. Exporting timetables from SIMs to Excel
    By CaterinaAnna in forum MIS Systems
    Replies: 18
    Last Post: 12th January 2010, 03:28 PM
  5. Writing to Excel from .vbs script
    By Samson in forum Windows
    Replies: 6
    Last Post: 15th October 2008, 07:34 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •