Add multiple .csv files as sheets to an excel file in unix.

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Tabbed multiple csv files into one single excel file with using shell script not perl

Hi Experts, I am querying backup status results for multiple databases and getting each and every database result in one csv file. so i need to combine all csv files in one excel file with separate tabs. I am not familiar with perl script so i am using shell script. Could anyone please...

2. UNIX for Dummies Questions & Answers

How to extract UNIX output to excel CSV file?

Hi guys - I have a file and output like this below: File: myfile.dat File has content like this: ABCD, 34, 456, 2324 I would like excel to have this: Name (ABCD) Quantity (34), Type (456), Status (2324) (Name, Quantity, Type and Status are columns) I would like to export...

3. Shell Programming and Scripting

Write two csv files into one excel with multiple sheets

I have requirement to write two CSV files to one single excel with multiple sheets. Data present in the two files should sit in excel as different sheets. How can we achieve this using shell script? 1.csv 2. csv 1,2,3,4 5,6,7,8 XXXXX YYYYY Res.excel 1.csv data...

4. Shell Programming and Scripting

Merge *.csv files, each in separate sheets

Does anyone know how to Merge *.csv files, each in seperate sheets?

5. Shell Programming and Scripting

create separate files from one excel file with multiple sheets

Hi, I have one requirement, create separate files (".csv") from one excel file(xlsx) with multiple sheets. These ".csv" files are my source files. So anybody please suggest me the process. Thanks in Advance. Regards, Harris

6. UNIX for Advanced & Expert Users

Problem in converting password protected excel file to csv file in unix

I need to convert a password protected excel file which will be in UNIX server to a comma separated file. For this I need to open the excel file in UNIX box but the UNIX box doesn't prompt for password instead it is opened in an encrypted manner. I could manually ftp the excel file to local...

7. UNIX for Dummies Questions & Answers

Multiple excel files processing on unix

Hi all, I am faced with a rather unusual problem regarding interaction between NT and UNIX. I am using an ETL (Extract-Transform-Load) tool on unix that has the capability to read .xls files. So, when I FTP an excel (.xls) file from a windows server to unix and attempt to read it with this...

8. Shell Programming and Scripting

How to combine different Excel sheets into a single work book using UNIX

Hi All, I have 4 excel files and i want to combine these 4 files into a single workbook .. my constraints is each work sheet should go to a seperate sheet or tab with sheet name .. my final workbook should have 4 tabs(sheets) each for one. Thanks in Advance..

9. Shell Programming and Scripting

How to format excel sheets in UNIX??

Hi, I have generated an excel sheet using a shell script. i have converted the output text file to an excel and got the desired output. However, in a particular column in the excel the values of the numbers start with 0. e.g. 078393343, 00342442, etc. But, in the resulting excel I get as...

10. Shell Programming and Scripting

Multiple excel work sheets through UNIX

Hi, There is this requirement to create multiple work sheets in an MS Excel file through UNIX. We normally can create one work sheet in unix by either tab or comma delimiting and appending .xls or .csv to the file name, but can we create multiple work sheets. Regards, Puspendu

LEARN ABOUT DEBIAN

amc-regroupe

AMC-REGROUPE(1) 					       Auto Multiple Choice						   AMC-REGROUPE(1)

NAME

       AMC-regroupe - merge JPEG annotated AMC multiple choice answer sheets to get a PDF file per student.

SYNOPSIS

       auto-multiple-choice regroupe --projet project-dir --sujet subject.pdf --modele file-name-model --fich-noms students-list.csv
			    [--noms-encodage encoding] [--compose]

DESCRIPTION

       The command AMC-regroupe.pl merges annotated AMC multiple choice answer sheets (there is one per page) to get a single PDF file per
       student.

       --data data-dir
	   gives the directory where data files are (see for example AMC-meptex(1)).

       --projet project-dir
	   Gives the project directory.

       --sujet subject.pdf
	   gives the subject file (as prepared by AMC-prepare(1)). This helps in getting the page size for the subject to make annotated PDF fit
	   this size.

       --fich-noms students-list.csv
	   sets the students list file name.

       --noms-encodage encoding
	   selects an encoding for file students-list.csv (default is utf-8).

       --modele file-name-model
	   sets a file name model for annotated PDFs. In this model, some sequences will be substituted:

	   (N)
	       is replaced by the student's name.

	   (ID)
	       is replaced by the student number.

	   (COL)
	       is replaced by the value of column COL in the students list for the curent student.

	   The default value is '(N)-(ID).pdf'.

       --compose
	   When using this option, pages for which there is no scan will be replaced by the corresponding page from the corrected answer sheet.
	   This option is for example useful when using the separate answer sheet layout: in this case, the annotated answer sheet will not be
	   readable without the pages with the questions.

	   When using the --compose option, one must also use the --tex-src (and optionnaly --with, --filter and --filtered-source) option.

       --tex-src mcq-source-file
	   gives the source file for the subject.

       --with latex-engine
	   gives the LaTeX engine (command) to be used to process the (optionaly filtered) source file.  latex-engine can be pdflatex or xelatex
	   for exemple.

       --filter filter
	   sets the filter name to transform the MCQ source file into a LaTeX file (see AMC-prepare(1)).

       --filtered-source mcq-latex-file
	   gives the LaTeX file to make from the source file using specified filter (see AMC-prepare(1)).

       --debug file.log
	   gives a file to fill with debugging information.

AUTHORS

       Alexis Bienvenue <paamc@passoire.fr>
	   Main author

       Jean Berard
	   Translation from French

       Georges Khaznadar
	   Translation from French

COPYRIGHT

       Copyright (C) 2008-2012 Alexis Bienvenue

       This document can be used according to the terms of the GNU General Public License, version 2 or later.

Auto Multiple Choice 1.1.1					    06/19/2012							   AMC-REGROUPE(1)

Shell Programming and Scripting