Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
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?
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (5)
As of 2017-12-17 14:50 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What programming language do you hate the most?




















    Results (464 votes). Check out past polls.

    Notices?