Saved Bookmarks
| 1. |
Solve : Need to merge .xls files into one file? |
|
Answer» Have MULTIPLE .xls files - need to merge into ONE file for upload for processing. Have multiple .xls files - need to merge into one file for upload for processing. The FOLLOWING example is for .txt files: Code: [Select]echo off dir /b a*.txt > all_a.txt echo HELLO merge > merge.txt for /f "delims=" %%i in (all_a.txt) do ( echo %%i type "%%i" >> merge.txt ) type merge.txt Quote from: greg on March 12, 2010, 06:53:37 PM The following example is for .txt files:have you tried doing that way for .xls files? Quote from: ghostdog74 on March 12, 2010, 07:05:22 PM have you tried doing that way for .xls files? I don't have any .xls files on my machine. Will the the Ghostdog demostrate how to merge the .xlm files? Thanks for you help Ghostdog. http://software.informer.com/getfree-view-xls-data-in-notepad/ http://www.monkeyjob.com/FileMonk/FAQ/Join-Merge-XLS-Files-Excel.htm Quote from: greg on March 12, 2010, 11:06:20 PM I don't have any .xls files on my machine. xls/xlm(whatever it is) are binary files. you can't just concat the files like that. the best/correct way is to use the application( in this case, excel) to join them together, either by hand, or by use of vbscripting. Quote from: ghostdog74 on March 12, 2010, 11:20:58 PM xls/xlm(whatever it is) are binary files. you can't just concat the files like that. the best/correct way is to use the application( in this case, excel) to join them together, either by hand, or by use of vbscripting. Please, give us an example. |
|