Multiple CSV to XLSX with multiple tab

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Export Oracle multiple tables to multiple csv files using UNIX shell scripting

Hello All, just wanted to export multiple tables from oracle sql using unix shell script to csv file and the below code is exporting only the first table. Can you please suggest why? or any better idea? export FILE="/abc/autom/file/geo_JOB.csv" Export= `sqlplus -s dev01/password@dEV3...

2. Shell Programming and Scripting

Write data into existing '.xlsx' file that has multiple sheets

Hello, I have a .xlsx file with 11 worksheets and I need to insert the contents of a text file (tab delim, roughly 30 columns with 1000 rows) from Row 3 onwards on the 2nd sheet. I have my code which can insert values into existing sheet but I am unable to write/import the contents of a text...

3. Shell Programming and Scripting

Write data into existing '.xlsx' file that has multiple sheets

4. Shell Programming and Scripting

Merge multiple tab delimited files with index checking

Hello, I have 40 data files where the first three columns are the same (in theory) and the 4th column is different. Here is an example of three files, file 2: A_f0_r179_pred.txt Id Group Name E0 1 V N(,)'1 0.2904 2 V N(,)'2 0.3180 3 V N(,)'3 0.3277 4 V N(,)'4 0.3675 5 V N(,)'5 0.3456 ...

5. Shell Programming and Scripting

Merging Multiple XLS into Different tabs in xls/ xlsx

HI, I have multiple files per dept in folder for eg : In a folder File1_Dept100.xls File2_Dept100.xls File3_Dept100.xls File1_Dept200.xls File2_Dept200.xls File3_Dept200.xls Output should be : Dept100.xls which has File1, File2, File3 in different tabs Dept200.xls which has...

6. UNIX for Advanced & Expert Users

Wanted to replace string in an .xlsx file in multiple ZIP Files

Hi , I am having a ZIP file containing an .xlsx file . Now i wanted to replace "GJ" to blank in the .xlsx file . I tried using the below code but not working , Please guide : #!/bin/bash log="/home/srikant/scripts/replacescriptFHO.log" date > $log echo "" >> $log echo initiating for FHO...

7. Shell Programming and Scripting

Insert a header record (tab delimited) in multiple files

Hi Forum. I'm struggling to find a solution for the following issue. I have multiple files a1.txt, a2.txt, a3.txt, etc. and I would like to insert a tab-delimited header record at the beginning of each of the files. This is my code so far but it's not working as expected. for i in...

8. UNIX for Dummies Questions & Answers

Columnate multiple files in one .tab file

Hi all ! Just a rookie question (not for me apparently !) I have file1.tab: 1 2 3 4 5 and file2.tab: a b c d e and I would like to obtain file3.tab: file1 file2

9. Shell Programming and Scripting

CSV to SQL insert: Awk for strings with multiple lines in csv

Hi Fellows, I have been struggling to fix an issue in csv records to compose sql statements and have been really losing sleep over it. Here is the problem: I have csv files in the following pipe-delimited format: Column1|Column2|Column3|Column4|NEWLINE Address Type|some descriptive...

10. Shell Programming and Scripting

Multiple commands TAB delimited

Hey guys... Running Solaris 5.6, trying to write an easy /sbin/sh script. I want to run several commands, then have the results appear on one line. Additionally, I want the results to be separated by <TAB>. Let's say that my script calls three commands (date, pwd, and hostname), I would want...

LEARN ABOUT DEBIAN

amc-export

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

NAME

       AMC-export - exports marks for AMC multiple choice exams.

SYNOPSIS

       auto-multiple-choice export --data project-data-dir --module module --fich-noms students-list.csv [--noms-encodage list-encoding]
			    --o output-file

DESCRIPTION

       The AMC-export.pl command exports marks from an Auto Multiple Choice exam.

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

       --module module
	   selects a module for export. See below for the modules included in the AMC standard distribution.

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

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

       --o output-file
	   gives the output file name.

       --option-out options
	   gives an option for selected module, in the form key=value (see below for possible options for each module). To specify multiple
	   options, use --option several times.

       --sort sort-type
	   sort the students names, depending on sort-type. If sort-type is l, use line number from students list file to sort. If sort-type is m,
	   use mark (and name if marks are equal) to sort. If sort-type is i, use student number to sort. If sort-type is n, use name to sort (or
	   line from students list if equal).

       --useall all
	   if all is 0 or empty, only students with a scaned answer sheet appears in the output. If all is 1, all students in the students list
	   appears in the output.

MODULES

   OpenDocument
       With "--module ods", an OpenDocument (for use by OpenOffice or LibreOffice for example) is produced. The following options are recognized:

       nom
	   gives a name for the exam, to be written on the beginning of the sheet.

       code
	   gives an short name for the exam, to be used as a tab name.

       columns
	   sets the list of columns that are to be added to each student. Default value is student.key,student.name.

       stats
	   with a true value, a table will be added with statistics for all questions.

       statsindic
	   with a true value, a table will be added with statistics for all indicative questions.

   CSV
       With "--module CSV", a CSV file is produced. The following options are recognized:

       columns
	   sets the list of columns that are to be added to each student. Default value is student.copy,student.key,student.name.

       decimal
	   sets the decimal point (default is a dot).

       encodage
	   sets the encoding to use for output (default is utf-8).

       separateur
	   sets the character used between colums (default is a comma).

       entoure
	   sets the character used to enclose strings (default is a double quote).

       ticked
	   if not empty, additional columns (with "CHECKED:" prefix) are included to give all the checked boxes on all the sheets. This can be
	   used by an external program to retrieve all the checked boxes when marks are not sufficient. Use value 01 to get 0;0;1;1;0 if boxes 3
	   and 4 are checked, and value AB to get CD if boxes 3 and 4 are checked.

   List
       With "--module List", a PDF file is produced with a list of marks for all students. The following options are recognized:

       pagesize
	   The page size. Default value is a4.

       nom
	   gives the name of the exam, to be printed at the top of the page.

       ncols
	   The number of columns. Default value is 2.

       decimal
	   sets the decimal point (default is a dot).

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-EXPORT(1)

Shell Programming and Scripting