Login or Register to Ask a Question and Join Our Community


HP-UX

Excel in Unix

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems HP-UX Excel in Unix
# 1  
Old 01-06-2005
Excel in Unix
Hi,

How can i create an excel sheet in Unix?

Actually i need the data from the tables into the excel sheet.

Please let me know.

Regards,
Puspendu
# 2  
Old 01-06-2005
Excel is a Microsoft product - i.e. it is a Windows based format.

OpenOffice and StarOffice run on various flavours of UNIX. As far as I know, however, OpenOffice only runs on Linux", Solaris, Mac OS X (under X11), and FreeBSD.

Could you not just export your data to a text file, FTP it over to a Windows machine, and then import it into excel as delimited text?

Cheers
ZB
# 3  
Old 01-06-2005
I beleive Perl has a module that you can use to extract data from MS Excel. I've never used it before but Im sure you can find out more on Perl Network.

edited - Just did a google search for "perl excel module" and it returned numerous links. One promissing link is Here
# 4  
Old 08-17-2006
Simple Excel Spreadsheet
If you want to be simple and cheap, if you write tab delimited file and put a .xls extension on the filename, excel will read that and accept it as its own. Keeps you from doing anything fancy, like formatting and worksheets, but hey, I said simple and cheap, what did you expect?
# 5  
Old 08-17-2006
I've had a very good experience with the Spreadsheet::WriteExcel per module; documentation is at: http://search.cpan.org/dist/Spreadsh.../WriteExcel.pm

It seems like what you are trying to do is similar to what I do... connect to a database, run a query, and then export the results to an Excel file. This module works very well with the perl DBI database access interfaces.

Some of the things I can verify that Spreadsheet::WriteExcel supports:
  • Multiple tabs in a workbook
  • Formulas
  • Text attributes (font, color, etc.)
  • Easy row / column navigation

Hope this helps,

- John
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Extract UNIX data to excel

Hi, I would like to extract the data from particular date, 1. may i know which command i need to use? 2. Extract from unix command (those extracted above) to excel? Please assist. Thanks (2 Replies)
Discussion started by: Peru
2 Replies

2. Windows & DOS: Issues & Discussions

Run UNIX Script from Excel

How to run scripts from Excel and bring results back to excel? (10 Replies)
Discussion started by: santoshdrkr
10 Replies

3. Shell Programming and Scripting

Merge two cells in excel via UNIX?

Hi UNIX Gods! Is it possible to merge two cells in .csv file using unix commands? Imagine that this is my present csv file opened via excel: Gate Reports| | fatal alerts | 200 | is is possible to make it look like this using unix? Gate Reports | fatal... (1 Reply)
Discussion started by: 4dirk1
1 Replies

4. Shell Programming and Scripting

Excel sheet to be created from unix.

Hi Guys, I like to create a excel sheet with four tabs. Is it possible to create it. Acutually i want to apply formulas in fourth tab which uses the three different tabs. Is it possible to create such a script? Thanks & regards, Magesh (3 Replies)
Discussion started by: mac4rfree
3 Replies

5. UNIX for Dummies Questions & Answers

Please help Question about Excel Files and Unix

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... (2 Replies)
Discussion started by: arnab1978
2 Replies

6. Shell Programming and Scripting

Read Ms-excel file in unix

Hi, I have the Ms Excel file(test.xls) in my UNIX box. I would like to read the excel file and create files for each column. Please find an example. My excel file like this data: Num Data 1 a1 2 b2 3 c3 4 d4 5 e5 6 f6 7 h7 My output: I want create 2 files(num.log and... (3 Replies)
Discussion started by: koti_rama
3 Replies

7. Shell Programming and Scripting

How to format excel sheets in UNIX??

Hi, I have generated an excel sheet using a shell script. i have converted the output text file to an excel and got the desired output. However, in a particular column in the excel the values of the numbers start with 0. e.g. 078393343, 00342442, etc. But, in the resulting excel I get as... (2 Replies)
Discussion started by: Vijay06
2 Replies

8. UNIX for Advanced & Expert Users

Need Help on Excel with Unix

Hi, My client uploads an Excel file on to Unix server by using web application with more than 20 columns and more than 60000 records in it. I have to check the data in each cell when the file arrived. Is is possible to check the data in cells by running unix script? or Is there any way to convert... (2 Replies)
Discussion started by: sireeshp
2 Replies

9. Shell Programming and Scripting

Spilt excel file in unix

Hi friends... I am sending a file say xyz.xls to a mail through unix. The .xls file is more than 65 thousand in size so I want to spilt the file size into 40 thousand and 25 thousand. So can anyone provide any inputs.... (1 Reply)
Discussion started by: Soumya Dash
1 Replies

10. UNIX for Advanced & Expert Users

Opening an Excel File in Unix

Hi all, I want to open an Excel file in Unix(ABC.xls) and copy one column of the file onto another text file (xyz.txt) .Please let me know if there is a way of going about to perform this operation. Thanks in Advance, bubeshj (5 Replies)
Discussion started by: bubeshj
5 Replies
Login or Register to Ask a Question