03-15-2013
No, excel takes in csv s one sheet. However, there are PERL modules that can insert text into many sheets of an xls or xlsx.
Last edited by DGPickett; 03-15-2013 at 05:37 PM..
This User Gave Thanks to DGPickett For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi,
I have some 50 C files in which for indentation of code some devlopers used tabs, but we dont want any tab used for indentation.
I have following 2 need.
1) find tabs from all 50 files (which are in one directory )
2) replace them with 4 spaces.
Thanks
Rishi (6 Replies)
Discussion started by: rishir
6 Replies
2. Shell Programming and Scripting
Hi all,
Am new to scripting. So i just need your ideas to help me out. Here goes my requirement.
I have two csv files
1.csv 2.csv
abc,1.24 abc,1
def,2.13 def,1
I need to compare the first column of 1.csv with 2.csv and if matches then need to compare... (2 Replies)
Discussion started by: chinnahyd
2 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I was wondering if anybody could help me with this. I have two .csv file that I need to put it in an excel file in two different tabs using Shell Script.
Thanks in advance.
JP (7 Replies)
Discussion started by: JPalt
7 Replies
4. Shell Programming and Scripting
Hi All
I need to put 5 different files from Unix box in 5 different tabs in a single excel. For this, I need to code only using Unix.
Kindly help me on this.
---------- Post updated at 07:23 AM ---------- Previous update was at 06:24 AM ----------
Hi All
I need to put 5 different... (2 Replies)
Discussion started by: misssrinivasan
2 Replies
5. Shell Programming and Scripting
Request if some one could provide me shell script that converts the below "input file" to "CSV format file" given
Name Domain Contact Phone Email Location
----------------------- ------------------------------------------------ ------- ----- ---------------------------------... (7 Replies)
Discussion started by: sreenath1037
7 Replies
6. Shell Programming and Scripting
hello
I have browsed for the similar requirement i found this
https://www.unix.com/shell-programming-scripting/40163-xls-csv-conversion.html
but my problem is i have multiple tabs in xls file having same metadata
I want to convert it into single csv file
any ways to do it pls... (5 Replies)
Discussion started by: joshiamit
5 Replies
7. Shell Programming and Scripting
Hi list,
This is probably something really simple, but I am not particularly familiar with Python so I thought I would ask as I know that python has an excel module.
I have an excel document with multiple tabs of data and graphs.
One of the tabs is just data which I require to have dumped to... (8 Replies)
Discussion started by: landossa
8 Replies
8. Shell Programming and Scripting
(say) I have 2 csv files - file1.csv & file2.csv as mentioned below:
file1.csv
ID,version,cost
1000,1,30
2000,2,40
3000,3,50
4000,4,60
file2.csv
ID,version,cost
1000,1,30
2000,2,45
3000,4,55
6000,5,70
... (1 Reply)
Discussion started by: Naresh101
1 Replies
9. Shell Programming and Scripting
(say) I have 2 csv files - file1.csv & file2.csv as mentioned below:
file1.csv
ID,version,cost
1000,1,30
2000,2,40
3000,3,50
4000,4,60
file2.csv
ID,version,cost
1000,1,30
2000,2,45
3000,4,55
6000,5,70
The... (7 Replies)
Discussion started by: Naresh101
7 Replies
10. Shell Programming and Scripting
Hi,
I have a file of csv data, which looks like this:
file1:
1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628
2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Discussion started by: djoseph
10 Replies
LEARN ABOUT DEBIAN
glabels-3
glabels(1) General Commands Manual glabels(1)
NAME
glabels - Label and business card creation program for GNOME
SYNOPSIS
glabels-3 [OPTIONS] [label-filename...]
glabels-3-batch [OPTIONS] [label-filename...]
DESCRIPTION
glabels-3 is a lightweight program for creating labels and business cards for the GNOME desktop environment. It is designed to work with
various laser/ink-jet peel-off label and business card sheets that you'll find at most office supply stores. glabels-3 is pre-configured
with templates for many of these products. It also provides an interactive template designer for creating new templates according to user
specifications.
For full documentation see the gLabels online help.
glabels-3-batch is a command line utility to print labels previously prepared with glabels-3.
OPTIONS
-?, --help
Display a summary of available command-line options.
--usage
Display a short usage summary.
-v, --version
Print program version information.
Options specific to glabels-batch
-o filename, --output=filename
Set output filename to filename. (default="output.ps")
-i filename, --input=filename
Set name of file with data to be merged to filename. Typically this is a .csv file containing values to be printed on the labels.
-s n, --sheets=n
Set number of sheets to n. (default=1)
-c n, --copies=n
Set number of copies to n. (default=1)
-f n, --first=n
Set label on first sheet to start printing from to n. (default=1)
-l, --outline
Print outlines around labels. This is useful for testing printer alignment or printing proof sheets.
-C, --cropmarks
Print crop marks. Helpful for cutting up sheets.
-r, --reverse
Print mirror image of labels. This is useful for clear labels intended to be seen from the back through glass.
FILES
The $HOME/.glabels directory contains all user-defined templates.
SEE ALSO
The gLabels homepage at <http://glabels.org/>.
AUTHOR
Jim Evins <evins@snaught.com>
Jun 28, 2004 glabels(1)