Unix/Linux Go Back    


Windows & DOS: Issues & Discussions All Windows and DOS questions should go here as well. Discuss UNIX to Windows (Desktop or Server) here!

How to split the excel file into 3 files randaonly and zip them?

Windows & DOS: Issues & Discussions


Closed    
 
Thread Tools Search this Thread Display Modes
    #1  
Old Unix and Linux 11-30-2015
Maddy123 Maddy123 is offline
Registered User
 
Join Date: May 2011
Last Activity: 21 April 2017, 7:40 PM EDT
Posts: 125
Thanks: 32
Thanked 0 Times in 0 Posts
How to split the excel file into 3 files randaonly and zip them?

Hi ,

I have one excel file in zipped format which contains data with size 157 MB. It's original size is 2.6 GB so to send to user I zipped the file.

Now user is saying unable to open the file at once because of huge size and want to split the excel file into 3 files randaonly and zip them.

Could you please guide me on how to do this?

OS -- Windows 7

Regards,
Maddy
Sponsored Links
    #2  
Old Unix and Linux 12-01-2015
joeyg's Unix or Linux Image
joeyg joeyg is offline Forum Staff  
modérateur
 
Join Date: Dec 2007
Last Activity: 18 April 2017, 1:27 PM EDT
Location: Within two miles of a Dunkin donuts.
Posts: 2,436
Thanks: 116
Thanked 190 Times in 171 Posts
More of an Excel question...

But, why is it so big? That answer will help you determine if the file can be easily broken up.
If it is big because there are so many lines of data, how about
save to a .csv file
then use the unix split command to break into several smaller files (each containing x number of rows)

Then you email file in ten chunks (or however many), and the user appends file 2 to end of file 1, then appends file 3, etc...
Sponsored Links
Closed

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Perl script to Merge contents of 2 different excel files in a single excel file Anamika08 Shell Programming and Scripting 1 10-17-2013 04:22 PM
Zip Multiple files to One .zip file in AIX system RAMA PULI Shell Programming and Scripting 9 04-29-2013 12:11 PM
Zip an excel file and email using script. Nithin UNIX for Advanced & Expert Users 14 02-21-2010 06:16 AM
PERL: Split Excel Workbook to Indiv Excel files sandeep78 Shell Programming and Scripting 2 09-25-2008 08:21 AM
unzip .zip file and list the files included in the .zip archive oracledev UNIX for Dummies Questions & Answers 5 04-08-2008 04:49 PM



All times are GMT -4. The time now is 04:53 PM.