Please help Question about Excel Files and Unix

arnab1978 · #1 (**permalink**) 04-01-2009

Hello

I have an excel file , it has 4 tabs , each having specific details
for example it has a customer tab , it has a payments tab and it has an address tab

Question is

How do I seperate each of these tabs and load them into 3 different excel files Using Unix

That is the customer tab has to be converted into an excel called customer.xls , the payments tab has to be converted to an excel called payments.xls and the address tab into address.xls

I will apppreciate any help regarding this

Thank You

TonyFullerMalv · #2 (**permalink**) 04-01-2009

Copy the excel file to 4 different filenames, delete all bar one tab from each, leaving a different tab remaining on each, done.

zTodd · #3 (**permalink**) 04-02-2009

If you need it automated, maybe using a VBA script in Excel would be easier?

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
combine 3 excel files using shell.	radhika	Shell Programming and Scripting	11	05-06-2009 06:18 AM
Multiple excel files processing on unix	ucode_2482	UNIX for Dummies Questions & Answers	3	02-26-2009 04:02 PM
Add multiple .csv files as sheets to an excel file in unix.	libin4u2000	Shell Programming and Scripting	2	01-20-2009 11:20 PM
PERL: Split Excel Workbook to Indiv Excel files	sandeep78	Shell Programming and Scripting	2	09-25-2008 08:21 AM
Exporting files from unix to Excel sheet	bishweshwar	UNIX for Advanced & Expert Users	3	03-21-2007 04:41 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by