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

Thread Tools Search this Thread Display Modes
Old Unix and Linux 11-30-2015   -   Original Discussion by Maddy123
Maddy123's Unix or Linux Image
Maddy123 Maddy123 is offline
Registered User
Join Date: May 2011
Last Activity: 3 August 2017, 8:24 PM EDT
Posts: 133
Thanks: 32
Thanked 1 Time in 1 Post
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

Sponsored Links
Old Unix and Linux 12-01-2015   -   Original Discussion by Maddy123
joeyg's Unix or Linux Image
joeyg joeyg is offline Forum Staff  
Join Date: Dec 2007
Last Activity: 17 January 2018, 9:31 AM EST
Location: Within two miles of a Dunkin donuts.
Posts: 2,474
Thanks: 137
Thanked 204 Times in 179 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

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 05:22 PM
Zip Multiple files to One .zip file in AIX system RAMA PULI Shell Programming and Scripting 9 04-29-2013 01:11 PM
Zip an excel file and email using script. Nithin UNIX for Advanced & Expert Users 14 02-21-2010 07:16 AM
PERL: Split Excel Workbook to Indiv Excel files sandeep78 Shell Programming and Scripting 2 09-25-2008 09:21 AM
unzip .zip file and list the files included in the .zip archive oracledev UNIX for Dummies Questions & Answers 5 04-08-2008 05:49 PM

All times are GMT -4. The time now is 10:04 AM.