6

How to import text file generated in solaris 10 unix box into excel file's worksheet

view full story
linux-howto

http://www.unix.com – Dear all, I got a flat file (test.txt) generated in solaris unix box attached . There is an excel file which contains some formula requested by end users to do analysis based on data in text file. I just want to import the content of the text file into excel file (which is put into unix box as well) automatically by unix script when the text file is generated every day. I think this action should be done via java called by unix script as well. Since I am newbie in java, does anybody know how to do it or give me some sample programs? or apart from java, can any other language do it ? The u (HowTos)

Shoutmeloud's picture
Submitted by Shoutmeloud on 04/03/2012 – Made popular on 04/03/2012

Stories similar to How to import text file generated in solaris 10 unix box into excel file's worksheet

Connect direct script for unix 35 weeks 5 days ago

I want to connect direct a xml file and a excel file each separately from unix system to another unix system.The size of the xml file and excel file may vary each time.

Below is the possible connect direct script to transfer the files.Please check if it is correct?

Also does DCB parameter required ?If required what should be the code for it?

==============

Code: submit do_copy process

parsing text file in android 13 weeks 3 days ago

In my application, I create a text file to save readings, and the values look like this:

98, 97, 98, ......

I need to get the readings from the text file and save them in an arraylist.

hi, when i finish running some scripts in unix...some csv file is getting generated...now im manually taking this csv file from this generated directory and using FTP, i'm importing to windows os and saving in a directory... please give me a script to automate this..so that i can add in my existing script ...for importing to windows automatically

Hi All, found similar posts, but not exatcly what i wanted.

I have an text file like below and am trying to send mail as an excel file but when i get the excel file as the attachment, all the data is coming in the first column.

I have a text file in which I have something like this-

10.2.57.44 56538154 3028 120.149.20.197 28909678 3166 10.90.158.161 869126135 6025

In that text file, I have around 1,000,000 rows exactly as above. I am working in SunOS environment. I needed a way to remove everything from that text file leaving only IP Address (first column in the above text file is IP Address).

I do have a shell file where I call many unix commands . I would like to add a regular expression step in that shell file, where a text file, say Test.txt has to be openned and all the :'s should be replaced. Basically apply the follwoing regular expression:

Code: :%s/://g to that particular text file, which is generated from a previous command in that shell script. Please let me know

Hi Gurus,

I am working on a script that sends a text file attachment on mail from unix server to my widows outlook mail box.

When i see the text file in UNIX it is perfectly formatted but when i open the same file in the mail, it looks weird as the next line is added to the same line.

For example, in unix the file looks like,

Code: ABC#DEF GHI#JKL MNO#PQR But the mail attachment looks lik

Hello Experts, I have the following questions to be discussed here at this esteemed discussion forum. I have two Excel sheets which contain Unix Commands llike creating directory the structure/ftp/Copy/Zip etc to basically create an environment.

Hi,

I have a requirement where users will send excel(.xls) file to Linux Platform using ftp/sftp. After that the excel file needs to be read using java on linux and converted into csv.

I am using jxl to parse the excel, but few character like £ are not getting parsed properly. If i open the output csv file on linux it looks like �

Any suggetsion to resolve this please.

thanks, Joydeep