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 ...
7th October 2011, 05:03 PM #1
- Rep Power
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?
IDG Tech News
14th October 2011, 04:15 PM #2
- Rep Power
SOLVED: put commas in between quotes on the objOut.WriteLine line, and output to a .csv file, which can be opened by excel.
By Jobos in forum Office Software
Last Post: 4th July 2011, 11:54 PM
By russdev in forum BETT 2013
Last Post: 22nd June 2011, 11:07 AM
By adamf in forum MIS Systems
Last Post: 11th October 2010, 05:00 PM
By CaterinaAnna in forum MIS Systems
Last Post: 12th January 2010, 04:28 PM
By Samson in forum Windows
Last Post: 15th October 2008, 08:34 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)