Sponsored Content
Full Discussion: Formatting excel file
Special Forums Hardware Filesystems, Disks and Memory Formatting excel file Post 27590 by peter.herlihy on Wednesday 4th of September 2002 03:32:36 AM
Old 09-04-2002
Try this thread.
 

10 More Discussions You Might Find Interesting

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

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

3. Shell Programming and Scripting

Excel formatting

Dear folks, Need a help in Excel processing, I have a sheet which need to be changed to a format as below: Name Eng Hin SS A 100 90 83 B 76 99 90 C 55 34 78 Want the above sheet to below format Name Sub Marks A Eng 100 ... (5 Replies)
Discussion started by: shaliniyadav
5 Replies

4. Shell Programming and Scripting

Problem in formatting output of SQL query in excel sheet in shell script

Hi Guys.. Need your help to format the output of my shell script. I am using spool command to take out put in csv file. below is my code. (for example) col USERNAME for a15 col EMAIL for a30 col FULL_NAME for a20 col LAST_LOGIN for a40 col DATE_CREATED for a40 SPOOL 120.csv... (3 Replies)
Discussion started by: Agupte
3 Replies

5. Shell Programming and Scripting

Formatting Shell script output to Excel

I am facing a problem formatting the output of my shell script in excel. We are directing the output of the script to an excel sheet and need long integer type data printed in Excel as it is (i.e. not in the default scientific notation). Also, leading zeroes(if any) in the output are getting... (4 Replies)
Discussion started by: bornali.p
4 Replies

6. Shell Programming and Scripting

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

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

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

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

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
IRC::Formatting::HTML(3pm)				User Contributed Perl Documentation				IRC::Formatting::HTML(3pm)

NAME
IRC::Formatting::HTML - Convert between HTML and IRC formatting VERSION
Version 0.29 SYNOPSIS
Convert raw IRC formatting to HTML use IRC::Formatting::HTML qw/irc_to_html html_to_irc/; ... my $irctext = "02031,2Iron & Wine"; my $html = irc_to_html($irctext); print $html # the above will print: # <span style="font-weight: bold;color: #000; background-color: #008">Iron &amp; Wine</span> ... my $html = "<b><em>Nicotine and gravy</em></b>"; my $irctext = html_to_irc($html); print $html; # the above will print: # 0226Nicotine and Gravy0226 FUNCTIONS
irc_to_html irc_to_html($irctext, invert => "italic") Takes an irc formatted string and returns the HTML version. Takes an option to treat inverted text as italic text. html_to_irc html_to_irc($html) Takes an HTML string and returns an irc formatted string AUTHOR
Lee Aylward, <leedo@cpan.org> BUGS
Please report any bugs or feature requests to "bug-irc-formatting-html at rt.cpan.org", or through the web interface at http://rt.cpan.org/NoAuth/ReportBug.html?Queue=IRC-Formatting-HTML <http://rt.cpan.org/NoAuth/ReportBug.html?Queue=IRC-Formatting-HTML>. I will be notified, and then you'll automatically be notified of progress on your bug as I make changes. SUPPORT
You can find documentation for this module with the perldoc command. perldoc IRC::Formatting::HTML You can also look for information at: o RT: CPAN's request tracker http://rt.cpan.org/NoAuth/Bugs.html?Dist=IRC-Formatting-HTML <http://rt.cpan.org/NoAuth/Bugs.html?Dist=IRC-Formatting-HTML> o AnnoCPAN: Annotated CPAN documentation http://annocpan.org/dist/IRC-Formatting-HTML <http://annocpan.org/dist/IRC-Formatting-HTML> o CPAN Ratings http://cpanratings.perl.org/d/IRC-Formatting-HTML <http://cpanratings.perl.org/d/IRC-Formatting-HTML> o Search CPAN http://search.cpan.org/dist/IRC-Formatting-HTML/ <http://search.cpan.org/dist/IRC-Formatting-HTML/> ACKNOWLEDGEMENTS
This is a direct port of Sam Stephenson's ruby version. COPYRIGHT &; LICENSE Copyright 2009 Lee Aylward, all rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.12.4 2011-01-13 IRC::Formatting::HTML(3pm)
All times are GMT -4. The time now is 05:55 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy