Sponsored Content
Top Forums Shell Programming and Scripting connvert xls file to any other file Post 302139598 by rinku on Monday 8th of October 2007 06:04:49 AM
Old 10-08-2007
I want to store the data of .xls file into database.
For that purpose I want a comma separeted file.
Then I can insert the data into database.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

copying the csv file into different worksheets of xls file

Hi, I have a script which will generate three csv files. i want to copy the contents of these csv files into a .XLS file but in different worksheets. Can a this be done in the same script? :confused: Can Perl come to my help in coping the csv files into different worksheets of .XLS file ?... (0 Replies)
Discussion started by: nimish
0 Replies

2. UNIX for Dummies Questions & Answers

renaming xls file

I am trying to move and rename an excel file by appending date to it but i am not getting the desired result mv SrcFiles/Sales.xls SrcFiles/SG_Archive/Sales_`date +%Y%m%d%H%M%S`.xls result:- Sales_Ym63HM desired result - Sales_200710171323.xls (2 Replies)
Discussion started by: systemsb
2 Replies

3. Shell Programming and Scripting

convert a txt file to xls file

How to convert a txt file(tab delimiter) to xls file. Looking forward help. Thanks, Venkatesh. (2 Replies)
Discussion started by: venkatesht
2 Replies

4. Shell Programming and Scripting

converting xls file to txt file and xls to csv

I need to convert an excel file into a text file and an excel file into a CSV file.. any code to do that is appreciated thanks (6 Replies)
Discussion started by: bandar007
6 Replies

5. UNIX for Dummies Questions & Answers

To convert a txt file to .xls file

i want to convert a comma seprated file into a .xls file the file contains 3 fields seprated by a comma. i want to convert it into a .xls file with 3 columns and 37 rows DPRPT400,01/15/2009-15:03:06,01/15/2009-15:03:08 DPRPT401,01/15/2009-15:03:15,01/15/2009-15:03:32... (11 Replies)
Discussion started by: manit
11 Replies

6. Shell Programming and Scripting

Conversion of .xls file to .csv file

Hi Folks, I've to convert manually couple of *.xls files to *.csv files everyday :( so i was just wondering if anyone could just help me with a shell script or awk script to automate the process :) PS : Problem is that i cannot use any third party software for the conversion. Thanking... (1 Reply)
Discussion started by: chaturvedi
1 Replies

7. AIX

How to convert csv file to xls file

Hi All, I have a java program running in AIX machine which gives me the output in form of .CSV but my clients wants output in the form of .xls When I gave the command mv <filename.csv> <filename.xls> The contents of this .xls file is not exactly in seprate columns as in CSV, the contents... (1 Reply)
Discussion started by: chetu777
1 Replies

8. UNIX for Advanced & Expert Users

Converting .csv file into .xls file and send it to inbox

Hi All, I wrote a script to extract data from Oracle DB and place it in a text file , and I have coverted .txt file into comma seperated .csv file and I sent it to my mail box . I can get .xls file in my inbox.I am getting all data in same column and in different rows , without column... (1 Reply)
Discussion started by: krthkmuthu
1 Replies

9. Shell Programming and Scripting

Unzipping a file in Solaris - Issue with xls file

Hi, I have an excel file generated by system in windows. I am zipping it, transfering to unix and unzipping there. But i'm getting below output while unzipping. $ /usr/bin/unzip -a 123.zip -d . Archive: 123.zip inflating: ./123/Index.xls When i copy this unzipped xls file to... (0 Replies)
Discussion started by: ajaykumarb
0 Replies

10. UNIX for Beginners Questions & Answers

Convert Excel File (xls) to tab delimited text file on AIX

Hi i have a problem in my job i try to convert an excel file (xls extention) to text file (tab delimited), but no result with this comand cat xxx.xls > xxx.txt Do you have eny idea? PS: sorry for my english Thanks!! (4 Replies)
Discussion started by: frisso
4 Replies
XrmPutStringResource()													    XrmPutStringResource()

Name
  XrmPutStringResource - add a resource specification with separate resource name and value.

Synopsis
  void XrmPutStringResource(database, specifier, value)
	  XrmDatabase *database;
	  char *specifier;
	  char *value;

Arguments
  database  Specifies  a pointer to the resource database.  If database contains NULL, a new resource database is created and a pointer to it
	    is returned in database.

  specifier Specifies the resource, as a string.

  value     Specifies the value of the resource, as a string.

Description
  XrmPutStringResource() adds a resource specification with the specified resource and value to the specified database.  The specifier string
  may  contain	both  names and classes, bound with either loose (*) or tight (.) bindings.  See the description of XrmGetResource() for more
  information about bindings.

  The representation type used in the database is String.  If the specifier is not in the Host Portable Character  Encoding,  the  result  is
  implementation-dependent.  The value is stored in the database without modification.

  XrmPutResource(),  XrmQPutResource(),  XrmPutStringResource(), XrmQPutStringResource() and XrmPutLineResource() all store data into a data-
  base.  See XrmQPutResource() for the most complete description of this process.

  For more information, see Volume One, Chapter 13, Managing User Preferences.

Structures
  XrmDatabase is a pointer to an opaque data type.

See Also
  XrmDestroyDatabase(), XrmGetFileDatabase(), XrmGetResource(), XrmGetStringDatabase(),  XrmInitialize(),  XrmMergeDatabases(),  XrmParseCom-
  mand(),  XrmPutFileDatabase(),  XrmPutLineResource(),  XrmPutResource(),  XrmQGetResource(),	XrmQGetSearchList(), XrmQGetSearchResource(),
  XrmQPutResource(), XrmQPutStringResource(), XrmQuarkToString(), XrmStringToBindingQuarkList(), XrmStringToQuarkList(),  XrmStringToQuark(),
  XrmUniqueQuark().

Xlib - Resource Manager 												    XrmPutStringResource()
All times are GMT -4. The time now is 10:25 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy