| || |
How to create a excel sheet at runtine
I want to create a excel with current date and time through script at run time and save at a particular location.
Also i want to add few columns to the excel file created.
Can any one let me know how to do this?
Re: How to create a excel sheet at runtine
Use SYS_Execute() function to call the executable file of Microsoft Excel, and use the following parameters that are defined here http://office.microsoft.com/en-us/ex...010158030.aspx (look up the correct version). You can then automate writing data to the spreadsheet.