06-15-2013
In VBA, there is a system call, whose name temporarily escapes me, to run an external windows command. You could use that to e.g. telnet into the unix machine, run a script and harvest the result into a VBA variable, which then can be handed over to EXCEL.
9 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
i want to install ScO UNIX 5.1 in a windows 98 system.
i want it as a DUAL BOOT system. can i doit? If yes How.
and also i want to network unix with my clients. is it poosible to network both unix & windows thru a single network card.
if yes how?
also i wanted to know that thru a switch can i... (3 Replies)
Discussion started by: jigs
3 Replies
2. IP Networking
I have a client who is operating a SCO UNIX 4.3 server with Informix 4.12. My problem is that I need to get hold of the data using a Windows PC.
Where the hell do I start? :confused:
Thanks
Richard.
rgray@euriskotechnology.com (3 Replies)
Discussion started by: euriskotech
3 Replies
3. Shell Programming and Scripting
Hi,
Is there any method to connect unix box(Excecuting unix commands through Batch Files) through DOS prompt. (1 Reply)
Discussion started by: shekhar_ssm
1 Replies
4. UNIX for Advanced & Expert Users
Hey,
I need to setup a passwordless connectivity from one Unix machine to another unix machine.
I have the passwords for both the machines.
Need from
user@host1 to
user@host2
Please help.
Thanks,
Robin (3 Replies)
Discussion started by: robinbannis
3 Replies
5. AIX
Hi,
We have installed oracle on a AIX machine and when we try to connect to AIX machine from oracle client installed on a windows machine or do a telnet to AIX machine on 1521 port , it throws an error connection refused on port 1521 , where all the ports and firewalls are open from windows to... (2 Replies)
Discussion started by: adityakp123
2 Replies
6. Solaris
I have installed Open Solaris 10 on VMware which is hosted on Windows XP, my PC.
I would like to have a connection between Solaris and Windows, so that i can SSH/Telnet from windows to Solaris. I don't have any Internet connection.
Please help me with the network connection settings i have to... (3 Replies)
Discussion started by: mailsachin245
3 Replies
7. Shell Programming and Scripting
Hi,
I am trying to connect to the database through Unix serer using following command-
mysql -u root -Jepadt -D dtdatabase
But it giving me error -
mysql: unknown option '-J'
Can anybody help me to solve this problm
Thanks in advance
Please use code tags, thanks. (2 Replies)
Discussion started by: pspriyanka
2 Replies
8. Solaris
:wall:
Hello Solaris Users. Although a fundamental skill I am still new to connecting computers together in order that they can see each other, ie. via ping-ing of IP's and/or hostnames.
I wish to install Oracle 10g database on Sun Blade 1500 and access this from Windows XP laptop (running... (5 Replies)
Discussion started by: patcom
5 Replies
9. Shell Programming and Scripting
Hi,
I want a script for connecting teradata to load the file to teradata table.
Can you please help me out.
Thanks in advance. (1 Reply)
Discussion started by: victory
1 Replies
LEARN ABOUT DEBIAN
text::csv::encoded::coder::encodeguess
Text::CSV::Encoded::Coder::EncodeGuess(3pm) User Contributed Perl Documentation Text::CSV::Encoded::Coder::EncodeGuess(3pm)
NAME
Text::CSV::Encoded::Coder::EncodeGuess - Text::CSV::Encoded coder class using Encode::Guess
SYNOPSIS
use Text::CSV::Encoded coder_class => 'Text::CSV::Encoded::Coder::EncodeGuess';
use Spreadsheet::ParseExcel;
my $csv = Text::CSV::Encoded->new();
$csv->encoding( ['ucs2', 'ascii'] ); # guessing ucs2 or ascii?
$csv->encoding_to_combine('shiftjis');
my $excel = Spreadsheet::ParseExcel::Workbook->Parse( $file );
my $sheet = $excel->{Worksheet}->[0];
for my $row ( $sheet->{MinRow} .. $sheet->{MaxRow} ) {
my @fields;
for my $col ( $sheet->{MinCol} .. $sheet->{MaxCol} ) {
my $cell = $sheet->{Cells}[$row][$col];
push @fields, $cell->{Val};
}
$csv->combine( @fields ) or die;
print $csv->string, "
";
}
DESCRIPTION
This module is inherited from Text::CSV::Encoded::Coder::Encode.
USE
Except for 2 attributes, same as Text::CSV::Encoded::Coder::Encode.
encoding_in
$csv = $csv->encoding_in( $encoding_list_ref );
The accessor to an encoding for pre-parsing CSV strings. If no encoding is given, returns current $encoding, otherwise the object itself.
$encoding_list_ref = $csv->encoding_in()
When you pass a list reference, it might guess the encoding from the given list.
$csv->encoding_in( ['shiftjis', 'euc-jp', 'iso-20022-jp'] );
If it cannot guess the encoding, the first encoding of the list is used.
encoding
$csv = $csv->encoding( $encoding_list_ref );
$encoding_list_ref = $csv->encoding();
You can pass a list reference to this attribute only:
* For list data consumed by combine().
* For list reference returned by getline().
In other word, in "combine" and "print", it might guess an encoding for the passing list data. If it cannot guess the encoding, the first
encoding of the list is used.
SEE ALSO
Encode, Encode::Guess
AUTHOR
Makamaka Hannyaharamitu, <makamaka[at]cpan.org>
COPYRIGHT AND LICENSE
Copyright 2008-2010 by Makamaka Hannyaharamitu
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2010-04-26 Text::CSV::Encoded::Coder::EncodeGuess(3pm)