Sponsored Content
Full Discussion: WINDOWS to UNIX : xls to csv
Top Forums UNIX for Dummies Questions & Answers WINDOWS to UNIX : xls to csv Post 302151403 by preethgideon on Saturday 15th of December 2007 05:02:25 AM
Old 12-15-2007
Hey,
I did not find the file as .xls in the WINDOWS command prompt but a .txt file though in reality it is an .xls file. Sounds strange right ?

But when I ftp'd the file I got the data as it was in the xls.

Thanks for the "hint". Worked for me Smilie. Nevertheless if you could let me know more on OLE would be great.

Thanks and Regards
Gideon.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting csv to xls

Hi, Can anyone tell the option to change the file type in unix. i.e. if a file is in csv(Comma Separating Values) format, it should be changed to xls(ordinary MS-Excel) format. But renaming command is not changing to correct file format. Thanks in advance, Milton. (1 Reply)
Discussion started by: miltony
1 Replies

2. Shell Programming and Scripting

xls to csv

how to convert a xls file into .csv file? is tghere any command in unix for that? please help thanks (3 Replies)
Discussion started by: infyanurag
3 Replies

3. 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. (1 Reply)
Discussion started by: moon_friend
1 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. Shell Programming and Scripting

how to convert .xls to .csv

Hi, I have problem..How to convert .xls file to .csv.. Plz help me for this problem.. (1 Reply)
Discussion started by: varma457
1 Replies

6. UNIX for Dummies Questions & Answers

Windows CSV file to unix csvfile

how do i copy a windows csv file (client) to a unix csv file ie in the correct unix format? (1 Reply)
Discussion started by: zhegal
1 Replies

7. Shell Programming and Scripting

CSV to XLS

Ok, every morning at my office we send out excel sheets to Economy people with statistics for yesterdays trading. All the trading run's in Redhat or Solaris environments. We run a script on a Redhat server whitch generates the stats in CSV format. After we download we open it in Excel and... (3 Replies)
Discussion started by: chipmunken
3 Replies

8. UNIX and Linux Applications

Tool for Convert XLS into CSV in UNIX

Hi I wanted to convert some XLS files into CSV format in my UNIX box. Unix box is handling very important data which are related to data warehouse.It is fully optimized by installing minimum packages since server need more resources to handle reports generating. Just for convert XLS files... (6 Replies)
Discussion started by: luke_devon
6 Replies

9. Shell Programming and Scripting

Oracle to CSV to XLS

I would like to know if have one way with read table from oracle converter in CSV o TXT and After converter in XLS or spreedsheet Thanks so much JAvier (3 Replies)
Discussion started by: javeiregh
3 Replies

10. Shell Programming and Scripting

Csv to xls

Hello I have a script which converts log to csv. Now I need to have xls. Is there any easy way/command which can convert csv to xls?:confused: preferably just using bash and not perl,... is it possible? (1 Reply)
Discussion started by: frhling
1 Replies
OLE::Storage_Lite(3pm)					User Contributed Perl Documentation				    OLE::Storage_Lite(3pm)

