hi everyone. need help in what is the bat scripts to add in
texts into sheets of an existing excel file without overwriting it?
for example,
text.txt
-----------------content------------------
jan09 report
feb10 report
...etc
-----------------content end--------------
INTO NEW SHEET OF EXISTING EXCEL FILE shown as below,
exist_excel.xls
-------------------content------------------------
jan09 report
feb10 report
...etc
Sheet | Sheet1 | Sheet2 | Sheet3
--------------------content end-------------------
PS. the contents in Sheet1, Sheet2, etc will not be overwritten!
which means their existing contents will not be empty out..
thanks in advance!!
add in sheet in exist excel file
Moderator: DosItHelp
-
- Posts: 319
- Joined: 12 May 2006 01:13
Re: add in sheet in exist excel file
you will to use vbscript , or a programming language that provides excel API/module for creating sheets. Search google for "vbscript add excel worksheet" and you can find examples on how to add worksheet.