Sponsored Content
Top Forums Shell Programming and Scripting Writing excel file using perl : Excel file formatting changed Post 302793491 by mud_born on Friday 12th of April 2013 12:38:59 PM
Old 04-12-2013
Writing excel file using perl : Excel file formatting changed

I am trying to create a program where user can input data in certain excel cells using user interface on internet....the programming is on perl and server is unix

But when i parse data into excel the formatting of sheets is turned to default and all macro coding removed.

What to do...Please HelpSmilie
 

10 More Discussions You Might Find Interesting

1. Filesystems, Disks and Memory

Formatting excel file

Hi, I have a problem in formatting the excel file from my script. Assume that there is a text file generated using a 'C shell Unix script' with a format similar to the one seen below. Each column has a fixed length and every row is going to have a value against a column depending on the... (1 Reply)
Discussion started by: subra
1 Replies

2. 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

3. Shell Programming and Scripting

PERL: Modify Excel cell formatting

Hi, I would like to modify an existing excel cell format to a custom format. Is there a way to do it with out writing into a new excel file. In-place editing? Thanks (0 Replies)
Discussion started by: sandeep78
0 Replies

4. Shell Programming and Scripting

creating excel file using perl

Hi , I am writing a simple excel file and want to create the file under say 'D:\Documents and Settings'. The problem with my code is it is writing in the same directory instead of the specified. Here is a sample code use Spreadsheet::WriteExcel; my $workbook =... (1 Reply)
Discussion started by: daptal
1 Replies

5. Shell Programming and Scripting

perl : date from excel(.xlsx) not printed properly(format is changed)

I am trying to convert xlsx sheet to a csv file. In .xlsx file there a cell with date Mon 08/27/12 while reading this cell using Spreadsheet::XLSX, the output is display with numeric value i.e., 41148. from Spreadsheet::XLSX module : use Text::Iconv; my $converter =... (1 Reply)
Discussion started by: giridhar276
1 Replies

6. 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

7. Shell Programming and Scripting

Data formatting in CSV file to EXCEL

Hello friends I want to convert an csv file on unix (which is generated by a ETL application) to a formatted excel sheet like .I have roughly like 28 columns 1)All numbers need to be stored as numbers with leading zeros-like format as text for this column to preserve leading zeroes e.g... (6 Replies)
Discussion started by: etldev
6 Replies

8. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies

9. Shell Programming and Scripting

Writing xml from excel sheet .xls using perl script

Hi all. I am working on the below requirement of generating .xml file from .xls file which i have , can someone please help me or in writing the perl script for the same: The xls file format is as below which has two columns and number of rows are not fixed: Fixlet Name ... (12 Replies)
Discussion started by: omkar.jadhav
12 Replies

10. Shell Programming and Scripting

Formatting data to put it in the excel file

Hello, I have a file with the below contents : Policy Name: Backup_bkp Policy Type: Catalog_bkp Active: yes Effective date: 08/07/2013 02:02:12 Mult. Data Streams: no Client Encrypt: no Checkpoint: no Policy Priority: ... (11 Replies)
Discussion started by: rahul2662
11 Replies
CDDB-TOOL(1)						      General Commands Manual						      CDDB-TOOL(1)

NAME
cddb-tool - Get CDDB information SYNOPSIS
cddb-tool parse file [-i|-d|-a|-t] [num|-c|-p] cddb-tool template disc-id tracks cddb-tool send [file] address cddb-tool query server user host disc-id tracks cddb-tool read server user host disc-id genre cddb-tool help DESCRIPTION
cddb-tool is a backend tool for abcde. It is passed information from cd-discid and uses it look up the CD title, artist, and track informa- tion on the cddb database (http://freedb.freedb.org) on the internet. COMMANDS
parse [file] option Get data out of a cddb file (use "-" for stdin). Options (use one and only one): id prints disc id album prints album title track num prints title of track num artist prints artist category prints category cddbgenre synonym for category all parse file and dumps to stdout in a form sourceable by the shell send [file] address Mails file file (or stdin of no file specified) to specified address, using correct format. Category should be one of blues, classical, country, data, folk, jazz, newage, reggae, rock, soundtrack, misc. template [disc-id] [tracks] Generates a template (empty) cddb file to stdout. The command line should be essentially the output of cd-discid. query [server] [user] [host] [disc-id] [tracks] Looks up disc on server (should be of form "http://host/cddb/cddb.cgi") remainder of command line is in the same form as that returned by the cd-discid program. Uses wget, so if you need to use a proxy then just configure wget to do so. user and host will be used for identify- ing ourselves to the CDDB server. Outputs response code and entries with matching CDDB entries, if successful, from the CDDB server. read [server] [user] [host] [disc-id] [genre] Dumps CDDB entry to stdout. File will contain an extra #CATEGORY= line, which leaves it a valid CDDB file but which will be recognized by parse and send commands. Uses wget, so if you need to use a proxy then just configure wget to do so. user and host will be used for identi- fying ourselves to the CDDB server. help Prints usage information. AUTHOR
Nathaniel Smith <njs@uclink4.berkeley.edu>, maintained as part of abcde by Robert Woodcock <rcw@debian.org>. Manual page compiled from help information by Robert Woodcock. CDDB-TOOL(1)
All times are GMT -4. The time now is 06:21 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy