1.

Solve : How to send details of a file into excel sheet.?

Answer» <html><body><p>Hi All,  <br/><br/>I have a file <a href="https://interviewquestions.tuteehub.com/tag/called-907796" style="font-weight:bold;" target="_blank" title="Click to know more about CALLED">CALLED</a> Myfile.mdl. This file is located in some  <a href="https://interviewquestions.tuteehub.com/tag/like-537196" style="font-weight:bold;" target="_blank" title="Click to know more about LIKE">LIKE</a> D:\Folder_Name1\Folder_Name2\Myfile.mdl.<br/><br/>When we see the the details of this file We find out <a href="https://interviewquestions.tuteehub.com/tag/nmae-2197082" style="font-weight:bold;" target="_blank" title="Click to know more about NMAE">NMAE</a>, Size, Type, Date Modified etc...<br/><br/>I want to extract only that date into one Excel file called Myexcel.xls.<br/><br/>I have tried with some code but its giving all the details of all directories and <a href="https://interviewquestions.tuteehub.com/tag/sub-250109" style="font-weight:bold;" target="_blank" title="Click to know more about SUB">SUB</a> directories, but I need only that file date in the excel sheet which is located in main directory.<br/><br/>Your help will be appriciated more.<br/><br/><br/>Thanks in advance<br/>SarayuThis question was asked and answered yesterday. Perhaps you missed it. Click<br/><br/> Quote</p><blockquote>I have tried with some code but its giving all the details of all directories and sub directories, but I need only that file date in the excel sheet which is located in main directory.<br/></blockquote> <br/>If you want to help your own cause, you might consider posting your code. It wouldn't be very much help if I told you I wrote some code for your solution and then didn't post it.<br/><br/>As was previously mentioned you cannot update an Excel <a href="https://interviewquestions.tuteehub.com/tag/spreadsheet-1222930" style="font-weight:bold;" target="_blank" title="Click to know more about SPREADSHEET">SPREADSHEET</a> with batch code. You need to use a Windows script language that supports Excel as an object or supports an access method for the file.<br/><br/> Well, unless it's a CSV file...</body></html>


Discussion

No Comment Found

Related InterviewSolutions