Create a .sh file for an equivalent Excel VBA code

9 More Discussions You Might Find Interesting

1. Windows & DOS: Issues & Discussions

Update sh file using VBA before perl script is run

I have a VBA that creates a new directory folder and creates a new text file in that directory. I am trying to run a perl script from the VBA and have created a batch file that gets called from the VBA. That bat file uses a shell file to run a script. When the batch file is called I get the error...

2. Windows & DOS: Issues & Discussions

Excel VBA script aware of being opened interatively or from the command line

I have a Excel VBA script that automatically runs when opened, extracts one table from a Microsoft Access Database, saves it as CSV, closes it, extracts another, saves it as CSV, closes it, then terminates itself. Is is called from a short .bat file using the /e option so that Excel does not...

3. UNIX for Dummies Questions & Answers

How to Create excel file(.csv) using shell script?

Hi, i have shell script which compiles n number of test cases and execute them one by one. i want to create report in excel through script in which two columns namely "test id" and "release".second column have two subcolumns namely compiles and excutes. so i want first column should display test...

4. Shell Programming and Scripting

Create excel file using bash script

i have written one script which generates text file which gives output like. 001.config: CR1.1 COMPILE_PASSED TEST_PASSED 002.config: CR1.1 COMPILE_FAILED TEST_FAILED . . .so on this text file will get filled one by one as its for loop for n number. i...

5. UNIX for Dummies Questions & Answers

Create the equivalent of the command WC

hi all, i'm trying to do this exercise, i want to create a script that can substitute WC command in unix, can someone help me?

6. 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

7. Shell Programming and Scripting

Create an .csv/excel file using shellscript

In my file, i have 4 Product names(For ex:Microsoft excel, Oracle,.Net,IBM websphere,..etc.,) I want this 4 Products in 4 individual .csv/excel file after running the script with those products related information.

8. UNIX for Dummies Questions & Answers

create excel file

Hi, How can I create an excel file from a txt file using shell script. Please do a help for me. Thanks, Regards, Milton

9. UNIX for Advanced & Expert Users

Hw to create root-equivalent accounts?

Hi all. After installing ssh on a server, i'd like to create a user with root privileges. My problem is that after creating a user rootssh (uid=0, gid=20, /home/rootshh), i make rootssh's ssh keys. The problem is that normally the ssh-keygen should create the keys under $HOME/.ssh/, and actually...

LEARN ABOUT BSD

mkmanifest

MKMANIFEST(1)						      General Commands Manual						     MKMANIFEST(1)

NAME

       mkmanifest - create a shell script to restore Unix filenames

SYNOPSIS

       mkmanifest [ files ]

DESCRIPTION

       Mkmanifest creates a shell script that will aid in the restoration of Unix filenames that got clobbered by the MSDOS filename restrictions.
       MSDOS filenames are restricted to 8 character names, 3 character extensions, upper case only, no device names, and no illegal characters.

       The mkmanifest program is compatible with the methods used in pcomm, arc, and mtools to change perfectly good Unix  filenames  to  fit  the
       MSDOS restrictions.

EXAMPLE

       I want to copy the following Unix files to a MSDOS diskette (using the mcopy command).

	    very_long_name
	    2.many.dots
	    illegal:
	    good.c
	    prn.dev
	    Capital

       Mcopy will convert the names to:

	    very_lon
	    2xmany.dot
	    illegalx
	    good.c
	    xprn.dev
	    capital

       The command:

       mkmanifest very_long_name 2.many.dots illegal: good.c prn.dev Capital > manifest

       would produce the following:

	    mv very_lon very_long_name
	    mv 2xmany.dot 2.many.dots
	    mv illegalx illegal:
	    mv xprn.dev prn.dev
	    mv capital Capital

       Notice that "good.c" did not require any conversion, so it did not appear in the output.

       Suppose	I've  copied  these files from the diskette to another Unix system, and I now want the files back to their original names.  If the
       file "manifest" (the output captured above) was sent along with those files, it could be used to convert the filenames.

SEE ALSO

       arc(1), pcomm(1), mtools(1)

								       local							     MKMANIFEST(1)

Shell Programming and Scripting