add in sheet in exist excel file

Discussion forum for all Windows batch related topics.

Moderator: DosItHelp

Post Reply
Message
Author
jamesfui
Posts: 50
Joined: 27 Mar 2010 23:00

add in sheet in exist excel file

#1 Post by jamesfui » 10 Apr 2010 23:58

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!! :D

ghostmachine4
Posts: 319
Joined: 12 May 2006 01:13

Re: add in sheet in exist excel file

#2 Post by ghostmachine4 » 11 Apr 2010 00:08

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.

Post Reply