Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re^2: xlsmerge - Merge worksheets from different Excel files into one Workbook

by Corion (Pope)
on Jun 15, 2010 at 08:47 UTC ( #844819=note: print w/replies, xml ) Need Help??


in reply to Re: xlsmerge - Merge worksheets from different Excel files into one Workbook
in thread xlsmerge - Merge worksheets from different Excel files into one Workbook

Maybe you can suggest to me how I would write the description better:

This script is a raw utility that I use to merge "information" and "data" sheets from different Excel workbooks. The basic syntax is as follows:
xlsmerge -s -o results-%Y%m%d.xls info.xls:Information query_results.x +ls:Sheet1

Maybe, if your operating system does not execute Perl programs directly, you want to use the following line:

perl -w xlsmerge -s -o results-%Y%m%d.xls info.xls:Information query_r +esults.xls:Sheet1

You don't tell us what you've tried and what problems you encountered, so it's hard to advise you further.

Replies are listed 'Best First'.
Re^3: xlsmerge - Merge worksheets from different Excel files into one Workbook
by deshdaaz (Novice) on Nov 07, 2016 at 22:07 UTC
    Old thread, but wanted to share with other readers. Running command exactly as suggested created an empty results file. There is likely a bug in the script on line 24 and believe it's expecting a different format compared to what's suggested in the example by author.

    Solution is to NOT specify the sheet name after the semicolon.

    Simply run it as
    perl xlsmerge.pl -s -o results-%Y%m%d.xls File1.xls File2.xls

    I have a different question though. Is it possible to simply change the extension to csv in the source code and run this on csv files?

      No. This program only reads XLS files in the XLS file format.

      If you want to depend less on the format of your input files, I recommend using Spreadsheet::Read.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://844819]
help
Chatterbox?
[erix]: ha, the tick and, as it happens, also the curator (now a professor of Paleont.)
[1nickt]: s/there/their/, ugh sorry.
[Your Mother]: Heh. The only one I ever had on me, I caught on my shin, headed north.
erix looks nervously I got away cleanly from my run , it seems :)
1nickt doesn;t remember there being ticks in the old country ...
erix too fast for ticks!
[erix]: 'the old country' is where?
[erix]: that means britain for americans, is that right?
[perldigious]: We need to get more high tech about pest defense to prevent tick and mosquito problems. :-)
[erix]: perldigious or develop thicker skin

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (15)
As of 2017-05-24 13:18 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?