No announcement yet.

Storing the diff report in excel

  • Filter
  • Time
  • Show
Clear All
new posts

  • Storing the diff report in excel

    I have coded the script in such a way that it has to compare two folders and store the differences in an excel sheet .it is doing good.But everything gets copied to the first column of the excel.but i want it in such a way that it stores the results column wise..say for example,i want to have "name of the file","size" in the sheet.and the values should be saved in corresponding columns.

    Here is my script.

    load "C:\Users\Mohan\Desktop\mohan" "C:\Users\Mohan\Desktop\mohan2"
    expand all
    folder-report layout:side-by-side options:column-size output-to:C:\Users\Mohan\Desktop\report.xls
    Last edited by Mohan*N*; 21-Feb-2010, 02:47 AM.

  • #2
    The folder-report does not currently support output into an Excel format. Our output is either to a text file or html file (or printer). You could output to Text or HTML, and then open that file in Excel.

    How does that work for you? Let us know if you have any questions.
    Aaron P Scooter Software


    • #3
      hi Aaron,
      thanks for ur reply.
      I made use of .csv file format and it solved the problem.