Generating xls with utf-8 format

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to create a file from output of vertica table query in UTF-8 format?

Hello, In my shell script, I extract table data from HP Vertica DB into a csv file using vsql -c command. But the problem is the file getting created is in binary format and hence some of the data becomes unreadable which has chinese characters as part of data. file -i filename.csv - gives...

2. Shell Programming and Scripting

Merging Multiple XLS into Different tabs in xls/ xlsx

HI, I have multiple files per dept in folder for eg : In a folder File1_Dept100.xls File2_Dept100.xls File3_Dept100.xls File1_Dept200.xls File2_Dept200.xls File3_Dept200.xls Output should be : Dept100.xls which has File1, File2, File3 in different tabs Dept200.xls which has...

3. Linux

Help to Convert file from UNIX UTF-8 to Windows UTF-16

Hi, I have tried to convert a UTF-8 file to windows UTF-16 format file as below from unix machine unix2dos < testing.txt | iconv -f UTF-8 -t UTF-16 > out.txt and i am getting some chinese characters as below which l opened the converted file on windows machine. LANG=en_US.UTF-8...

4. Shell Programming and Scripting

Converting text files to xls through awk script for specific data format

Dear Friends, I am in urgent need for awk/sed/sh script for converting a specific data format (.txt) to .xls. The input is as follows: >gi|1234|ref| Query = 1 - 65, Target = 1677 - 1733 Score = 8.38, E = 0.6529, P = 0.0001513, GC = 46 fd sdfsdfsdfsdf fsdfdsfdfdfdfdfdf...

5. Shell Programming and Scripting

Output in xls format

Hi, I need the output of sql query which is executed using a shell script to xls file format.

6. Shell Programming and Scripting

perl module to convert xlsx format to xls format

Hi Folks, I have written a perl script that reads data from excel sheet(.xls) using Spreadsheet::ParseExcel module. But the problem is this module doesn't work for excel sheets with extension .xlsx. I have gone through Spreadsheet::XLSX module with which we can read from .xlsx file directly....

7. Shell Programming and Scripting

Clearcase ucm baseline differences report in xls format

Hi All, Can any one help me to get the shell/perl scripts for the below requirements. 1: To get the clearcase checkin's information between two lables generate a formatted Xls output and to find the added changed and removed files and versions between the ClearCase baselines. 2...

8. UNIX for Dummies Questions & Answers

Unix script to convert .csv file to.xls format

I have a .csv file in Unix box i need a UNIX script to convert the.csv files to.xls format. Its very urgent please help me.

9. Shell Programming and Scripting

Convert a csv file to an xls format

Hi, I have a file coming in xxx.txt(csv format) i do some work on it and i need to send out as a .xls format. Is there any way there is some code i can use in my script to convert this? I'm struggling on this. Thanks

10. Shell Programming and Scripting

conert the pipe delimated file into xls format

Hi I have spool file which is pipe delimated and i want to convert it into xls . Is any tool or method availabe in UNIX for this kind of conversion

LEARN ABOUT REDHAT

gtf

GTF(1)							      General Commands Manual							    GTF(1)

NAME

       gtf - calculate VESA GTF mode lines

SYNOPSIS

       gtf h-resolution v-resolution refresh [-v|--verbose] [-f|--fbmode] [-x|--xf86mode]

DESCRIPTION

       Gtf  is	a  utility  for  calculating  VESA GTF modes.  Given the desired horizontal and vertical resolutions and refresh rate (in Hz), the
       parameters for a matching VESA GTF mode are printed out.  Two output formats are supported: mode lines suitable for  the  XFree86  XF86Con-
       fig(5x) file, and mode parameters suitable for the Linux fbset(8) utility.

OPTIONS

       -v|--verbose
	       Enable verbose printouts  This shows a trace for each step of the computation.

       -x|--xf86mode
	       Print the mode parameters as XFree86-style mode lines.  This is the default format.

       -f|--fbset
	       Print the mode parameters in a format suitable for fbset(8).

SEE ALSO

       XF86Config(5x)

AUTHOR

       Andy Ritger.

       This  program  is  based on the Generalized Timing Formula (GTF(TM)) Standard Version: 1.0, Revsion: 1.0.  The GTF Excel(TM) spreadsheet, a
       sample (and the definitive) implementation of the GTF Timing Standard is available at <ftp://ftp.vesa.org/pub/GTF/VTF_V1R1.xls>.

XFree86 						       Version Version 4.3.0							    GTF(1)

Shell Programming and Scripting