Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Add more than 65536 rows to Excel

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Add more than 65536 rows to Excel
# 1  
Old 07-14-2011
Question Add more than 65536 rows to Excel
i need to export data into a single excel file 2003 format using shell script which contains more than 65536 rows.. How this can be achieved? is it possible to move the datas to a new worksheet?
# 2  
Old 07-14-2011
I'm sure excel can't show more than 64k lines. Use a better program than Excel. Or split the file.

Code:
split Command

Purpose

       Splits a file into pieces.

Syntax

To Split a File Into Multiple Files Containing a Specified Number of Lines

       split [ -l LineCount ] [ -a SuffixLength ] [ File [ Prefix ] ]

This User Gave Thanks to purdym For This Post:
chn10db001
# 3  
Old 07-14-2011
oh thanks.. is it possible to split the files and add them to new worksheets in excel?
# 4  
Old 07-14-2011
Export from where..? MS excel can contain upto 64k lines per sheet, and if there are more than this then consecutive sheets(2,3 etc) are open in the same excel file to accommodate the remaining lines. Its true for export of data happening from Toad or other similar tools to excel.
This User Gave Thanks to michaelrozar17 For This Post:
chn10db001
# 5  
Old 07-14-2011
i need to transfer the data from a flatfile to excel.
# 6  
Old 07-15-2011
excel is capable of importing flatfiles directly.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perl script to Merge contents of 2 different excel files in a single excel file

All, I have an excel sheet Excel1.xls that has some entries. I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls These may be in different workbooks. They are totally independent made by 2 different users. I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies

2. Shell Programming and Scripting

Perl : blank lines are displayed in the output after deleting few rows from excel

I am working on an assignment to pull all the records from excel sheet programatically and use the data for further calculations. In this process, I first defined 10 records in excel sheet and executed the below code. In the first run it is OK. But after deleting last few rows in excel sheet and... (0 Replies)
Discussion started by: giridhar276
0 Replies

3. Shell Programming and Scripting

Find count of rows in excel sheet in Unix

Hi, Is there a way to find the count of number of rows of a.txt please? Where a.txt is as follows: /usr/bin/uuencode /tmp/a.csv a.csv > /tmp/a.txt #a.csv is a comma separated variable file Cheers, Girish. (7 Replies)
Discussion started by: girish1428
7 Replies

4. Shell Programming and Scripting

How to check count of rows in excel sheet in Unix

Hi, Would anyone be able to tell me how to check the number of rows in an excel sheet on unix box, please? Cheers, Girish. (2 Replies)
Discussion started by: girish1428
2 Replies

5. UNIX for Dummies Questions & Answers

Add columns to an existing excel sheet

Hi All, i have an excel sheet as below: day ----- monday tuesday wenesday thursday friday i need to append the two more columns in this existing file below: insert date should be todays date--- day insert date insert user ---- ---------- ... (3 Replies)
Discussion started by: arunmanas
3 Replies

6. Shell Programming and Scripting

script to format rows to column and export to excel

i need to write script to copy the txt file to excel. (data can be 2000+), data may not be in order ex: my name: abc age: 20 add: xyz DOB: 17-mar-2010 add1: adf add2: guioth my name: cat age: 35 DOB: 11-oct-2005 city: yeshjl add: opq DOB: 17-mar-2010 add1: atg add2: gth add3:ert ... (2 Replies)
Discussion started by: pjain
2 Replies

7. Shell Programming and Scripting

how to add if data in rows

Hi Friends, How to add if data is in different rows. Input: 1;20091102;20170930;-9.00;| 1;20091026;20170930;-2.00;| 1;20100720;20170930;-25.00;| 1;20090901;20211227;-10.00;| Output 9+2+25+10 = 46 Thx Suresh (4 Replies)
Discussion started by: suresh3566
4 Replies

8. Shell Programming and Scripting

add new rows in list of files

Hi, I Have a directory(views) and i have 100 .sql files in the same directory. I need to be add 8 rows in each file. The format 8 rows has like: grant select on file_name to User1 / grant select on file_name to User2 / grant select on file_name to User3 / grant select on file_name to... (1 Reply)
Discussion started by: koti_rama
1 Replies

9. Shell Programming and Scripting

Add multiple .csv files as sheets to an excel file in unix.

Hi, I am using Solaris 8. My script outputs 4 .csv files. Currently I am SFTPing the files and creating a new excel file with the 4 files as sheets. Can anyone suggest ways to do this in UNIX ? Thanks, David. (2 Replies)
Discussion started by: libin4u2000
2 Replies

10. Shell Programming and Scripting

PERL: Split Excel Workbook to Indiv Excel files

Hi, I am trying to find a way to read an excel work book with multiple worksheets. And write each worksheet into a new excel file using perl. My environment is Unix. For example: I have an excel workbook TEST.xls and it has Sheet1, Sheet2, Sheet3 worksheets. I would like to create... (2 Replies)
Discussion started by: sandeep78
2 Replies
Login or Register to Ask a Question