NAME
OLE::Storage_Lite - Simple Class for OLE document interface. SYNOPSIS
use OLE::Storage_Lite; # Initialize. # From a file my $oOl = OLE::Storage_Lite->new("some.xls"); # From a filehandle object use IO::File; my $oIo = new IO::File; $oIo->open("<iofile.xls"); binmode($oIo); my $oOl = OLE::Storage_Lite->new($oFile); # Read data my $oPps = $oOl->getPpsTree(1); # Save Data # To a File $oPps->save("kaba.xls"); #kaba.xls $oPps->save('-'); #STDOUT # To a filehandle object my $oIo = new IO::File; $oIo->open(">iofile.xls"); bimode($oIo); $oPps->save($oIo); DESCRIPTION
OLE::Storage_Lite allows you to read and write an OLE structured file. OLE::Storage_Lite::PPS is a class representing PPS. OLE::Storage_Lite::PPS::Root, OLE::Storage_Lite::PPS::File and OLE::Storage_Lite::PPS::Dir are subclasses of OLE::Storage_Lite::PPS. new() Constructor. $oOle = OLE::Storage_Lite->new($sFile); Creates a OLE::Storage_Lite object for $sFile. $sFile must be a correct file name. The "new()" constructor also accepts a valid filehandle. Remember to "binmode()" the filehandle first. getPpsTree() $oPpsRoot = $oOle->getPpsTree([$bData]); Returns PPS as an OLE::Storage_Lite::PPS::Root object. Other PPS objects will be included as its children. If $bData is true, the objects will have data in the file. getPpsSearch() $oPpsRoot = $oOle->getPpsTree($raName [, $bData][, $iCase] ); Returns PPSs as OLE::Storage_Lite::PPS objects that has the name specified in $raName array. If $bData is true, the objects will have data in the file. If $iCase is true, search is case insensitive. getNthPps() $oPpsRoot = $oOle->getNthPps($iNth [, $bData]); Returns PPS as "OLE::Storage_Lite::PPS" object specified number $iNth. If $bData is true, the objects will have data in the file. Asc2Ucs() $sUcs2 = OLE::Storage_Lite::Asc2Ucs($sAsc>); Utility function. Just adds 0x00 after every characters in $sAsc. Ucs2Asc() $sAsc = OLE::Storage_Lite::Ucs2Asc($sUcs2); Utility function. Just deletes 0x00 after words in $sUcs. OLE
::Storage_Lite::PPS OLE::Storage_Lite::PPS has these properties: No Order number in saving. Name Its name in UCS2 (a.k.a Unicode). Type Its type (1:Dir, 2:File (Data), 5: Root) PrevPps Previous pps (as No) NextPps Next pps (as No) DirPps Dir pps (as No). Time1st Timestamp 1st in array ref as similar fomat of localtime. Time2nd Timestamp 2nd in array ref as similar fomat of localtime. StartBlock Start block number Size Size of the pps Data Its data Child Its child PPSs in array ref OLE
::Storage_Lite::PPS::Root OLE::Storage_Lite::PPS::Root has 2 methods. new() $oRoot = OLE::Storage_Lite::PPS::Root->new( $raTime1st, $raTime2nd, $raChild); Constructor. $raTime1st, $raTime2nd are array refs with ($iSec, $iMin, $iHour, $iDay, $iMon, $iYear). $iSec means seconds, $iMin means minutes. $iHour means hours. $iDay means day. $iMon is month -1. $iYear is year - 1900. $raChild is a array ref of children PPSs. save() $oRoot = $oRoot>->save( $sFile, $bNoAs); Saves information into $sFile. If $sFile is '-', this will use STDOUT. The "new()" constructor also accepts a valid filehandle. Remember to "binmode()" the filehandle first. If $bNoAs is defined, this function will use the No of PPSs for saving order. If $bNoAs is undefined, this will calculate PPS saving order. OLE
::Storage_Lite::PPS::Dir OLE::Storage_Lite::PPS::Dir has 1 method. new() $oRoot = OLE::Storage_Lite::PPS::Dir->new( $sName, [, $raTime1st] [, $raTime2nd] [, $raChild>]); Constructor. $sName is a name of the PPS. $raTime1st, $raTime2nd is a array ref as ($iSec, $iMin, $iHour, $iDay, $iMon, $iYear). $iSec means seconds, $iMin means minutes. $iHour means hours. $iDay means day. $iMon is month -1. $iYear is year - 1900. $raChild is a array ref of children PPSs. OLE
::Storage_Lite::PPS::File OLE::Storage_Lite::PPS::File has 3 method. new $oRoot = OLE::Storage_Lite::PPS::File->new($sName, $sData); $sName is name of the PPS. $sData is data of the PPS. newFile() $oRoot = OLE::Storage_Lite::PPS::File->newFile($sName, $sFile); This function makes to use file handle for geting and storing data. $sName is name of the PPS. If $sFile is scalar, it assumes that is a filename. If $sFile is an IO::Handle object, it uses that specified handle. If $sFile is undef or '', it uses temporary file. CAUTION: Take care $sFile will be updated by "append" method. So if you want to use IO::Handle and append a data to it, you should open the handle with "r+". append() $oRoot = $oPps->append($sData); appends specified data to that PPS. $sData is appending data for that PPS. CAUTION
A saved file with VBA (a.k.a Macros) by this module will not work correctly. However modules can get the same information from the file, the file occurs a error in application(Word, Excel ...). DEPRECATED FEATURES
Older version of "OLE::Storage_Lite" autovivified a scalar ref in the "new()" constructors into a scalar filehandle. This functionality is still there for backwards compatibility but it is highly recommended that you do not use it. Instead create a filehandle (scalar or otherwise) and pass that in. COPYRIGHT
The OLE::Storage_Lite module is Copyright (c) 2000,2001 Kawai Takanori. Japan. All rights reserved. You may distribute under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl README file. ACKNOWLEDGEMENTS
First of all, I would like to acknowledge to Martin Schwartz and his module OLE::Storage. AUTHOR
Kawai Takanori kwitknr@cpan.org This module is currently maintained by John McNamara jmcnamara@cpan.org SEE ALSO
OLE::Storage Documentation for the OLE Compound document has been released by Microsoft under the Open Specification Promise. See http://www.microsoft.com/interop/docs/supportingtechnologies.mspx The Digital Imaging Group have also detailed the OLE format in the JPEG2000 specification: see Appendix A of http://www.i3a.org/pdf/wg1n1017.pdf perl v5.10.1 2009-11-24 OLE::Storage_Lite(3pm)
All times are GMT -4. The time now is 03:06 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy