InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Solve : Need to merge .xls files into one file? |
| Answer» <html><body><p>Have <a href="https://interviewquestions.tuteehub.com/tag/multiple-1105557" style="font-weight:bold;" target="_blank" title="Click to know more about MULTIPLE">MULTIPLE</a> .xls files - need to merge into <a href="https://interviewquestions.tuteehub.com/tag/one-241053" style="font-weight:bold;" target="_blank" title="Click to know more about ONE">ONE</a> file for upload for processing.<br/>Would like to add <a href="https://interviewquestions.tuteehub.com/tag/code-25512" style="font-weight:bold;" target="_blank" title="Click to know more about CODE">CODE</a> to .bat file if possible.<br/><br/>Thanks Quote from: lswain on March 12, 2010, 09:55:05 AM</p><blockquote>Have multiple .xls files - need to merge into one file for upload for processing.<br/>Would like to add code to .bat file if possible.<br/></blockquote> <br/>The <a href="https://interviewquestions.tuteehub.com/tag/following-463335" style="font-weight:bold;" target="_blank" title="Click to know more about FOLLOWING">FOLLOWING</a> example is for .txt files:<br/><br/><br/> Code: <a>[Select]</a>echo off<br/><br/>dir /b a*.txt > all_a.txt<br/>echo <a href="https://interviewquestions.tuteehub.com/tag/hello-484176" style="font-weight:bold;" target="_blank" title="Click to know more about HELLO">HELLO</a> merge > merge.txt<br/><br/>for /f "delims=" %%i in (all_a.txt) do (<br/>echo %%i<br/>type "%%i" >> merge.txt<br/>)<br/>type merge.txt<br/> Quote from: greg on March 12, 2010, 06:53:37 PM<blockquote>The following example is for .txt files:<br/></blockquote> have you tried doing that way for .xls files? Quote from: ghostdog74 on March 12, 2010, 07:05:22 PM<blockquote>have you tried doing that way for .xls files?<br/></blockquote> <br/>I don't have any .xls files on my machine. <br/><br/>Will the the Ghostdog demostrate how to merge the .xlm files?<br/><br/>Thanks for you help Ghostdog.<br/><br/><a href="http://software.informer.com/getfree-view-xls-data-in-notepad/">http://software.informer.com/getfree-view-xls-data-in-notepad/</a><br/><br/><a href="http://www.monkeyjob.com/FileMonk/FAQ/Join-Merge-XLS-Files-Excel.htm">http://www.monkeyjob.com/FileMonk/FAQ/Join-Merge-XLS-Files-Excel.htm</a><br/> Quote from: greg on March 12, 2010, 11:06:20 PM<blockquote>I don't have any .xls files on my machine. <br/><br/>Will the the Ghostdog demostrate how to merge the .xlm files?<br/><br/>Thanks for you help Ghostdog.<br/><br/><a href="http://software.informer.com/getfree-view-xls-data-in-notepad/">http://software.informer.com/getfree-view-xls-data-in-notepad/</a><br/><br/></blockquote> <br/>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<blockquote>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. <br/></blockquote> <br/>Please, give us an example.</body></html> | |